Message:
invalid query:- SELECT a.*,b.*
FROM banner_ad a
LEFT JOIN page_banner_order b
ON b.banner_id = a.banner_ad_id
WHERE b.page_id = ORDER BY b.display_order ASC
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 b.display_order ASC' at line 5
Created in file
/home/tristar1/public_html/usol/lib/database/SqlDatabaseManager.class.php on line
148.
Stack Trace:#0 /home/tristar1/public_html/protected/appcode/datamanager/ContentDataManager.class.php(1113): SqlDatabaseManager->executeQuery('SELECT a.*,b.* ...')
#1 /home/tristar1/public_html/protected/classes/CommonContent.class.php(884): ContentDataManager->getBannersById(NULL, true)
#2 /home/tristar1/public_html/protected/controller/content.php(37): CommonContent->getTopBanner('business-descri...')
#3 [internal function]: content->page('business-descri...')
#4 /home/tristar1/public_html/usol/lib/RegisterCallback.class.php(8): call_user_func_array(Array, Array)
#5 /home/tristar1/public_html/usol/lib/Application.class.php(47): RegisterCallback::register(Object(content), 'page', Array)
#6 /home/tristar1/public_html/index.php(12): Application::run(Object(HttpRequest))
#7 {main}- 6.
- In file /home/tristar1/public_html/protected/appcode/datamanager/ContentDataManager.class.php line 1113.
Method: SqlDatabaseManager->executeQuery([$query FILTERED]) - 5.
- In file /home/tristar1/public_html/protected/classes/CommonContent.class.php line 884.
Method: ContentDataManager->getBannersById([$page_id FILTERED], [$isClient FILTERED]) - 4.
- In file /home/tristar1/public_html/protected/controller/content.php line 37.
Method: CommonContent->getTopBanner([$pageLink FILTERED]) - 3.
- In file unknown line unknown.
Method: content->page([$link FILTERED]) - 2.
- In file /home/tristar1/public_html/usol/lib/RegisterCallback.class.php line 8.
Method: call_user_func_array([$function_name FILTERED], [$parameters FILTERED]) - 1.
- In file /home/tristar1/public_html/usol/lib/Application.class.php line 47.
Method: RegisterCallback::register([$class FILTERED], [$funcName FILTERED], [$args FILTERED]) - 0.
- In file /home/tristar1/public_html/index.php line 12.
Method: Application::run([$request FILTERED])