Database needs some attention
Posted: Wed Jun 06, 2007 3:00 am
This is the sort of message I am getting when I try to read or post PM's. I also get errors making forum posts.
Could not query private message post information
DEBUG MODE
SQL Error : 1194 Table 'pmt' is marked as crashed and should be repaired
SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_sig_bbcode_uid, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM rf3_privmsgs pm, rf3_privmsgs_text pmt, rf3_users u, rf3_users u2 WHERE pm.privmsgs_id = 36343 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_to_userid = 7384 AND ( pm.privmsgs_type = 0 OR pm.privmsgs_type = 1 OR pm.privmsgs_type = 5 ) AND u.user_id = pm.privmsgs_from_userid AND u2.user_id = pm.privmsgs_to_userid
Line : 240
File : privmsg.php
Could not query private message post information
DEBUG MODE
SQL Error : 1194 Table 'pmt' is marked as crashed and should be repaired
SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_sig_bbcode_uid, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM rf3_privmsgs pm, rf3_privmsgs_text pmt, rf3_users u, rf3_users u2 WHERE pm.privmsgs_id = 36343 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_to_userid = 7384 AND ( pm.privmsgs_type = 0 OR pm.privmsgs_type = 1 OR pm.privmsgs_type = 5 ) AND u.user_id = pm.privmsgs_from_userid AND u2.user_id = pm.privmsgs_to_userid
Line : 240
File : privmsg.php