TimeZone:While running the Admax.sh for CSC , .mysql.jdbc.exceptions.MySQLSyntaxErrorException occurs.

While running the Admax.sh for CSC , .mysql.jdbc.exceptions.MySQLSyntaxErrorException occurs.

Prerequisite:

Account Time is : Pacific/Auckland

saapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./admax.sh -t 61 --date 2011-11-04 -d3

2011-11-06 08:50:54.219 INFO [BusApplicationContext]: Refreshing org.apache.cxf.bus.spring.BusApplicationContext@37bd2664: display name [org.apache.cxf.bus.spring.BusApplicationContext@37bd2664]; startup date [Sun Nov 06 08:50:54 PST 2011]; root of context hierarchy

Nov 6, 2011 8:50:54 AM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources

INFO: No cxf.xml configuration file detected, relying on defaults.

2011-11-06 08:50:54.982 INFO [DefaultListableBeanFactory]: Overriding bean definition for bean 'org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder': replacing [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/83/tsa-build-bidmgr-2011-11-05-p83-r30844/libs/cxf/cxf.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/83/tsa-build-bidmgr-2011-11-05-p83-r30844/libs/cxf/cxf.jar!/META-INF/cxf/cxf-extension-http.fixml]]

.

.

.

011-11-06 08:51:12.941 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)

at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)

at com.carldunham.jst.db.Database.executeQuery(Database.java:356)

at com.carldunham.jst.db.Database.executeQuery(Database.java:308)

at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180)

at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169)

at com.carldunham.jst.db.JoinTable.select(JoinTable.java:163)

at com.thesearchagency.searchengines.SearchEngineAccountDispatcher.getEnabledSEAccounts(SearchEngineAccountDispatcher.java:251)

at com.thesearchagency.admax.algorithms.AdMaxAlgorithm.checkDataSources(AdMaxAlgorithm.java:799)

at com.thesearchagency.admax.algorithms.AdMaxWACPAlgorithm.applyAlgorithm(AdMaxWACPAlgorithm.java:104)

at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.run(AdMaxSummarizer.java:531)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

at java.util.concurrent.FutureTask.run(FutureTask.java:123)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)

at java.lang.Thread.run(Thread.java:595)

================= Detailed log has attached===========

gsingh@tvvm-staging-xml1:/var/local/tsa/log/2011-11-01$ grep 'error' .

admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:15.741 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:23.370 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:29.384 (2) [P1T1]: SQL 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 '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1 (code:1064)

-------------------------------------------------------------------------

gsingh@tvvm-staging-xml1:/var/local/tsa/log/2011-11-05$ grep 'error' .

admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:35.948 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:47.540 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:53.492 (2) [P1T1]: SQL 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 '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1 (code:1064)