The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
How to fix database error
So I have transfered hosts from a shared to a vps linux CentOS. I asked the host to import the database for me because it was too large and they did it. After the forum was working just fine, until a little db error came by Everytime I try to go on any thread, it brings up this error:
Code:
Database error in vBulletin 4.1.3: Invalid SQL: (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled, package.class AS class, -1 as isaggregator FROM package AS package LEFT JOIN product AS product ON product.productid = package.productid WHERE product.active = 1 OR package.productid = 'vbulletin' ) UNION (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class , contenttype.isaggregator FROM contenttype AS contenttype INNER JOIN package AS package ON package.packageid = contenttype.packageid LEFT JOIN product AS product ON product.productid = package.productid WHERE product.active = 1 OR package.productid = 'vbulletin' ); MySQL Error : Table 'wghaven_wgvb.contenttype' doesn't exist Error Number : 1146 Request Date : Wednesday, April 13th 2011 @ 03:00:15 PM Error Date : Wednesday, April 13th 2011 @ 03:00:16 PM Script : http://wghaven.com/forum/search.php?do=getdaily&contenttype=vBForum_Post Referrer : IP Address : 76.122.144.53 Username : Chaldo Classname : vB_Database MySQL Version : 5.0.92-community-log Any ideas? -Chaldo |
#2
|
||||
|
||||
You're missing a table...
Quote:
|
#3
|
||||
|
||||
or maybe this table's prefix has changed ?
|
#4
|
|||
|
|||
Quote:
and what do you mean prefix has changed? How do I fix this? The database from godaddy was named wgvb and the current one right now is called wghaven_wgvb Maybe something do with that? idk -Chaldo |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|