błędy sql Błędy SQL

[Dementor]

Witam,

od dwóch dni mam jakieś błędy w bazie danych, zaczęło się od wtyczki trafic generator gdy wszedłem na forum ujrzałem taki napis :

 

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

«Return to the index

 

 

Wyłączyłem ją i forum działa, jednak przy próbie edycji postu czy tematu wyskakuje to samo:

 

 

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

«Return to the index

 

jednak zmiany wprowadzone przy edycji się zachowują.

 

Wszedłem przez FTP w cache i mam takie informacje w ostatnim logu:

 

Ostatni błąd SQL (dziś, 09:50 )---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 24 May 2016 07:50:11 +0000 Error: 1366 - Incorrect integer value: '' for column 'ttc_italic' at row 1 IP Address: 198.41.242.181 - /index.php? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: UPDATE ibf_topics SET ttc_fontcolor='',ttc_backgroundcolor='',ttc_italic='',ttc_bold='' WHERE tid=326496 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | hooks/sos32_ttc_postModule_d25b67092206ffaedd57495f17428f72.php | [db_main_mysql].update | 131 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/post/post.php | [sos32_ttc_postModule].editPost | 358 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/post/post.php | [public_forums_post_post].saveForm | 251 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | hooks/dp3_BanFromTopicCheckPost_11da2b7b8106a96518b9eb5594d1f311.php | [public_forums_post_post].doExecute | 68 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [dp3_BanFromTopicCheckPost].doExecute | 302 | '----------------------------------------------------------------------------+----------

 

 

Przy włączonej wtyczce trafic generator mam taki log:

 

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 24 May 2016 08:08:03 +0000 Error: 1366 - Incorrect integer value: '' for column 'ttc_italic' at row 1 IP Address: 198.41.242.181 - /index.php? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: UPDATE ibf_topics SET ttc_fontcolor='',ttc_backgroundcolor='',ttc_italic='',ttc_bold='' WHERE tid=326496 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | hooks/sos32_ttc_postModule_d25b67092206ffaedd57495f17428f72.php | [db_main_mysql].update | 131 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/post/post.php | [sos32_ttc_postModule].editPost | 358 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/post/post.php | [public_forums_post_post].saveForm | 251 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | hooks/dp3_BanFromTopicCheckPost_11da2b7b8106a96518b9eb5594d1f311.php | [public_forums_post_post].doExecute | 68 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [dp3_BanFromTopicCheckPost].doExecute | 302 |

 

 

przy próbie optymalizacji lub naprawy tabel w bazie, mieli mi strona i się zawiesza.

Edytowane 24 Maja 2016 przez Dementor

[DawPi]

To bardziej z tego moda: sos32_ttc_postModule. Wyłącz go i sprawdź.

[Dementor]

Tak przypuszczałem, że to ta modyfikacja, bo coś z kolorami wyskakiwało w logach. Okazało się, że (SOS32) Topic Title Colored powodował błędy przy zapisie edytowanych tematów.

 

Wyłączyłem go i jest ok, przy edycji postów, jednak błąd wyskakuje nadal przy wyłączonym trafic generator, więc wyłączyłem obie modyfikacje.

 

 

Dzięki za podpowiedź.