Master >> Slave Mysql error:: 1364

Постим сюда все найденые ошибки
Post Reply
Semen_ssr
Posts: 803
Joined: Sun Apr 25, 2010 7:59 pm

Master >> Slave Mysql error:: 1364

Post by Semen_ssr »

Была надобность отключить и подключить слейв, подключить не удалось
/scj/admin/?operation=rotation&
ответ на странице Rotation >> Master/Slave
Fatal error: Uncaught Exception: Mysql error:: 1364 (Field 'thumb_stats_geoip_codes' doesn't have a default value) (ext_db_link) in query insert into rot_linked_db (`linked_db_name`, `separate_category_stats`, `separate_thumb_stats`) values ('slave.com', '1', '1'). (slave.com) in /home/user/www/slave.com/scj/includes/db_modules/mysql.php:131 Stack trace: #0 /home/user/www/slave.com/scj/includes/db_modules/mysql.php(184): db_error('insert into rot...', 1364, 'Field 'thumb_st...', 'ext_db_link') #1 /home/user/www/slave.com/scj/includes/db_modules/mysql.php(309): db_query('insert into rot...', 'ext_db_link') #2 /home/user/www/slave.com/scj/admin/files/fastedit.php(2329): db_perform('rot_linked_db', Array, 'insert', '', 'ext_db_link') #3 /home/user/www/slave.com/scj/admin/index.php(325): unknown() #4 {main} thrown in /home/user/www/slave.com/scj/includes/db_modules/mysql.php on line 131

Fatal error: Uncaught Exception: Can not connect to database server ... in /home/user/www/slave.com/scj/includes/db_modules/mysql.php:29 Stack trace: #0 /home/user/www/slave.com/scj/admin/files/fastedit.php(2281): db_connect('ext_db_link') #1 /home/user/www/slave.com/scj/admin/index.php(325): unknown() #2 {main} thrown in /home/user/www/slave.com/scj/includes/db_modules/mysql.php on line 29
Script massege на слейве
2021-08-18 18:33:19 : Mysql error 1364: Field 'thumb_stats_geoip_codes' doesn't have a default value (insert into rot_linked_db (`linked_db_name`, `separate_category_stats`, `separate_thumb_stats`) values ('slave.com', '1', '1'))
На home слейва
Warning, you have following CORE errors (You have to fix it and delete those messages from Home - Script Messages after that)

Core error: Mysql error 1364: Field 'thumb_stats_geoip_codes' doesn't have a default value (insert into rot_linked_db (`linked_db_name`, `separate_category_stats`, `separate_thumb_stats`) values ('hdanalpics.com', '1', '1'))
Апдейт везде Your Build 202108181101 (Current build: 202108181101 ) PHP version 7.4.21 Mysql Version: 10.4.20-MariaDB
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Master >> Slave Mysql error:: 1364

Post by admin »

пофикшено в апе)
Don't forget to run script update
Semen_ssr
Posts: 803
Joined: Sun Apr 25, 2010 7:59 pm

Re: Master >> Slave Mysql error:: 1364

Post by Semen_ssr »

Заработало, спасибо!
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Master >> Slave Mysql error:: 1364

Post by admin »

Отлично)
Don't forget to run script update
Post Reply