PDA

View Full Version : help with a db error please!


bomber1614
01-11-2012, 05:59 PM
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:

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!

Lynne
01-11-2012, 08:39 PM
If you look at your database, do you see the table contenttype there? (I can't imagine how you have been running without it.)

bomber1614
01-12-2012, 12:09 AM
sooo if its not there , what do i doo??

Lynne
01-12-2012, 04:11 AM
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.