Unknown storage engine 'InnoDB'

[briscochan]

hi let me describe the current situation,

firstly i have the problem with the wishlist and guest checkout especially with the state name. with the wishlist i just get rid of it because with the wishlist module in my shop it will messing up the whole system to the payment method. 

 

State Name, when i browse in comunity i realize that im not the only one with this matter, 1.5 and 1.6 also has it so i turned off the state at preferences, other solution of it is write the code AJAX and call the combobox but i can;t find any code that connected to those state of my country to make it appear, so i make the state blank in the publichtml/themes i realize its not the solution but to prevent it. 

 

after i done with those two ( wishlist and State), other pproblem is occured. since 2 days ago i can't access my shop it writen " 500 INTERNAL ERROR" so i checked everywhere and activated the debug mode in

 

 /config/defines.inc.php

 

define('_PS_MODE_DEV_', false);

 

and changed it to 

define('_PS_MODE_DEV_', true);   with changing it i can see the Errorin my php and the area that need to 

be changed immediately.

 

 

What should i do with the errors? driven me nut all day i can't access my shop...

please someone help me with the code.

 i afraid if i changed the code it would fucked up the whole operation because the problem is in the PHP files.

sorry for my bad english im from indonesia.

• PrestaShopDatabaseException]

  Unknown storage engine 'InnoDB'
   

  SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
                      FROM ps_newshop_url su
                      LEFT JOIN ps_newshop s ON (s.id_shop = su.id_shop)
                      WHERE (su.domain = 'klikprinter.com' OR su.domain_ssl = 'klikprinter.com')
                          AND s.active = 1
                          AND s.deleted = 0
                      ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
  at line 791 in file classes/db/Db.php

   

  786. if ($webservice_call && $errno) {
  787. $dbg = debug_backtrace();
  788. WebserviceRequest::getInstance()->setError(500, '

   '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
  789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
  790. if ($sql) {
  791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
  792. }
  793.
  794. throw new PrestaShopDatabaseException($this->getMsgError());
  795. }
  796. }

  • DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
  • DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
  • DbCore->executeS - [line 334 - classes/shop/Shop.php] - [1 Arguments]
  • ShopCore::initialize - [line 114 - config/config.inc.php]
  • require - [line 27 - index.php] - [1 Arguments]
    Argument [0]
    /home/klikprinter/public_html/config/config.inc.php

   

  

Edited June 1, 2017 by briscochan (see edit history)

[lovemyseo]

 

hi let me describe the current situation,

firstly i have the problem with the wishlist and guest checkout especially with the state name. with the wishlist i just get rid of it because with the wishlist module in my shop it will messing up the whole system to the payment method. 

 

State Name, when i browse in comunity i realize that im not the only one with this matter, 1.5 and 1.6 also has it so i turned off the state at preferences, other solution of it is write the code AJAX and call the combobox but i can;t find any code that connected to those state of my country to make it appear, so i make the state blank in the publichtml/themes i realize its not the solution but to prevent it. 

 

after i done with those two ( wishlist and State), other pproblem is occured. since 2 days ago i can't access my shop it writen " 500 INTERNAL ERROR" so i checked everywhere and activated the debug mode in

 

 /config/defines.inc.php

 

define('_PS_MODE_DEV_', false);

 

and changed it to 

define('_PS_MODE_DEV_', true);   with changing it i can see the Errorin my php and the area that need to 

be changed immediately.

 

 

What should i do with the errors? driven me nut all day i can't access my shop...

please someone help me with the code.

 i afraid if i changed the code it would fucked up the whole operation because the problem is in the PHP files.

sorry for my bad english im from indonesia.

• PrestaShopDatabaseException]

  Unknown storage engine 'InnoDB'

   

  SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main

                      FROM ps_newshop_url su

                      LEFT JOIN ps_newshop s ON (s.id_shop = su.id_shop)

                      WHERE (su.domain = 'klikprinter.com' OR su.domain_ssl = 'klikprinter.com')

                          AND s.active = 1

                          AND s.deleted = 0

                      ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

  at line 791 in file classes/db/Db.php

   

  786. if ($webservice_call && $errno) {

  787. $dbg = debug_backtrace();

  788. WebserviceRequest::getInstance()->setError(500, '

   '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

  789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

  790. if ($sql) {

  791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

  792. }

  793.

  794. throw new PrestaShopDatabaseException($this->getMsgError());

  795. }

  796. }

  • DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
  • DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
  • DbCore->executeS - [line 334 - classes/shop/Shop.php] - [1 Arguments]
  • ShopCore::initialize - [line 114 - config/config.inc.php]
  • require - [line 27 - index.php] - [1 Arguments]
    Argument [0]

    /home/klikprinter/public_html/config/config.inc.php

   

  debugg.jpg

   

  Remove initial line from DB please post your question only whole file not required

[bellini13]

apparently your database does not support the InnoDB storage type, which is a pretty standard storage engine for MySQL, and the one that Prestashop defaults to using.

 

You will need to work with your hosting provider to enable the InnoDB storage type, or you will need to update Prestashop core files to default to using which ever storage type your database supports.

[briscochan]

thanks for the responce. now my shop is working just fine , it seems the hosting provider just work it out.