Need Help In My Forum

[Mr.WT]

i got Error on my forum, when i submit New Post I got this error

Database error in vBulletin 4.0.4:

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 vb3_package AS package
LEFT JOIN vb3_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 vb3_contenttype AS contenttype
INNER JOIN vb3_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb3_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Table 'wareztow_porn1.vb3_contenttype' doesn't exist
Error Number : 1146
Request Date : Monday, January 17th 2011 @ 05:35:32 AM
Error Date : Monday, January 17th 2011 @ 05:35:32 AM
Script : http://www.pornheartclub.info/showthread.php?16024-Desi-12th-Class-School-Students
Referrer : http://www.pornheartclub.info/forumdisplay.php?7-Desi-Videos
IP Address : xxx.xxx.xxx.xx
Username : Unknown
Classname : vB_Database
MySQL Version : 5.0.91-community-log

 

[Doublecrosser]

Disable the auto tagger if you are using. and i just checked the home page, its working fine.

 

[CyberHacK]

Disable that tag plugin.

 

[desiboy]

quick and easy fix :
create a table called
wareztow_porn1.vb3_contenttype

its a very vague way of fixing the problem.

 

[Mr.WT]

who solve this problems i give him 5$

 

[dr5hn]

Go to phpMyAdmin in cpanel and repair all d tables

if this aint work

than make a ticket to ur host :D

 

[Jeronim]

Go to phpMyAdmin and repariot the tabels and repeat it with admincp.
You login to admincp too and repair tables.
If dont work pm your email to me and i can help u.

 

[xTreme]

u r using vbulletin 4.0.4.

Disable hooks and then upgrade to 4.1.0 .

 

[Mr.WT]

ok bro let me try

 

[Mr.WT]

Desable host and try to upgrade 4.1.0 i got error

An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 408, Step 14 Database Error:1146
Table 'wareztow_porn1.vb3_searchgroup' doesn't exist
Query:
DELETE vb3_searchgroup_text
FROM vb3_searchgroup_text
LEFT JOIN vb3_searchgroup ON (vb3_searchgroup.searchgroupid = vb3_searchgroup_text.searchgroupid)
WHERE vb3_searchgroup.searchgroupid IS NULL

 

[azeak]

repair all ur mysql tables through ssh
with simple command