Mysqli prepare error: Unknown storage engine 'InnoDB'
Dear support
I use VPS digitalocean, I use Xenforo source code for the site, two days ago, I get this message:
[PHP]An exception occurred: Mysqli prepare error: Unknown storage engine 'InnoDB' in /home/channeldohoa/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 77[/PHP]
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[/PHP]
Please help me to overcome this difficulty, thank you very much
-
This thread may be of some use: /https://xenforo.com/community/threads/an-exception-occurred-mysqli-prepare-error-unknown-storage-engine-innodb.33212/ 0 -
]This thread may be of some use: /https://xenforo.com/community/threads/an-exception-occurred-mysqli-prepare-error-unknown-storage-engine-innodb.33212/
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 it0 -
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 ? 0
Please sign in to leave a comment.
Comments
3 comments