Last week any time I enter a detail image view get a display of code before the image. There is no problem in any other view. I have not changed anything not even added new images. Any help appreciated.
Thanks WB
---------
exception 'Database_Exception' with message '#1286: Unknown table engine 'InnoDB' [ SHOW COLUMNS FROM `g3product_overrides` ]' in /home/will2338/public_html/g3/system/libraries/Database_Mysqli_Result.php:27 Stack trace: #0 /home/will2338/public_html/g3/system/libraries/Database_Mysqli.php(79): Database_Mysqli_Result_Core->__construct(false, 'SHOW COLUMNS FR...', Object(mysqli), true) #1 /home/will2338/public_html/g3/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute('SHOW COLUMNS FR...') #2 /home/will2338/public_html/g3/modules/gallery/libraries/MY_Database.php(45): Database_Core->query('SHOW COLUMNS FR...') #3 /home/will2338/public_html/g3/system/libraries/Database_Mysql.php(193): Database->query('SHOW COLUMNS FR...') #4 /home/will2338/public_html/g3/system/libraries/ORM.php(1161): Database_Mysql_Core->list_fields('product_overrid...') #5 /home/will2338/public_html/g3/system/libraries/ORM.php(1031): ORM_Core->list_fields() #6 /home/will2338/public_html/g3/system/libraries/ORM.php(163): ORM_Core->reload_columns() #7 /home/will2338/public_html/g3/system/libraries/ORM.php(110): ORM_Core->__initialize() #8 /home/will2338/public_html/g3/system/libraries/ORM.php(88): ORM_Core->__construct(NULL) #9 /home/will2338/public_html/g3/modules/basket/helpers/product.php(142): ORM_Core::factory('product_overrid...') #10 /home/will2338/public_html/g3/modules/basket/helpers/basket_theme.php(39): product_Core::isForSale('231') #11 [internal function]: basket_theme_Core::photo_top(Object(Theme_View)) #12 /home/will2338/public_html/g3/modules/gallery/libraries/Theme_View.php(222): call_user_func_array(Array, Array) #13 /home/will2338/public_html/g3/themes/dark_canvas/views/photo.html.php(45): Theme_View_Core->__call('photo_top', Array) #14 /home/will2338/public_html/g3/themes/dark_canvas/views/photo.html.php(45): Theme_View->photo_top() #15 /home/will2338/public_html/g3/system/libraries/View.php(318): include('/home/will2338/...') #16 /home/will2338/public_html/g3/system/libraries/View.php(260): View_Core->load_view('/home/will2338/...', Array) #17 /home/will2338/public_html/g3/modules/gallery/libraries/MY_View.php(75): View_Core->render(false, false, false) #18 /home/will2338/public_html/g3/system/libraries/View.php(226): View->render() #19 /home/will2338/public_html/g3/themes/dark_canvas/views/page.html.php(139): View_Core->__toString() #20 /home/will2338/public_html/g3/system/libraries/View.php(318): include('/home/will2338/...') #21 /home/will2338/public_html/g3/system/libraries/View.php(260): View_Core->load_view('/home/will2338/...', Array) #22 /home/will2338/public_html/g3/modules/gallery/libraries/MY_View.php(75): View_Core->render(false, false, false) #23 /home/will2338/public_html/g3/system/libraries/View.php(226): View->render() #24 /home/will2338/public_html/g3/modules/gallery/controllers/photos.php(55): View_Core->__toString() #25 [internal function]: Photos_Controller->show(Object(Item_Model)) #26 /home/will2338/public_html/g3/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Photos_Controller), Array) #27 [internal function]: Kohana_Core::instance(NULL) #28 /home/will2338/public_html/g3/system/core/Event.php(208): call_user_func_array(Array, Array) #29 /home/will2338/public_html/g3/application/Bootstrap.php(67): Event_Core::run('system.execute') #30 /home/will2338/public_html/g3/index.php(102): require('/home/will2338/...') #31 {main}
Posted: Sat, 2012-06-09 09:42
Posts: 304
You seem to have installed the Basket module, which for some reasons creates its tables with ENGINE=InnoDB as part of the install command. However, I don’t think Basket really uses the transactional features of InnoDB, it seems superfluous (I have used Basket without InnoDB).
Apparently, your MySQL runs without InnoDB, which is why you get the error message. There are tables defined as InnoDB, but they can’t be processed with the MyISAM engine.
Solution 1: disable the Basket module
Solution 2 (advanced): if you have access to your database server, edit my.cnf and look for skip-innodb; if it’s there, prepend a # comment before the statement, save and restart the server. This will enable InnoDB and also make your SQL require much more memory.
Solution 3 (advanced): fire up myphpadmin or a similar tool and manually hange the Basket module tables to MyISAM instead of InnoDB.
Posts: 155
Thanks Inposure, that fixed the problem. WB