HOME > PHP > PHP Forum > error แบบนี่ต้องแก้ไขยังไงค่ะ 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 ') ORDER BY
error แบบนี่ต้องแก้ไขยังไงค่ะ 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 ') ORDER BY
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 ') ORDER BY `lft` ASC' at line 1
Trace:
#0 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Db/Table/Abstract.php(1509): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Db/Table/Abstract.php(1325): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#5 /home/banchatest/domains/banchatets.net/public_html/app/code/App/Category/Model/Category.php(422): Zend_Db_Table_Abstract->fetchAll('cat_status = 'e...', 'lft')
#6 /home/banchatest/domains/banchatets.net/public_html/app/code/App/Category/Model/Halu.php(1397): App_Category_Model_Category->getDisabledIds()
#7 /home/banchatest/domains/banchatets.net/public_html/app/code/App/Category/Box/New.php(18): App_Category_Model_Halu->getNewHaluIds(Array)
#8 /home/banchatest/domains/banchatets.net/public_html/app/code/App/Core/Box/Abstract.php(49): App_Category_Box_New->initData()
#9 /home/banchatest/domains/banchatets.net/public_html/library/App/Layout.php(240): App_Core_Box_Abstract->toHtml()
#10 /home/banchatest/domains/banchatets.net/public_html/library/App/Layout.php(206): App_Layout->_getBoxContent(Array)
#11 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Layout/Controller/Plugin/Layout.php(149): App_Layout->__get('content')
#12 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Controller/Plugin/Broker.php(331): Zend_Layout_Controller_Plugin_Layout->postDispatch(Object(Zend_Controller_Request_Http))
#13 /home/banchatest/domains/banchatets.net/public_html/library/Zend/Controller/Front.php(957): Zend_Controller_Plugin_Broker->postDispatch(Object(Zend_Controller_Request_Http))
#14 /home/banchatest/domains/banchatets.net/public_html/library/App/Bootstrap.php(51): Zend_Controller_Front->dispatch()
#15 /home/banchatest/domains/banchatets.net/public_html/index.php(26): App_Bootstrap::run(Array)
#16 {main}
Load balance : Server 04
