SQL Error : 1016 Can't open file: 'nuke_bbprivmsgs_text.MYI' (errno: 145)
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 nuke_bbprivmsgs pm, nuke_bbprivmsgs_text pmt, nuke_users u, nuke_users u2 WHERE pm.privmsgs_id = '13395' 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 : 277
File : /home/virtual/site8/fst/var/www/html/nuke/modules/Private_Messages/index.php
all outgoing and incoming PMs result in this error....
anyone translate or help with this by offering a couple suggestions??
You can also repair this error via phpMyAdmin and the SQL command REPAIR TABLE nuke_bbprivmsgs_text; I have fixed a similar error with the help of phpMyAdmin and it was very simple to fix. Make a backup first though to be on the safe side.
eaglewing Private
Joined: Oct 19, 2004
Posts: 48
Posted:
Mon Oct 16, 2006 2:10 pm
One problem encountered here....any attempt to highlight this table in order to give it a 'repair' command results in a LOCKUP....
something is wrong and I dont know how now to write a repair...better yet, is there a way to OVERWRITE' this table using the original install SQL?
searching here....
Slackervaara Captain
Joined: Sep 13, 2003
Posts: 314
Posted:
Tue Oct 17, 2006 2:18 am
I repaired my table in phpMyAdmin like this:
Choose the database
Choose SQL and in the window Run SQL query/queries on database I run the REPAIR TABLE query.
I did not highlite anything.
Backup your database before you try to repair.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
