In my phpbb3 forum there were lot of Guest post that too mainly in Russian language. The date and time will be like "by Guest Thu Jan 01, 1970 12:00 am"
If we try to delete it through the moderator control panel it will throw the below error
General Error
SQL ERROR [ mysqli ]
Incorrect string value: '\xD0\xA2\xD0\xB0\xD0\xB9...' for column 'log_data' at row 1 [1366]
SQL
INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type, forum_id, topic_id) VALUES ('2', '106.51.143.238', 1370357922, 'LOG_DELETE_TOPIC', 'a:2:{i:0;s:37:\"????? ????, ????????\";i:1;s:17:\"AnnaRoRttaumeuroF\";}', 1, 15, 205)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
This i goggled and found the help in the Knowledge Base of the phpbb forum
https://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/
The problem is that the schema of the databases in older versions will not work correctly in newer versions without various things being changed. The result of such an upgrade without fixing the database schema is the above mentioned error.
when you type www.yourdomain.com/mysql_upgrader.php, you will get a setof MySQL queries, copy paste this and run in your phpmyadmin or mysql console
After upgrading the MySQL schema using the mysql_upgrader.php i was able to delete those Guest posting
And now i have to see if spam postings are getting reduced or not
If we try to delete it through the moderator control panel it will throw the below error
General Error
SQL ERROR [ mysqli ]
Incorrect string value: '\xD0\xA2\xD0\xB0\xD0\xB9...' for column 'log_data' at row 1 [1366]
SQL
INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type, forum_id, topic_id) VALUES ('2', '106.51.143.238', 1370357922, 'LOG_DELETE_TOPIC', 'a:2:{i:0;s:37:\"????? ????, ????????\";i:1;s:17:\"AnnaRoRttaumeuroF\";}', 1, 15, 205)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
This i goggled and found the help in the Knowledge Base of the phpbb forum
https://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/
The problem is that the schema of the databases in older versions will not work correctly in newer versions without various things being changed. The result of such an upgrade without fixing the database schema is the above mentioned error.
when you type www.yourdomain.com/mysql_upgrader.php, you will get a setof MySQL queries, copy paste this and run in your phpmyadmin or mysql console
After upgrading the MySQL schema using the mysql_upgrader.php i was able to delete those Guest posting
And now i have to see if spam postings are getting reduced or not
