Change Details

``` [2016-11-11 18:52:09] [CLIENT] RECEIVED REMOTE FLEET (already existed): Fleet [members=[FleetMember [state=Client(1), sector=(2, 2, 2), UID=ENTITY_SHIP_Test 1, name=Test 1, command=, changed=false, entityDbId=535]], name=my new fleet, owner=SmilingTester, dbid=1, parentFleet=0, missionString=IDLING, state=Client(1), markForCacheCheck=false, flagRemove=false] [2016-11-11 18:52:12] chat carrier reset!!! up 26 [2016-11-11 18:52:14] [CLIENT] Admin parameter 0: Test [2016-11-11 18:52:14] [CLIENT] Admin parameter 1: all [2016-11-11 18:52:14] [CLIENT] Admin parameter 2: true [2016-11-11 18:52:14] [ADMIN COMMAND] DESPAWN_ALL from RegisteredClient: SmilingTester (1) connected: true params: [Test, all, true] [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [SUCCESS] ACTIVE DESPAWNED Ship[Test 2](193) to RegisteredClient: SmilingTester (1) connected: true [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [SUCCESS] ACTIVE DESPAWNED Ship[Test 1](192) to RegisteredClient: SmilingTester (1) connected: true [2016-11-11 18:52:14] [DESPAWN] using escaped matching string 'Test%' [2016-11-11 18:52:14] [SQL] DESPAWNING: ENTITY_SHIP_Test 2 DELETE .ENT SUC false; RAW DATA FILES FOUND AND REMOVED: 0 [2016-11-11 18:52:14] java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS [2016-11-11 18:52:14] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) [2016-11-11 18:52:14] at org.schema.game.common.controller.database.DatabaseIndex.a(SourceFile:2942) [2016-11-11 18:52:14] at obfuscated.auX.o(SourceFile:1156) [2016-11-11 18:52:14] at obfuscated.auX.a(SourceFile:1565) [2016-11-11 18:52:14] at org.schema.game.server.controller.GameServerController.update(SourceFile:1018) [2016-11-11 18:52:14] at org.schema.schine.network.server.ServerController.run(SourceFile:273) [2016-11-11 18:52:14] at java.lang.Thread.run(Unknown Source) [2016-11-11 18:52:14] Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS [2016-11-11 18:52:14] at org.hsqldb.error.Error.error(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.StatementDML.performReferentialActions(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.StatementDML.delete(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.StatementDML.getResult(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.StatementDMQL.execute(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.Session.executeCompiledStatement(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.Session.executeDirectStatement(Unknown Source) [2016-11-11 18:52:14] at org.hsqldb.Session.execute(Unknown Source) [2016-11-11 18:52:14] ... 8 more [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [ERROR] SQL EXCEPTION to RegisteredClient: SmilingTester (1) connected: true ```

Not fixed, different stacktrace: ``` [2017-03-22 13:56:01] [DESPAWN] using escaped matching string 'Alpha Fleet Ship%' [2017-03-22 13:56:03] java.sql.SQLSyntaxErrorException: unknown token: [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) [2017-03-22 13:56:03] at org.schema.game.common.controller.database.DatabaseIndex.a(SourceFile:3219) [2017-03-22 13:56:03] at obfuscated.axH.p(SourceFile:1175) [2017-03-22 13:56:03] at obfuscated.axH.a(SourceFile:1588) [2017-03-22 13:56:03] at org.schema.game.server.controller.GameServerController.update(SourceFile:1021) [2017-03-22 13:56:03] at org.schema.schine.network.server.ServerController.run(SourceFile:275) [2017-03-22 13:56:03] at java.lang.Thread.run(Thread.java:745) [2017-03-22 13:56:03] Caused by: org.hsqldb.HsqlException: unknown token: [2017-03-22 13:56:03] at org.hsqldb.error.Error.error(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.error.Error.error(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserBase.read(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.readColumnOrFunctionExpression(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadRowOrCommonValueExpression(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadRowValuePredicand(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadPredicateRightPart(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadBooleanPrimaryOrNull(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadBooleanTestOrNull(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadBooleanFactorOrNull(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadBooleanTermOrNull(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDQL.XreadBooleanValueExpression(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDML.XreadAndResolveBooleanValueExpression(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserDML.compileDeleteStatement(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserCommand.compilePart(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.ParserCommand.compileStatements(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.Session.executeDirectStatement(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.Session.execute(Unknown Source) [2017-03-22 13:56:03] ... 8 more ```

