need help with SQL

[mattonline]

OK so heres the story, for some reason my forum http://www.EntrepreneurForum.co.uk went down, lost its SQL database or something (not sure how it happend) so i re-installed the files, but i put in 3.67 files when the database was 3.65, and there were still errors, so i ran install/install.php and updated the database which is fine, but when i got to view members profiles

http://entrepreneurforum.co.uk/member.php?find=lastposter&f=2
and some posts
http://entrepreneurforum.co.uk/showthread.php?p=4693#post4693
and this one is weird
http://entrepreneurforum.co.uk/showthread.php?t=2546

none of the threads work, how do i get them to work again? what do i do, i still have the SQL backup from the 22nd of june


thanks in advance

Do you suggest i re-install the forum, in 3.65 ?

anyone know

[Dismounted]

Those threads may have been created after the database backup, and therefore would not exist anymore.

[mattonline]

hm, if they were created after the DB backup then wouldn't they not be there,


But i've been able to sort the situation out now.

I've made it so your able to view the threads they work now.

But i keep having errors when i go to post a reply, such as MYSQL ones, but the message will still post fine, (am i missing a certain file?)

and i get DB error when i go to a profile.
http://www.entrepreneurforum.co.uk/member.php?find=lastposter&f=3

[Lynne]

Do you get the mysql error mailed to you? It would help if we could see it posted.

[mattonline]

Ok its shown below, i've managed to fix the one problem, of the error message comming up when you post a reply button, which was that i didn't have VBAdavnced installed, so that error is fixed now.


Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type,
pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid =
pf.profilefieldcategoryid)
WHERE pf.form = 0
AND pf.hidden = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : Table 'matt_database.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Sunday, June 24th 2007 @ 06:07:49 PM
Script :
http://www.entrepreneurforum.co.uk/member.php?find=lastposter&t=16
Referrer :
IP Address : 210.150.10.105
Username : Unregistered
Classname : vB_Database

[Lynne]

Do you have a table called "profilefieldcategory" (it's not standard in my vbulletin installation)? Could that be from VBAdvanced also?