Any one seen this error?

[loki]

got an error I cant find any info on, anybody every saw it before?

Invalid SQL:

SELECT prefix.*
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
WHERE forumprefixset.forumid = 71
ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error : Table '(database-name).prefix' doesn't exist
Error Number : 1146

loki Reviewed by loki on 25th Jan 2011. Any one seen this error? got an error I cant find any info on, anybody every saw it before? Rating: 5

[aapkae]

your table does not exist,

[loki]

I knew better than try to get some help here, but, I asked anyway.Thanks alot

[el_jentel1]

loki, read the error again:

MySQL Error : Table '(database-name).prefix' doesn't exist

[loki]

ok,first I apologize for the attitude ,been a hard 6 days. the table doesnt exist, never has , i have put up 4 sqls from different times and error is the same and table is not there.Ive replaced newthread.php file and same.Board works everywhere but posting a new thread, you can reply to an existing thread but, just cant make a new one.Any ideas?

[iHate]

install a fresh copy on a sub-domain then copy the missing part
of the DB and paste it into the current one ??

Just an idea that's what i do when i mess up

[Sponge Bob]

It should be the database only that is corrupt make sure also your location of the files have been set properly.

Thanks

[desiboy]

db has to be rebuilt

Few ways :

*Try the repair option available in vBulletin Admin CP .
*Re Upload all vBulletin *.php files with the original ones.
*Run the upgrade script again ( rebuilds the db ) structure (best approach).

[loki]

install a fresh copy on a sub-domain then copy the missing part
of the DB and paste it into the current one ??

see thats the problem, it doesnt exist, never has.I have installed 4 different sql backups ,went to phpmyadmin and its not there on any of them.(went back to Jan9,2009 on one)Still no answer.Ive rebuilt it with everything but a claw hammer and a 2 x 4 .

[iHate]

remove the php that ask's for it could be an option?