Rookie Admin - Fatal Error : Unknown table engine 'InnoDB'

enda

Hi guys, I am a rookie admin working with Vanilla forum. Just installed the script and playing around with the setting when suddenly got bonk message.

This is the fatal error message:

Unknown table engine 'InnoDB'
select * from GDN_User User where UserID = :UserID
The error occurred on or near: /home/holagcom/public_html/library/database/class.database.php

276:

277: if (!is_object($PDOStatement)) {

278: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);

279: } else if ($PDOStatement->execute($InputParameters) === FALSE) {

280: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

281: }

282: } else {

283: $PDOStatement = $this->Connection()->query($Sql);

284: }

Could someone help me step by step what should I do now with the site?

Thank you in advance!

peregrine

It looks like you don't have innodDB support.

go into phpmyadmin and try

show engines;

it should show a table of supported engines. If InnodDB is not supported by your host provider ask them to support it or find another host provider.

InnoDB YES Supports transactions, row-level locking, and fore... YES YES YES

you can also search for innodB on this forum for other conversations relating to this.

e.g.
http://vanillaforums.org/discussion/20038/2-0-8-4-update-fail-blank-page-on-utility-update-and-utility-structure

peregrine

@enda

Hi Thanks for you help, but the site holabdg.com suddenly works just fine while I don't do anything, do you know what cause that?

I fixed it with a magic spell sent over the internet. You only get one wish.

peregrine

It looks like you don't have innodDB support.

go into phpmyadmin and try

show engines;

it should show a table of supported engines. If InnodDB is not supported by your host provider ask them to support it or find another host provider.

InnoDB YES Supports transactions, row-level locking, and fore... YES YES YES

you can also search for innodB on this forum for other conversations relating to this.

e.g.
http://vanillaforums.org/discussion/20038/2-0-8-4-update-fail-blank-page-on-utility-update-and-utility-structure

enda

Hi Thanks for you help, but the site holabdg.com suddenly works just fine while I don't do anything, do you know what cause that?

peregrine

@enda

Hi Thanks for you help, but the site holabdg.com suddenly works just fine while I don't do anything, do you know what cause that?

I fixed it with a magic spell sent over the internet. You only get one wish.

enda

Thank you kind Genie for your utmost kind, I can't thank you enough!

enda

Now it's showing fatal error again, I am really don't know what's happening http://holabdg.com/ is it really the hosting company?

enda

Different error message though, or is it the same?

Unknown table engine 'InnoDB'
select * from GDN_Permission Permission limit 1
The error occurred on or near: /home/holagcom/public_html/library/database/class.database.php

283: $PDOStatement = $this->Connection()->query($Sql);

284: }

285:

286: if ($PDOStatement === FALSE) {

287: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

288: }

289:

290: // Did this query modify data in any way?

291: if ($ReturnType == 'ID') {

peregrine

@enda said:
Now it's showing fatal error again, I am really don't know what's happening http://holabdg.com/ is it really the hosting company?

this a question to ask the hosting company. Maybe they are upgrading or modifying things.

Did you do show engines? what version of sql are you using? And read the comment in the first message. Sorry the magic spell only works for 4 hrs .
Now you are going to have to use logic with your host provider.

post your results.

---

also see

http://stackoverflow.com/questions/7303133/unknown-table-engine-innodb

http://stackoverflow.com/questions/7782870/error-unknown-table-engine-innodb-on-query-after-restarting-mysql

http://dba.stackexchange.com/questions/6859/error-unknown-table-engine-innodb-on-query-after-restarting-mysql

enda

Thank @peregrine for your help, I'm checking with my hosting provider now.

YSC

Hi @peregrine how about my forums, there has innoDB YES YES YES but i still get some fatal error now. I just deactive vanilla application in last click and BANG its go down. did anyone have solution for this case?