alanstylez
Member
JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{package}_cron WHERE published = '1' AND CASE WHEN unit = 'second' THEN DATE_ADD' at line 7 SQL=SELECT id, plugin, lastrun, unit, frequency, CASE WHEN unit = 'second' THEN DATE_ADD( lastrun, INTERVAL frequency SECOND ) WHEN unit = 'minute' THEN DATE_ADD( lastrun, INTERVAL frequency MINUTE ) WHEN unit = 'hour' THEN DATE_ADD( lastrun, INTERVAL frequency HOUR ) WHEN unit = 'day' THEN DATE_ADD( lastrun, INTERVAL frequency DAY ) WHEN unit = 'week' THEN DATE_ADD( lastrun, INTERVAL frequency WEEK ) WHEN unit = 'month' THEN DATE_ADD( lastrun, INTERVAL frequency MONTH ) WHEN unit = 'year' THEN DATE_ADD( lastrun, INTERVAL frequency YEAR ) END AS nextrun FROM uao_{package}_cron WHERE published = '1' AND CASE WHEN unit = 'second' THEN DATE_ADD( lastrun, INTERVAL frequency SECOND ) WHEN unit = 'minute' THEN DATE_ADD( lastrun, INTERVAL frequency MINUTE ) WHEN unit = 'hour' THEN DATE_ADD( lastrun, INTERVAL frequency HOUR ) WHEN unit = 'day' THEN DATE_ADD( lastrun, INTERVAL frequency DAY ) WHEN unit = 'week' THEN DATE_ADD( lastrun, INTERVAL frequency WEEK ) WHEN unit = 'month' THEN DATE_ADD( lastrun, INTERVAL frequency MONTH ) WHEN unit = 'year' THEN DATE_ADD( lastrun, INTERVAL frequency YEAR ) END < NOW()
Call stack
# Function Location
1 JSite->render() //httpdocs/index.php:49
2 JApplication->triggerEvent() //httpdocs/includes/application.php:265
3 JDispatcher->trigger() //httpdocs/libraries/joomla/application/application.php:557
4 JEvent->update() //httpdocs/libraries/joomla/event/dispatcher.php:115
5 call_user_func_array() //httpdocs/libraries/joomla/event/event.php:46
6 plgSystemFabrikcron->onAfterRender() *
7 plgSystemFabrikcron->doCron() //httpdocs/plugins/system/fabrikcron/fabrikcron.php:168
8 JDatabaseMySQL->loadObjectList() //httpdocs/plugins/system/fabrikcron/fabrikcron.php:77
9 JDatabaseMySQL->query() //httpdocs/libraries/joomla/database/database/mysql.php:430
10 JError::raiseError() //httpdocs/libraries/joomla/database/database/mysql.php:208
11 JError::raise() //httpdocs/libraries/joomla/error/error.php:179
Call stack
# Function Location
1 JSite->render() //httpdocs/index.php:49
2 JApplication->triggerEvent() //httpdocs/includes/application.php:265
3 JDispatcher->trigger() //httpdocs/libraries/joomla/application/application.php:557
4 JEvent->update() //httpdocs/libraries/joomla/event/dispatcher.php:115
5 call_user_func_array() //httpdocs/libraries/joomla/event/event.php:46
6 plgSystemFabrikcron->onAfterRender() *
7 plgSystemFabrikcron->doCron() //httpdocs/plugins/system/fabrikcron/fabrikcron.php:168
8 JDatabaseMySQL->loadObjectList() //httpdocs/plugins/system/fabrikcron/fabrikcron.php:77
9 JDatabaseMySQL->query() //httpdocs/libraries/joomla/database/database/mysql.php:430
10 JError::raiseError() //httpdocs/libraries/joomla/database/database/mysql.php:208
11 JError::raise() //httpdocs/libraries/joomla/error/error.php:179
