PDA

View Full Version : Database crashd


ales2cv
06-04-2013, 06:40 AM
Plese help
i dont do anything on my forum not add any new things just do upgrade on 4.2.1 when was some time back come out.

I do repair mysql several time also works repair optimize tabel and dont get any errors

i disebel all adons still the same

I guess is problem with Rebuild Search Index
becuse there i get error in my admin and not get any others menu after that

that is error

Database error in vBulletin 4.2.1:

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 vb_package AS package
LEFT JOIN vb_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 vb_contenttype AS contenttype
INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Unknown storage engine 'InnoDB'
Error Number : 1286
Request Date : Tuesday, June 4th 2013 @ 07:28:01 AM
Error Date : Tuesday, June 4th 2013 @ 07:28:01 AM
Script : http://www.citroenbilten.com/forum/admincp/user.php?do=kill
Referrer : http://www.citroenbilten.com/forum/admincp/user.php?do=remove&u=6649
IP Address : 88.200.72.37
Username : 2cv
Classname : vB_Database
MySQL Version : 5.5.30-cll

i any body get some similar problem need help i coul pay for helpi realy need my forum back as soon is posibel..

--------------- Added 1370331762 at 1370331762 ---------------

citroen_vbver2.vb_contenttype
Error : Unknown storage engine 'InnoDB'
error : Corrupt

i found problem here is that normal vb type what happend if i drop this

Zachery
06-04-2013, 06:55 AM
Contact your webhost, something has gone wrong.

ales2cv
06-04-2013, 07:03 AM
thx it help s that i restrat mysql server
thx for help