I've been getting this error recently:
Zend_Db_Statement_Mysqli_Exception: 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 'DESC LIMIT 5 OFFSET 10' at line 18 -library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 6:22 PM
Stack Trace
#0 /home/filmschool/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tSELECT fea...')
#1 /home/filmschool/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tSELECT fea...')
#2 /home/filmschool/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tSELECT fea...')
#3 /home/filmschool/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT fea...', 1, 2)
#4 /home/filmschool/public_html/library/CTA/FeaturedThreads/Model/Featured.php(70): XenForo_Model->fetchAllKeyed('\r\n\t\t\tSELECT fea...', 'thread_id', 1)
#5 /home/filmschool/public_html/library/CTA/FeaturedThreads/ControllerPublic/Thread.php(199): CTA_FeaturedThreads_Model_Featured->getFeaturedThreadsToDisplay(Array, 1, Array)
#6 /home/filmschool/public_html/library/XenForo/FrontController.php(351): CTA_FeaturedThreads_ControllerPublic_Thread->actionFeatured()
#7 /home/filmschool/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/filmschool/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(49) "
http://www.filmschool.org/threads/featured?page=3"
["_GET"] => array(1) {
["page"] => string(1) "3"
}
["_POST"] => array(0) {
}
}
Server Error Log
Error Info
ErrorException: Undefined variable: orderBy - library/CTA/FeaturedThreads/Model/Featured.php:104
Generated By: Unknown Account, Today at 6:22 PM
Stack Trace
#0 /home/filmschool/public_html/library/CTA/FeaturedThreads/Model/Featured.php(104): XenForo_Application::handlePhpError(8, 'Undefined varia...', '/home/filmschoo...', 104, Array)
#1 /home/filmschool/public_html/library/CTA/FeaturedThreads/Model/Featured.php(47): CTA_FeaturedThreads_Model_Featured->prepareOrderOptions(Array)
#2 /home/filmschool/public_html/library/CTA/FeaturedThreads/ControllerPublic/Thread.php(199): CTA_FeaturedThreads_Model_Featured->getFeaturedThreadsToDisplay(Array, 1, Array)
#3 /home/filmschool/public_html/library/XenForo/FrontController.php(351): CTA_FeaturedThreads_ControllerPublic_Thread->actionFeatured()
#4 /home/filmschool/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#5 /home/filmschool/public_html/index.php(13): XenForo_FrontController->run()
#6 {main}
Request State
array(3) {
["url"] => string(49) "
http://www.filmschool.org/threads/featured?page=3"
["_GET"] => array(1) {
["page"] => string(1) "3"
}
["_POST"] => array(0) {
}
}
ErrorException: Undefined index: sortDirection - library/CTA/FeaturedThreads/ControllerPublic/Thread.php:190
Generated By: Unknown Account, Today at 6:22 PM
Stack Trace
#0 /home/filmschool/public_html/library/CTA/FeaturedThreads/ControllerPublic/Thread.php(190): XenForo_Application::handlePhpError(8, 'Undefined index...', '/home/filmschoo...', 190, Array)
#1 /home/filmschool/public_html/library/XenForo/FrontController.php(351): CTA_FeaturedThreads_ControllerPublic_Thread->actionFeatured()
#2 /home/filmschool/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#3 /home/filmschool/public_html/index.php(13): XenForo_FrontController->run()
#4 {main}
Request State
array(3) {
["url"] => string(49) "
http://www.filmschool.org/threads/featured?page=3"
["_GET"] => array(1) {
["page"] => string(1) "3"
}
["_POST"] => array(0) {
}
}