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

GoogleV2011_API_Upgrade:googleMCC throws exception - MySQLSyntaxErrorException: Unknown column 'keyword' 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:

      Trunk Build 474 on staging-xml1

      Description

      tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./googlemcc.sh --force -d3 --date 2011-06-28 -U 8

      {Detailed log is attached}

      .

      .

      .

      2011-06-27 01:09:09.281 (2) [P1T1]: pageviews

      2011-06-27 01:09:09.281 (2) [P1T1]: pageviewValue

      2011-06-27 01:09:09.281 (2) [P1T1]: defaultConv

      2011-06-27 01:09:09.284 (2) [P1T1]: defaultConvValue

      2011-06-27 01:09:09.289 (1) [P1T1]: Exception [ Error parsing /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'keyword' 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.execute(Statement.java:695)

      at com.carldunham.jst.db.Database.execute(Database.java:274)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseReport(GoogleAPISearchEngine.java:1714)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseReport(GoogleAPISearchEngine.java:1545)

      at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.run(GoogleMCCReport

        Attachments

        1. googlemcc_err.txt
          4 kB
          Saravanan
        2. googlemcc1.log
          7 kB
          Atul Sanagar
        3. googleMccLog.txt
          5 kB
          Jason Stedman

          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: