04 June, 2013

phpbb forum having spam guest posting with topic in russian and not able delete

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

No comments:

Post a Comment