Bug Unknown table engine 'InnoDB'

[Bravo]

Hey Dark, I just got home and was told my site has been down since 9am and all I get is this DB error

Database error in vBulletin 4.1.1:

Invalid SQL:
SELECT t.* FROM credits_transaction AS t LEFT JOIN credits_event AS e ON (t.eventid = e.eventid) WHERE t.userid = 2731 AND t.status = 0 AND t.timestamp <= (1294966328 - IF(ISNULL(e.eventid), 0, e.delay)) ORDER BY t.transactionid ASC LIMIT 1;

MySQL Error : Unknown table engine 'InnoDB'
Error Number : 1286

Any Ideas whats going on here????

Thanks

 

[Darkwaltz4]

Please pass that along to your host - for some reason the database is allowed to be innodb, but the definition for using it is missing.

 

[Bravo]

What kind of information is stored there? cause the table was lost because of the innodb error and I'm wondering whether or not I can rebuild it or have to re-install everything from scratch.

 

[Darkwaltz4]

The transaction table is the only one that should be innodb for performance reasons. It could run as myisam if you dont support it.

You can rebuild it by recalculating with this: http://www.dragonbyte-tech.com/threads/1270-vBCredits-II-Deluxe-API