ERROR 1067 (42000) at line 2063: Invalid default value for 'datetime'
Сам скрипт установился и я надеялся что он будет работать. Но при запуске крона
Code: Select all
PHP Fatal error: Uncaught Exception: Mysql error:: 1146 (Table 'user_owner.broker_zone_stats' doesn't exist) (db_link) in query SELECT * FROM broker_zone_stats ORDER BY datetime DESC LIMIT 10000. (mydomain.com) in /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php:129
Stack trace:
#0 /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php(182): db_error()
#1 /home/owner/web/mydomain.com/public_html/base/includes/libs/cj_functions.php(1773): db_query()
#2 /home/owner/web/mydomain.com/public_html/base/includes/libs/cj_functions.php(1721): brokers_data()
#3 /home/owner/web/mydomain.com/public_html/base/bin/cron.php(106): writemembers()
#4 {main}
thrown in /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php on line 129
Fatal error: Uncaught Exception: Mysql error:: 1146 (Table 'user_owner.broker_zone_stats' doesn't exist) (db_link) in query SELECT * FROM broker_zone_stats ORDER BY datetime DESC LIMIT 10000. (mydomain.com) in /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php:129
Stack trace:
#0 /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php(182): db_error()
#1 /home/owner/web/mydomain.com/public_html/base/includes/libs/cj_functions.php(1773): db_query()
#2 /home/owner/web/mydomain.com/public_html/base/includes/libs/cj_functions.php(1721): brokers_data()
#3 /home/owner/web/mydomain.com/public_html/base/bin/cron.php(106): writemembers()
#4 {main}
thrown in /home/owner/web/mydomain.com/public_html/base/includes/db_modules/mysql.php on line 129
Что пошло не так?