The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysqli prepare error: Unknown storage engine 'InnoDB'

Discussion in 'Database Discussions' started by dohoafx, Nov 8, 2014.

  1. dohoafx

    dohoafx Registered

    Joined:
    Nov 7, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Dear support

    I use VPS digitalocean, I use Xenforo source code for the site, two days ago, I get this message:
    PHP:
    An exception occurredMysqli prepare errorUnknown storage engine 'InnoDB' in /home/channeldohoa/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 77
    Please see: - Removed -

    I've followed the instructions, by:
    1. Stop MySQL
    2. Remove the Log File
    3. Then start MySQL.

    Then it works again, but only 15 minutes it was the message "An exception occurred: Mysqli Prepare error: Unknown storage engine 'InnoDB' print '

    This is the text file: /etc/my.cnf
    PHP:
    [mysqld]
    max_allowed_packet 16M
    default-storage-engine MyISAM
    innodb_use_native_aio 
    0

    Please help me to overcome this difficulty, thank you very much
     
    #1 dohoafx, Nov 8, 2014
    Last edited by a moderator: Nov 8, 2014
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,472
    Likes Received:
    200
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    This thread may be of some use:
    /https://xenforo.com/community/threads/an-exception-occurred-mysqli-prepare-error-unknown-storage-engine-innodb.33212/
     
  3. dohoafx

    dohoafx Registered

    Joined:
    Nov 7, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Thanks for help, the link you sent does not help me to solve this problem.

    My problem is "Unknown InnoDB storage engine". I was not able to fix this in my MySQL server

    If you know, please help me handle it
     
  4. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hello dohoafx,

    Can you try these steps ?

    - Stop MySQL service
    - Remove the log file
    - Comment the line 'innodb_use_native_aio' in your /etc/my.cnf
    - Restart the service

    How does this go about ?
     
Loading...
Similar Threads - Mysqli prepare error
  1. Von6
    Replies:
    3
    Views:
    1,042

Share This Page