database exception - Unknown column in 'where clause'

[snakemouse]

Hi,

 

i was struggling to import products csv but somehow the website has got database exceptions..

Anybody can help me to get through this? i am really new in this field

i am able to access to back office (1.6.014)

[PrestaShopDatabaseException]

Unknown column 'link_color' in 'where clause'
 

SELECT *
FROM `mtm_st_mega_menu`
WHERE (`txt_color`!="" || `link_color`!="" || `txt_color_over`!="" || `bg_color`!="" || `bg_color_over`!="" || `tab_content_bg`!="" || `bg_image`!="" || `bg_margin_bottom`!="" || `cate_label_color`!="" || `cate_label_bg`!="")
AND `active`=1
at line 646 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 297 - modules/stmegamenu/StMegaMenuClass.php] - [1 Arguments]
• StMegaMenuClass::getCustomCss - [line 3580 - modules/stmegamenu/stmegamenu.php]
• StMegaMenu->hookDisplayHeader - [line 510 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 456 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 11 - override/classes/controller/FrontController.php]
• FrontController->initContent - [line 37 - controllers/front/IndexController.php]
• IndexControllerCore->initContent - [line 15 - override/controllers/front/IndexController.php]
• IndexController->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[tuk66]

It is something wrong with the stmegamenu module. I don't know this module, but you can try to uninstall it and install again.

[snakemouse]

Yeap all good, i reset it and solved

Thank you