Not fixed, different stacktrace: ``` [2017-03-22 13:56:01] [DESPAWN] using escaped matching string 'Alpha Fleet Ship%' [2017-03-22 13:56:03] java.sql.SQLSyntaxErrorException: unknown token: [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) [2016-11-11 18:52:09] [CLIENT] RECEIVED REMOTE FLEET (already existed): Fleet [members=[FleetMember [state=Client(1), sector=(2, 2, 2), UID=ENTITY_SHIP_Test 1, name=Test 1, command=, changed=false, entityDbId=535]], name=my new fleet, owner=SmilingTester, dbid=1, parentFleet=0, missionString=IDLING, state=Client(1), markForCacheCheck=false, flagRemove=false]7-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) [2016-11-11 18:52:12] chat carrier reset!!! up 262017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) [2016-11-11 18:52:14] [CLIENT] Admin parameter 0: Test2017-03-22 13:56:03] at org.schema.game.common.controller.database.DatabaseIndex.a(SourceFile:3219) [2016-11-11 18:52:14] [CLIENT] Admin parameter 1: all2017-03-22 13:56:03] at obfuscated.axH.p(SourceFile:1175) [2016-11-11 18:52:14] [CLIENT] Admin parameter 2: true2017-03-22 13:56:03] at obfuscated.axH.a(SourceFile:1588) [2016-11-11 18:52:14] [ADMIN COMMAND] DESPAWN_ALL from RegisteredClient: SmilingTester (1) connected: true params: [Test, all, true]2017-03-22 13:56:03] at org.schema.game.server.controller.GameServerController.update(SourceFile:1021) [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [SUCCESS] ACTIVE DESPAWNED Ship[Test 2](193) to RegisteredClient: SmilingTester (1) connected: true7-03-22 13:56:03] at org.schema.schine.network.server.ServerController.run(SourceFile:275) [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [SUCCESS] ACTIVE DESPAWNED Ship[Test 1](192) to RegisteredClient: SmilingTester (1) connected: true7-03-22 13:56:03] at java.lang.Thread.run(Thread.java:745) [2016-11-11 18:52:14] [DESPAWN] using escaped matching string 'Test%'7-03-22 13:56:03] Caused by: org.hsqldb.HsqlException: unknown token: [2017-03-22 13:56:03] at org.hsqldb.error.Error.error(Unknown Source) [2016-11-11 18:52:14] [SQL] DESPAWNING: ENTITY_SHIP_Test 2 DELETE .ENT SUC false; RAW DATA FILES FOUND AND REMOVED: 02017-03-22 13:56:03] at org.hsqldb.error.Error.error(Unknown Source) [2016-11-11 18:52:14] java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERS7-03-22 13:56:03] at org.hsqldb.ParserBase.read(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlExceptParserDQL.readColumnOrFunctionExpression(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCUtil.sqlExceptionParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.fetchResultParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.jdbc.JDBCStatement.executeUpdateParserDQL.XreadAllTypesPrimary(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.schema.game.common.controller.database.DatabaseIndex.a(hsqldb.ParserDQL.XreadAllTypesFactor(Unknown SourceFile:2942e) [2016-11-11 18:52:142017-03-22 13:56:03] at obfuscated.auX.o(SourceFile:1156rg.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at obfuscated.auX.a(SourceFile:1565rg.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.schema.game.server.controller.GameServerController.update(hsqldb.ParserDQL.XreadRowOrCommonValueExpression(Unknown SourceFile:1018e) [2016-11-11 18:52:142017-03-22 13:56:03] at org.schema.schine.network.server.ServerController.run(hsqldb.ParserDQL.XreadRowValuePredicand(Unknown SourceFile:273e) [2016-11-11 18:52:142017-03-22 13:56:03] at java.lang.Thorg.hsqldb.ParserDQL.Xread.runPredicateRightPart(Unknown Source) [2016-11-11 18:52:14] Caused by:2017-03-22 13:56:03] at org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; EFKC table: FLEET_MEMBERSParserDQL.XreadBooleanPrimaryOrNull(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.error.Error.errorParserDQL.XreadBooleanTestOrNull(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.StatementDML.performReferentialActionsParserDQL.XreadBooleanFactorOrNull(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.StatementDML.deleteParserDQL.XreadBooleanTermOrNull(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.StatementDML.executeDeleteStatementParserDQL.XreadBooleanValueExpression(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.StatementParserDML.getResultXreadAndResolveBooleanValueExpression(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.StatementDMQL.executeParserDML.compileDeleteStatement(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.Session.executeCParserCommand.compiledStatemenPart(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.Session.executeDirectParserCommand.compileStatements(Unknown Source) [2016-11-11 18:52:142017-03-22 13:56:03] at org.hsqldb.Session.executeDirectStatement(Unknown Source) [2016-11-11 18:52:14] ... 8 more2017-03-22 13:56:03] at org.hsqldb.Session.execute(Unknown Source) [2016-11-11 18:52:14] [SEND][SERVERMESSAGE] [ADMIN COMMAND] [ERROR] SQL EXCEPTION to RegisteredClient: SmilingTester (1) connected: tru7-03-22 13:56:03] ... 8 more ```