Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2701

GoogleV2011_API_Upgrade: Sesummarizer throws exception - MySQLSyntaxErrorException: Unknown column 'tmp15.kwDestUrl' in 'field list'

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: Google v201101
    • Fix Version/s: Google v201101
    • Component/s: Google
    • Labels:
      None
    • Environment:

      Build tsa-build-bidmgr-2011-06-22-p18-r29737 on staging-xml1

      Description

      tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./sesummarize.sh -d4 --distribution 3 --seuser 8 2>&1|tee /tmp/sesummari.log

      .

      .

      .

      2011-06-19 01:39:53.023 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp15.kwDestUrl' in 'field list'

      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:1172)

      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:151)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150)

      at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830)

      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)

        Attachments

          Activity

            People

            • Assignee:
              jason.stedman Jason Stedman (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: