Codezwiz >> Forums >> General PHP Nuke Help >> Form Error any Help here?

We are getting this error in our forums, It won't even import our back up Sql file... any help with whats going on?

Could not query forums information

DEBUG MODE

SQL Error : 1016 Can't open file: 'nuke_bbposts.MYD'. (errno: 145)

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 214
File : /home/virtual/site35/fst/var/www/html/modules/Forums/index.php

go to your phpMyAdmin's sql query window and type:

REPAIR table nuke_bbposts_text;

It says it repaired it but getting the same exact error.. ? Thanks.

also get this error trying to use our backup file..

Error importing backup file

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' <' at line 1

please run the repair on all your whole databaset....this eliminates the errors or at least try to fix them all

taut

Thanks Taut Problem Solved Your a Genius! TY so very much!

glad ya got it fixed...which file was it that gave the error? just for my consumption....

taut

Think it was Forum-addpost was corrupt.. I just did what you said and repaired them all.. but think it was that one... Thanks a million again guys..

thanks for that info and your welcome

taut

I seem to have exactly the same problem, but when I entered the SQL Query code it didn't change anything.

Perhaps I am entering it in the wrong place?

I've gone into phpMyAdmin and clicked on the Query Window at the bottom of the page and entered;

The Query says 'SELECT * FROM WHERE 1' and I typed in

REPAIR table nuke_bbposts_text;

Is this correct?

Table Op Msg_type Msg_text
ubaclane.nuke_bbposts_text repair status OK

That's what appears. Does this take time?

Any help would be much appretiated.

Regards
Ben Foley