Errore SQL ERROR [ Mysql4 ]il portale che ha sempre funzionato ora se provo a scrivere in qualunque parte del forum mi da l'errore riportato di seguito.
Ho provato a fare manutenzione db sia da ACP ma senza risultato, poi da phpmyadmin e niente da fare!
Da ACP ho provato anche a sincronizzare i forum e mi da lo stesso errore, e quando ho provato a ricostruire l'indice di ricerca, non riuscivo piu ad utilizzare nessuna sezione del sito.
Ho recuperato un db del 23 agosto perdendo cosi una decina di giorni, ma ora l'errore c'è sempre. Lo shoutbox e la chat funzionano.
Sono disperato cosa puo essere?
Grazie
Notice: in ....... /includes/db/mysql.php on line 906
Notice:
SQL ERROR [ mysql4 ]
Incorrect integer value: '' for column 'log_target' at row 1 [1366]
SQL
INSERT INTO ip_logs (log_id, log_time, log_page, log_user_id, log_action, log_desc, log_target) VALUES ('25498', '1504535506', 'posting.php', '2', 'MESSAGE', '203', '')
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: includes/functions_mg_log.php
LINE: 104
CALL: sql_db->sql_query()
FILE: includes/functions.php
LINE: 6260
CALL: ip_log()
FILE: includes/functions.php
LINE: 5977
CALL: message_die()
FILE:
LINE:
CALL: msg_handler()
FILE: includes/db/mysql.php
LINE: 909
CALL: trigger_error()
< in /membri2/danfree/includes/db/mysql.php on line 909
Informazione Critica
SQL ERROR [ mysql4 ]
Field 'post_text_compiled' doesn't have a default value [1364]
SQL
INSERT INTO ip_posts (topic_id, forum_id, poster_id, post_username, post_subject, post_text, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_autolinks_acronyms, enable_sig) VALUES (4412, 7, 2, '', 'prova', 'dfsdfsfds f fgfg', 1504535506, '151.54.34.165', 1, 1, 1, 1, 1)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: includes/functions_post.php
LINE: 486
CALL: sql_db->sql_query()
FILE: posting.php
LINE: 1307
CALL: submit_post()
Notice:
SQL ERROR [ mysql4 ]
Incorrect integer value: '' for column 'log_target' at row 1 [1366]
SQL
INSERT INTO ip_logs (log_id, log_time, log_page, log_user_id, log_action, log_desc, log_target) VALUES ('25498', '1504535506', 'posting.php', '2', 'MESSAGE', '203', '')
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: includes/functions_mg_log.php
LINE: 104
CALL: sql_db->sql_query()
FILE: includes/functions.php
LINE: 6260
CALL: ip_log()
FILE: includes/functions.php
LINE: 5977
CALL: message_die()
FILE:
LINE:
CALL: msg_handler()
FILE: includes/db/mysql.php
LINE: 909
CALL: trigger_error()
< in /membri2/danfree/includes/db/mysql.php on line 909
Informazione Critica
SQL ERROR [ mysql4 ]
Field 'post_text_compiled' doesn't have a default value [1364]
SQL
INSERT INTO ip_posts (topic_id, forum_id, poster_id, post_username, post_subject, post_text, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_autolinks_acronyms, enable_sig) VALUES (4412, 7, 2, '', 'prova', 'dfsdfsfds f fgfg', 1504535506, '151.54.34.165', 1, 1, 1, 1, 1)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: includes/functions_post.php
LINE: 486
CALL: sql_db->sql_query()
FILE: posting.php
LINE: 1307
CALL: submit_post()
