Category:Cumulus MX: Difference between revisions

m
Line 719: Line 719:
The remaining 6 drop-down sections are optional, you choose which you want to use, they appear on the screen in a different order to how I explain them below.
The remaining 6 drop-down sections are optional, you choose which you want to use, they appear on the screen in a different order to how I explain them below.


The optional settings described below, allow you to choose which log file to use for such automatic updates and what to call the table uploaded to (uploads will not work before the required table has been created). Alternatively, you can devise your own schema, create that table, and then write the SQL to update your table using web tags to supply all the values. You need to turn on enhanced debug logging to see any confirmation that the SQL has run.
*Some of the optional settings described below, allow you to choose which log file to use for such automatic updates and what to call the table uploaded to (uploads will not work before the required table has been created).
*Alternatively, you can devise your own schema, create that table, and then write the SQL to update your table using web tags to supply all the values.  
*You need to turn on enhanced debug logging to see any confirmation that the standard or custom SQL has run. With enhanced logging you will see messages like:
<pre>2020-04-09 10:00:01.047 MySQL: 2 rows were affected.</pre>
<pre>2020-04-09 10:00:01.047 MySQL: 2 rows were affected.</pre>


5,838

edits