Mysqli prepare error: Unknown storage engine 'InnoDB'

dohoafx

Registered
Nov 7, 2014
2
0
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 occurred: Mysqli prepare error: Unknown 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
 
Last edited by a moderator:

dohoafx

Registered
Nov 7, 2014
2
0
1
cPanel Access Level
Website Owner
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 it