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

Sync looking in wrong database for settings table

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: xOther
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      2910

      Description

      In a google sync this morning I saw:

      2009-05-05 09:08:39.995 (2) [P0T6]: Exception [loading
      settings]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
      'tsacommon.settings' doesn't exist
      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.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
      at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149)
      at com.thesearchagency.Settings.load(Settings.java:220)
      at com.thesearchagency.Settings.<init>(Settings.java:86)
      at com.thesearchagency.Settings.getSettings(Settings.java:57)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.getMinimumBid(SearchEngineUpdater.java:1967)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1505)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.run(SearchEngineUpdater.java:1361)
      at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248)

      2009-05-05 09:08:39.995 (3) [P0T6]: Schema 'cpcMinimumAction' doesn't exist in
      scope searchEngineAccounts
      2009-05-05 09:08:39.996 (3) [P0T6]: Setting unset bidtarget max bid to existing
      or se minimum bid (0.01)

      The settings table exists in st-tracker not tsacommon. No idea how dangerous
      this is.

      Log exists at:

      https://client.thesearchagency.com/taskhistorydebug.php?tskdbgType=stderrCompressed&tskdbgID=2860242

        Attachments

          Activity

            People

            • Assignee:
              pwynne Patrick Wynne
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: