Page 1 of 1

HELP ME! please asap!!!!

Posted: Sun Feb 08, 2004 1:43 am
by busterblader103
ok, i was installing a mod, and uninstalled it, and made a mistake, i did something. Now when i try to read a pm, i get this:

Code: Select all

Could not query private message post information

DEBUG MODE

SQL Error : 1146 Table 'yugiohelite_net_forum.phpbb_privmsgs_text' doesn't exist

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 phpbb_privmsgs pm, phpbb_privmsgs_text pmt, phpbb_users u, phpbb_users u2 WHERE pm.privmsgs_id = 6 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_to_userid = 2 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 : 239
File : /home/virtual/site41/fst/var/www/html/forum/privmsg.php
can someone please please PLEASE help me?

Posted: Sun Feb 08, 2004 2:59 am
by A_Jelly_Doughnut
All of your private messages are gone :( Sorry. You can fix the feature so that users can send new mesages to other users by running this SQL query.

Code: Select all

CREATE TABLE phpbb_privmsgs_text (
   privmsgs_text_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
   privmsgs_text text,
   PRIMARY KEY (privmsgs_text_id)
);