Прошу помочь!
Добавлено: Вс мар 12, 2017 1:33 pm
Доброго всем. Прошу помочь. После некорректного завершения работы сервера (WIN7) не могу зайти в админку. В логе вижу следующее:
СпойлерПоказать
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 '' at line 1<br>
</b></font></p></td></tr></table></body>
</html>C:\_majordomo\htdocs>..\server\php\php.exe cycle.php
Connecting to database...
CONNECTED TO DB
Running startup maintenance
Checking modules.
<html><head><style>body {font-family:tahoma, arial}</style></head><body> <b
r><table border=0 cellspacing=2 cellpadding=15 bgcolor=#FF0000 align=center widt
h=600><tr><td bgcolor='#FFFFFF'><p align=center><font color=red><b>Sorry, page i
s temporary unavailable.<br><br>Please try again later.</b></font></p><p align='
center'><a href='#' onClick='history.go(-1);'><<< Back to previous page
</a></p></td></tr><tr><td bgcolor='#FFFFFF'><p align=center><font color=red><b>h
ttp://<br />
Error:<br />
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 '' at line 1<br>
</b></font></p></td></tr></table></body>
</html>
C:\_majordomo\htdocs>cd ..
C:\_majordomo>rem call reboot.bat
C:\_majordomo>goto 1
C:\_majordomo>rem Database auto repair
C:\_majordomo>.\server\mysql\bin\mysqlcheck.exe -u root --auto-repair --check --
optimize --all-databases
db_terminal.admin_users Table is already up to date
db_terminal.app_nut_devices Table is already up to date
db_terminal.app_nut_params Table is already up to date
db_terminal.app_quotes Table is already up to date
db_terminal.app_radio Table is already up to date
db_terminal.blockly_code Table is already up to date
db_terminal.cached_values
note : The storage engine for the table doesn't support optimize
db_terminal.calendar_categories Table is already up to date
db_terminal.calendar_events Table is already up to date
db_terminal.charts Table is already up to date
db_terminal.charts_data Table is already up to date
db_terminal.classes Table is already up to date
db_terminal.collections Table is already up to date
db_terminal.commands OK
db_terminal.country Table is already up to date
db_terminal.elements Table is already up to date
db_terminal.elm_states Table is already up to date
db_terminal.espdevices OK
db_terminal.espdevices_data OK
db_terminal.events Table is already up to date
db_terminal.gpsactions Table is already up to date
db_terminal.gpsdevices Table is already up to date
db_terminal.gpslocations Table is already up to date
db_terminal.gpslog Table is already up to date
db_terminal.history Table is already up to date
db_terminal.ignore_updates Table is already up to date
db_terminal.jobs Table is already up to date
db_terminal.layouts Table is already up to date
db_terminal.locations Table is already up to date
db_terminal.log4php_log Table is already up to date
db_terminal.media_favorites Table is already up to date
db_terminal.media_history Table is already up to date
db_terminal.methods Table is already up to date
db_terminal.mqtt Table is already up to date
db_terminal.mqtt_queue
note : The storage engine for the table doesn't support optimize
db_terminal.myblocks Table is already up to date
db_terminal.myblocks_categories Table is already up to date
db_terminal.newsletter Table is already up to date
db_terminal.objects Table is already up to date
db_terminal.optimizerdata Table is already up to date
db_terminal.patterns Table is already up to date
db_terminal.performance_log Table is already up to date
db_terminal.phistory Table is already up to date
db_terminal.phistory_queue OK
db_terminal.pinghosts Table is already up to date
db_terminal.plugins Table is already up to date
db_terminal.prod_categories Table is already up to date
db_terminal.product_categories Table is already up to date
db_terminal.product_codes Table is already up to date
db_terminal.product_log Table is already up to date
db_terminal.products Table is already up to date
db_terminal.project_modules Table is already up to date
db_terminal.properties Table is already up to date
db_terminal.public_calls Table is already up to date
db_terminal.pvalues OK
db_terminal.readit_channels Table is already up to date
db_terminal.readit_urls Table is already up to date
db_terminal.rss_channels Table is already up to date
db_terminal.rss_items Table is already up to date
db_terminal.safe_execs Table is already up to date
db_terminal.scenes Table is already up to date
db_terminal.script_categories Table is already up to date
db_terminal.scripts OK
db_terminal.security_rules Table is already up to date
db_terminal.settings Table is already up to date
db_terminal.shoplist Table is already up to date
db_terminal.shopping_list_items Table is already up to date
db_terminal.shoutrooms Table is already up to date
db_terminal.shouts Table is already up to date
db_terminal.smsru_list Table is already up to date
db_terminal.system_errors Table is already up to date
db_terminal.system_errors_data Table is already up to date
db_terminal.tdwiki Table is already up to date
db_terminal.terminals Table is already up to date
db_terminal.tlg_cmd Table is already up to date
db_terminal.tlg_event Table is already up to date
db_terminal.tlg_user Table is already up to date
db_terminal.tlg_user_cmd Table is already up to date
db_terminal.usbdevices Table is already up to date
db_terminal.userlog Table is already up to date
db_terminal.users Table is already up to date
db_terminal.webvars Table is already up to date
mysql.columns_priv Table is already up to date
mysql.db Table is already up to date
mysql.func Table is already up to date
mysql.help_category Table is already up to date
mysql.help_keyword Table is already up to date
mysql.help_relation Table is already up to date
mysql.help_topic Table is already up to date
mysql.host Table is already up to date
mysql.proc Table is already up to date
mysql.procs_priv Table is already up to date
mysql.tables_priv Table is already up to date
mysql.time_zone Table is already up to date
mysql.time_zone_leap_second Table is already up to date
mysql.time_zone_name Table is already up to date
mysql.time_zone_transition Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user Table is already up to date
phpmyadmin.pma_bookmark Table is already up to date
phpmyadmin.pma_column_info Table is already up to date
phpmyadmin.pma_history Table is already up to date
phpmyadmin.pma_pdf_pages Table is already up to date
phpmyadmin.pma_relation Table is already up to date
phpmyadmin.pma_table_coords Table is already up to date
phpmyadmin.pma_table_info Table is already up to date
server2go.items Table is already up to date
your MySQL server version for the right syntax to use near '' at line 1<br>
</b></font></p></td></tr></table></body>
</html>C:\_majordomo\htdocs>..\server\php\php.exe cycle.php
Connecting to database...
CONNECTED TO DB
Running startup maintenance
Checking modules.
<html><head><style>body {font-family:tahoma, arial}</style></head><body> <b
r><table border=0 cellspacing=2 cellpadding=15 bgcolor=#FF0000 align=center widt
h=600><tr><td bgcolor='#FFFFFF'><p align=center><font color=red><b>Sorry, page i
s temporary unavailable.<br><br>Please try again later.</b></font></p><p align='
center'><a href='#' onClick='history.go(-1);'><<< Back to previous page
</a></p></td></tr><tr><td bgcolor='#FFFFFF'><p align=center><font color=red><b>h
ttp://<br />
Error:<br />
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 '' at line 1<br>
</b></font></p></td></tr></table></body>
</html>
C:\_majordomo\htdocs>cd ..
C:\_majordomo>rem call reboot.bat
C:\_majordomo>goto 1
C:\_majordomo>rem Database auto repair
C:\_majordomo>.\server\mysql\bin\mysqlcheck.exe -u root --auto-repair --check --
optimize --all-databases
db_terminal.admin_users Table is already up to date
db_terminal.app_nut_devices Table is already up to date
db_terminal.app_nut_params Table is already up to date
db_terminal.app_quotes Table is already up to date
db_terminal.app_radio Table is already up to date
db_terminal.blockly_code Table is already up to date
db_terminal.cached_values
note : The storage engine for the table doesn't support optimize
db_terminal.calendar_categories Table is already up to date
db_terminal.calendar_events Table is already up to date
db_terminal.charts Table is already up to date
db_terminal.charts_data Table is already up to date
db_terminal.classes Table is already up to date
db_terminal.collections Table is already up to date
db_terminal.commands OK
db_terminal.country Table is already up to date
db_terminal.elements Table is already up to date
db_terminal.elm_states Table is already up to date
db_terminal.espdevices OK
db_terminal.espdevices_data OK
db_terminal.events Table is already up to date
db_terminal.gpsactions Table is already up to date
db_terminal.gpsdevices Table is already up to date
db_terminal.gpslocations Table is already up to date
db_terminal.gpslog Table is already up to date
db_terminal.history Table is already up to date
db_terminal.ignore_updates Table is already up to date
db_terminal.jobs Table is already up to date
db_terminal.layouts Table is already up to date
db_terminal.locations Table is already up to date
db_terminal.log4php_log Table is already up to date
db_terminal.media_favorites Table is already up to date
db_terminal.media_history Table is already up to date
db_terminal.methods Table is already up to date
db_terminal.mqtt Table is already up to date
db_terminal.mqtt_queue
note : The storage engine for the table doesn't support optimize
db_terminal.myblocks Table is already up to date
db_terminal.myblocks_categories Table is already up to date
db_terminal.newsletter Table is already up to date
db_terminal.objects Table is already up to date
db_terminal.optimizerdata Table is already up to date
db_terminal.patterns Table is already up to date
db_terminal.performance_log Table is already up to date
db_terminal.phistory Table is already up to date
db_terminal.phistory_queue OK
db_terminal.pinghosts Table is already up to date
db_terminal.plugins Table is already up to date
db_terminal.prod_categories Table is already up to date
db_terminal.product_categories Table is already up to date
db_terminal.product_codes Table is already up to date
db_terminal.product_log Table is already up to date
db_terminal.products Table is already up to date
db_terminal.project_modules Table is already up to date
db_terminal.properties Table is already up to date
db_terminal.public_calls Table is already up to date
db_terminal.pvalues OK
db_terminal.readit_channels Table is already up to date
db_terminal.readit_urls Table is already up to date
db_terminal.rss_channels Table is already up to date
db_terminal.rss_items Table is already up to date
db_terminal.safe_execs Table is already up to date
db_terminal.scenes Table is already up to date
db_terminal.script_categories Table is already up to date
db_terminal.scripts OK
db_terminal.security_rules Table is already up to date
db_terminal.settings Table is already up to date
db_terminal.shoplist Table is already up to date
db_terminal.shopping_list_items Table is already up to date
db_terminal.shoutrooms Table is already up to date
db_terminal.shouts Table is already up to date
db_terminal.smsru_list Table is already up to date
db_terminal.system_errors Table is already up to date
db_terminal.system_errors_data Table is already up to date
db_terminal.tdwiki Table is already up to date
db_terminal.terminals Table is already up to date
db_terminal.tlg_cmd Table is already up to date
db_terminal.tlg_event Table is already up to date
db_terminal.tlg_user Table is already up to date
db_terminal.tlg_user_cmd Table is already up to date
db_terminal.usbdevices Table is already up to date
db_terminal.userlog Table is already up to date
db_terminal.users Table is already up to date
db_terminal.webvars Table is already up to date
mysql.columns_priv Table is already up to date
mysql.db Table is already up to date
mysql.func Table is already up to date
mysql.help_category Table is already up to date
mysql.help_keyword Table is already up to date
mysql.help_relation Table is already up to date
mysql.help_topic Table is already up to date
mysql.host Table is already up to date
mysql.proc Table is already up to date
mysql.procs_priv Table is already up to date
mysql.tables_priv Table is already up to date
mysql.time_zone Table is already up to date
mysql.time_zone_leap_second Table is already up to date
mysql.time_zone_name Table is already up to date
mysql.time_zone_transition Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user Table is already up to date
phpmyadmin.pma_bookmark Table is already up to date
phpmyadmin.pma_column_info Table is already up to date
phpmyadmin.pma_history Table is already up to date
phpmyadmin.pma_pdf_pages Table is already up to date
phpmyadmin.pma_relation Table is already up to date
phpmyadmin.pma_table_coords Table is already up to date
phpmyadmin.pma_table_info Table is already up to date
server2go.items Table is already up to date
