- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.