osTicket Versionv1.10 (901e5ea) — Up to dateWeb Server SoftwareApacheMySQL Version5.5.52PHP Version5.6.31We get this email daily. Can any one advise, please?
You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near 'lock' at line 1<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(204):
osTicket->logDBError('DB Error #1064', '[OPTIMIZE TABLE...')<br />
#1 (root)/include/class.cron.php(59): db_query('OPTIMIZE
TABLE ...')<br />
#2 (root)/include/class.cron.php(107):
Cron->MaybeOptimizeTables()<br />
#3 (root)/include/api.cron.php(19): Cron->run()<br
/>
#4 (root)/include/api.cron.php(40):
CronApiController->run()<br />
#5 (root)/api/cron.php(23):
LocalCronApiController:()<br />
#6 {main}