The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
help with a db error please!
heyy guys, i have been getting this db error for a while now cause idk how to fix it and its only when i want to send a message or view a thread! here is the db error code:
Code:
Database error in vBulletin 4.1.9: 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 'extre520_hax1997.contenttype' doesn't exist Error Number : 1146 Request Date : Wednesday, January 11th 2012 @ 01:56:34 PM Error Date : Wednesday, January 11th 2012 @ 01:56:34 PM Script : http://extremehax.net/showthread.php?1-site-is-not-done-yet&p=5 Referrer : http://extremehax.net/ IP Address : XXX.XXX.XXX Username : Apex Classname : vB_Database MySQL Version : 5.0.92-community If anyone can help me, plz do i would appreciate it very much but i would appreciate it more if you could teamview me or skype me because i usually dont get some things lol! thanks! |
#2
|
||||
|
||||
If you look at your database, do you see the table contenttype there? (I can't imagine how you have been running without it.)
|
#3
|
|||
|
|||
sooo if its not there , what do i doo??
|
#4
|
||||
|
||||
You need to rebuild it. But like I said, I don't know how your site has been running without it. I'd get it from a backup of your database. You can also read the mysql-schema.php file to get it.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|