Lỗi xenportal

[hardcore]

An exception occurred: Mysqli prepare error: 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 ') OR EWRporta_promotes.promote_date < ? ) AND xf_thread.discussion_state = ' at line 11 in C:\xampp\htdocs\library\Zend\Db\Statement\Mysqli.php on line 77

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
5. Zend_Db_Adapter_Abstract->fetchAll() in EWRporta/Block/RecentNews.php at line 38
6. EWRporta_Block_RecentNews->getModule() in EWRporta/Model/Blocks.php at line 116
7. EWRporta_Model_Blocks->getBlockParams() in EWRporta/ViewPublic/Custom.php at line 71
8. EWRporta_ViewPublic_Custom->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
9. XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 71
10. XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 586
11. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
12. XenForo_FrontController->run() in C:/xampp/htdocs/index.php at line 13

 

[Võ Đình Nghĩa]

Vào database đổi tên các table sau

• ewrporta_blocks
• 
  ewrporta_caches
• 
  ewrporta_categories
• 
  ewrporta_catlinks
• 
  ewrporta_layouts
• 
  ewrporta_options
• 
  ewrporta_promotes

Thành

• EWRporta_blocks
• EWRporta_caches
• EWRporta_categories
• EWRporta_catlinks
• EWRporta_layouts
• EWRporta_options
• EWRporta_promotes

 

[hardcore]

Trong database nó đều thành ntn rồi bác ạ

 

[hardcore]

An exception occurred: Mysqli prepare error: 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 ') OR EWRporta_promotes.promote_date < ? ) AND xf_thread.discussion_state = ' at line 11 in /home/apnazzkw/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
5. Zend_Db_Adapter_Abstract->fetchAll() in EWRporta/Block/RecentNews.php at line 38
6. EWRporta_Block_RecentNews->getModule() in EWRporta/Model/Blocks.php at line 116
7. EWRporta_Model_Blocks->getBlockParams() in EWRporta/ViewPublic/Custom.php at line 71
8. EWRporta_ViewPublic_Custom->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
9. XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 71
10. XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 586
11. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
12. XenForo_FrontController->run() in /home/apnazzkw/public_html/index.php at line 13

 

[ptvinhdtk]

Phương án cuối backup data :v

 

[xenforo]

Mình gặp lỗi này, tìm hiểu bên xenforo thì tắt reinstall các block Recent New đi là chạy lại đc