Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

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

endaenda New
edited October 2012 in Vanilla 2.0 - 2.8

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!

Best Answers

  • peregrineperegrine MVP
    edited October 2012 Answer ✓

    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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • peregrineperegrine MVP
    Answer ✓

    @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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Answers

  • peregrineperegrine MVP
    edited October 2012 Answer ✓

    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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • 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?

  • peregrineperegrine MVP
    Answer ✓

    @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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

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

  • 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?

  • 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') {

  • @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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

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

  • 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?

Sign In or Register to comment.