Vbulletin board issues

apps

#1

Hello all,

Im in the process of transferring my site from Bluehost.com to Dreamhost.com, and the biggest challenge I am facing is moving my forum. I pretty much have everything working, but when one goes to post on the forum, there is a database error that goes like this:

Database error in vBulletin 3.7.3:

Invalid SQL:

		SELECT prefix.*, prefixpermission.usergroupid AS restriction
		FROM vbforumprefixset AS forumprefixset
		INNER JOIN vbprefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
		INNER JOIN vbprefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
		LEFT JOIN vbprefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
		WHERE forumprefixset.forumid = 2
		ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error : Table ‘ceforumtd.vbprefixpermission’ doesn’t exist
Error Number : 1146
Request Date : Wednesday, March 16th 2011 @ 09:49:20 PM
Error Date : Wednesday, March 16th 2011 @ 09:49:20 PM
Script : http://www.thecollegeendzone.com/ce2/newthread.php?do=newthread&f=2
Referrer : http://www.thecollegeendzone.com/ce2/forumdisplay.php?f=2
IP Address : 66.177.169.201
Username : NolePaul
Classname : vB_Database
MySQL Version : 5.1.53-log

The link is http://www.thecollegeendzone.com/ce2/newthread.php?do=newthread&f=2


#2

Anyone? I guess on on my own…


#3

I’m not personally familiar with vBulletin, but that error sounds a lot like the database you imported was either incomplete or was for a different version of vBulletin.


#4

That is the wierd thing. I have the same versions of vb on the old and this site and imported the back up I made of the database. Both vb versions are 3.7.3