Hi Revan
It did after running this code (provided by mtha) to remove the 1970 bug:
UPDATE deletionlog, moderatorlog SET deletionlog.deldate=moderatorlog.dateline
WHERE deletionlog.type = 'post' AND deletionlog.deldate=0 AND (moderatorlog.postid = deletionlog.primaryid) AND moderatorlog.action LIKE 'post %deleted%';
UPDATE deletionlog, moderatorlog SET deletionlog.deldate=moderatorlog.dateline
WHERE deletionlog.type = 'thread' AND deletionlog.deldate=0 AND (moderatorlog.threadid = deletionlog.primaryid) AND moderatorlog.action LIKE 'thread %deleted%';
After that, it randomely started deleting posts and threads. In fact, can someone tell me how to reverse that SQl query 'cause I keep getting database errors now such as:
Invalid SQL:
REPLACE INTO deletionlog
(primaryid, type, userid, username, reason, deldate)
VALUES
(85514, 'post', 193, 'user',
'', '1127836289')
mysql error: Unknown column 'deldate' in 'field list'
mysql error number: 1054
|