cancel
Showing results for 
Search instead for 
Did you mean: 

Magento Error on front end after update package

Magento Error on front end after update package

Hi to all.

Please help me.

I have Magento 1.9.2.2. installed on Xampp server in localhost. Everything was going super good until today. I received msg October 27, 2015: New Magento Security Patch (SUPEE-6788). I use Magento Connect Manager to update all available packages from version 1.9.2.1. to 1.9.2.2. After updating i goth msg all is successful finished. But now i can`t open my localhost front end.

I delete cache files and maintenance.flag file.

This is msg on front end

There has been an error processing your request

Exception printing is disabled by default for security reasons.

Error log record number: 1535773814

 

And my log 1535773814 content

a:5:{i:0;s:643:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`value)` = '0') AND (`start_time` = '2015-11-' at line 2, query was: SELECT `main_table`.* FROM `bannerslider_banner` AS `main_table`
 LEFT JOIN `bannerslider_value` AS `status` ON main_table.banner_id = status.banner_id AND status.store_id = 1 AND status.attribute_code = 'status' WHERE (`bannerslider_id` = '3') AND (`IF(status`.`value IS NULL, main_table`.`status, status`.`value)` = '0') AND (`start_time` = '2015-11-17') ORDER BY order_banner ASC";i:1;s:4468:"#0 C:\xampp\htdocs\final\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 C:\xampp\htdocs\final\app\code\core\Zend\Db\Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 C:\xampp\htdocs\final\lib\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 C:\xampp\htdocs\final\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 C:\xampp\htdocs\final\lib\Varien\Db\Adapter\Pdo\Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 C:\xampp\htdocs\final\lib\Zend\Db\Adapter\Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 C:\xampp\htdocs\final\lib\Varien\Data\Collection\Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 C:\xampp\htdocs\final\app\code\core\Mage\Core\Model\Resource\Db\Collection\Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 C:\xampp\htdocs\final\lib\Varien\Data\Collection\Db.php(572): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 C:\xampp\htdocs\final\lib\Varien\Data\Collection.php(741): Varien_Data_Collection_Db->load()
#10 C:\xampp\htdocs\final\app\code\community\Magestore\Bannerslider\Block\Default.php(44): Varien_Data_Collection->getIterator()
#11 C:\xampp\htdocs\final\app\design\frontend\base\default\template\bannerslider\bannerslider.phtml(28): Magestore_Bannerslider_Block_Default->getBlockData()
#12 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Template.php(241): include('C:\\xampp\\htdocs...')
#13 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView('frontend\\base\\d...')
#14 C:\xampp\htdocs\final\app\code\community\Magestore\Bannerslider\Block\Bannerslider.php(47): Mage_Core_Block_Template->renderView()
#15 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Abstract.php(919): Magestore_Bannerslider_Block_Bannerslider->_toHtml()
#16 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Text\List.php(43): Mage_Core_Block_Abstract->toHtml()
#17 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#18 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#19 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#20 C:\xampp\htdocs\final\app\design\frontend\base\default\template\page\2columns-left.phtml(48): Mage_Core_Block_Abstract->getChildHtml('content')
#21 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Template.php(241): include('C:\\xampp\\htdocs...')
#22 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView('frontend\\base\\d...')
#23 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Template.php(286): Mage_Core_Block_Template->renderView()
#24 C:\xampp\htdocs\final\app\code\core\Mage\Core\Block\Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#25 C:\xampp\htdocs\final\app\code\core\Mage\Core\Model\Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#26 C:\xampp\htdocs\final\app\code\core\Mage\Core\Controller\Varien\Action.php(390): Mage_Core_Model_Layout->getOutput()
#27 C:\xampp\htdocs\final\app\code\core\Mage\Cms\Helper\Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#28 C:\xampp\htdocs\final\app\code\core\Mage\Cms\Helper\Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#29 C:\xampp\htdocs\final\app\code\core\Mage\Cms\controllers\IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#30 C:\xampp\htdocs\final\app\code\core\Mage\Core\Controller\Varien\Action.php(418): Mage_Cms_IndexController->indexAction()
#31 C:\xampp\htdocs\final\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#32 C:\xampp\htdocs\final\app\code\core\Mage\Core\Controller\Varien\Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#33 C:\xampp\htdocs\final\app\code\core\Mage\Core\Model\App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#34 C:\xampp\htdocs\final\app\Mage.php(684): Mage_Core_Model_App->run(Array)
#35 C:\xampp\htdocs\final\index.php(83): Mage::run('', 'store')
#36 {main}";s:3:"url";s:7:"/final/";s:11:"script_name";s:16:"/final/index.php";s:4:"skin";s:7:"default";}

 

 

 

 

Please help i don`t know what to do now.

1 REPLY

Re: Magento Error on front end after update package

You have the Magestore Bannerslider module installed.

 

The Magento patch has made you safe by denying their module from using an unsafe vulnerability injectable MySQL database access call.

 

Contact Magestore and get a module upgrade to fix this issue.