1,651
edits
m (Protected "Cumulusmx.db": Edit warring ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]) |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[Category:Cumulus MX]][[Category:Cumulus Files]] | [[Category:Cumulus MX]][[Category:Cumulus Files]] | ||
Line 183: | Line 173: | ||
See [[Recent history|'''Recent history''' page]]. | See [[Recent history|'''Recent history''' page]]. | ||
=SqlCache table= | = SqlCache table = | ||
This table is fully managed by CumulusMX. You are not supposed to edit contents, you can view to quench your curiosity. | |||
There is a MX setting ('''Settings''' | There is a MX setting ('''Settings'''=>''MySQL settings''=>'''General Options'''=>tick Buffer commands on failure) that when enabled allows failed commands to be stored here. The buffer is lost when CumulusMX is restarted. | ||
This table holds a list of MySQL commands that are in the queue for '''[[MySqlConnect]]''' to run again. | This table holds a list of MySQL commands that are in the queue for '''[[MySqlConnect]]''' to run again. | ||
Line 202: | Line 194: | ||
* DivisionByZero (certain mathematical operations cannot be handled) | * DivisionByZero (certain mathematical operations cannot be handled) | ||
The table has two fields: | |||
{| border="1" class="wikitable" | |||
|- | |||
! style="width:10px" | Column number # | |||
"key | ! style="width:80px" | Column name | ||
! style="width:80px" | Column type | |||
! style="width:280px" | Properties | |||
! style="width:450px" | Description | |||
|- | |||
| 0 | |||
| key | |||
| integer | |||
| Primary Key, Not NULL, No Default Value, | |||
| An autoincrement integer for every SQL statement entered in the cache | |||
|- | |||
|- | |||
| 1 | |||
| statement | |||
| varchar | |||
| Not NULL, No Default Value, | |||
| Contains the actual SQL statement that failed | |||
|- | |||
|} | |||
= SQLite Sequence = | |||
No relevant information on this table is known |