2009-03-24 18:13:09.643 (3) [P1T0]: Opening pixel log file 09032417-319.txt 2009-03-24 18:13:09.822 (1) [P1T0]: Exception [Error loading record]: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 '; __utma=212945814.1221795568.1237836958.1237836958.1237836958.1; __utmz=2129458' 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: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.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:380) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:341) at com.thesearchagency.playback.SpikeVisitor.load(SpikeVisitor.java:87) at com.thesearchagency.playback.RecordedCGISpikeTracker.updateSession(RecordedCGISpikeTracker.java:465) at com.thesearchagency.playback.RecordedCGISpikeTracker.record(RecordedCGISpikeTracker.java:254) at com.thesearchagency.playback.SpikePlayer$RecordHitPixel.recordHit(SpikePlayer.java:914) at com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.parseFile(SpikePlayer.java:565) at com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.run(SpikePlayer.java:500) at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248) 2009-03-24 18:13:09.832 (1) [P1T0]: Exception [Error saving record]: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 '; __utma=212945814.1221795568.1237836958.1237836958.1237836958.1; __utmz=2129458' 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.Statement.executeUpdate(Statement.java:1316) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235) at com.carldunham.jst.db.Database.executeUpdate(Database.java:401) at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:460) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:400) at com.thesearchagency.playback.SpikeVisitor.makeVisitorRow(SpikeVisitor.java:213) at com.thesearchagency.playback.SpikeVisitor.load(SpikeVisitor.java:98) at com.thesearchagency.playback.RecordedCGISpikeTracker.updateSession(RecordedCGISpikeTracker.java:465) at com.thesearchagency.playback.RecordedCGISpikeTracker.record(RecordedCGISpikeTracker.java:254) at com.thesearchagency.playback.SpikePlayer$RecordHitPixel.recordHit(SpikePlayer.java:914) at com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.parseFile(SpikePlayer.java:565) at com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.run(SpikePlayer.java:500) at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248) 2009-03-24 18:13:09.872 (2) [P1T0]: Warning(s) detected in statement [select * from `waypoints` where (`id`="1015") limit 1] executed by user [spike] 2009-03-24 18:13:09.880 (2) [P1T0]: 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 '; __utma=212945814.1221795568.1237836958.1237836958.1237836958.1; __utmz=2129458' at line 1 (code:1064) 2009-03-24 18:13:09.900 (2) [P1T0]: Warning(s) detected in statement [select * from `tsacommon`.`distribution` where ((`shortCode`="go")) limit 1] executed by user [spike] 2009-03-24 18:13:09.902 (2) [P1T0]: 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 '; __utma=212945814.1221795568.1237836958.1237836958.1237836958.1; __utmz=2129458' at line 1 (code:1064)