UOX3 Freezes Clients + Spams Console /wSQL info After Save
Posted: Wed Jan 14, 2009 10:27 pm
UOX3 Verison: v.0.98-37.u
When running the above version of UOX3, starting with an empty world (no save files), and running on a custom map0.mul (same size, etc as original), the saves timer kicks in at the default 300 interval (although I've edited the ini a few times to take the interval down to 0 and it seems to reset the ini sometimes...), and immediately following the world save, all clients freeze, while the console gets spammed with (along with a very full warning log file):
[January 14 04:25:22 PM] INSERT INTO Account( AccountID, Username, Password, ContactDetails, IsBanned, IsSuspended, IsPublic, IsOnline, IsSeer, IsCounselor, IsGM, LastUpdated ) VALUES( 0, 'admin', 'admin', 'unknown', 0, 0, 0, 0, 0, 0, 1, getdate()
[January 14 04:25:22 PM] INSERT INTO Account( AccountID, Username, Password, ContactDetails, IsBanned, IsSuspended, IsPublic, IsOnline, IsSeer, IsCounselor, IsGM, LastUpdated ) VALUES( 1, 'guest1', 'guest1', 'unknown', 0, 0, 0, 0, 0, 0, 0, getdate()
[January 14 04:25:22 PM] ODBC: SQLState : HÎÂ8C
[January 14 04:25:22 PM] ODBC: NativeError: 7
[January 14 04:25:22 PM] ODBC: Msg :
[January 14 04:25:22 PM] ODBC: SQLState : HÎÂ8C
[January 14 04:25:22 PM] ODBC: NativeError: 7
and basically the ODBC error just repeats forever until the console is killed.
When running the above version of UOX3, starting with an empty world (no save files), and running on a custom map0.mul (same size, etc as original), the saves timer kicks in at the default 300 interval (although I've edited the ini a few times to take the interval down to 0 and it seems to reset the ini sometimes...), and immediately following the world save, all clients freeze, while the console gets spammed with (along with a very full warning log file):
[January 14 04:25:22 PM] INSERT INTO Account( AccountID, Username, Password, ContactDetails, IsBanned, IsSuspended, IsPublic, IsOnline, IsSeer, IsCounselor, IsGM, LastUpdated ) VALUES( 0, 'admin', 'admin', 'unknown', 0, 0, 0, 0, 0, 0, 1, getdate()
[January 14 04:25:22 PM] INSERT INTO Account( AccountID, Username, Password, ContactDetails, IsBanned, IsSuspended, IsPublic, IsOnline, IsSeer, IsCounselor, IsGM, LastUpdated ) VALUES( 1, 'guest1', 'guest1', 'unknown', 0, 0, 0, 0, 0, 0, 0, getdate()
[January 14 04:25:22 PM] ODBC: SQLState : HÎÂ8C
[January 14 04:25:22 PM] ODBC: NativeError: 7
[January 14 04:25:22 PM] ODBC: Msg :
[January 14 04:25:22 PM] ODBC: SQLState : HÎÂ8C
[January 14 04:25:22 PM] ODBC: NativeError: 7
and basically the ODBC error just repeats forever until the console is killed.