Rookie Admin - Fatal Error : Unknown table engine 'InnoDB'
enda
New
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
-
peregrine
MVP
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.
1
Answers
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
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?
@enda
I fixed it with a magic spell sent over the internet. You only get one wish.
Thank you kind Genie for your utmost kind, I can't thank you enough!
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') {
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
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?