| View previous topic :: View next topic |
| Author |
Message |
Script Wrecked
Joined: 15 Apr 2012
Posts: 4
|
 Posted: Sun Apr 15, 2012 9:38 Post subject: SQL Causes Server Crash |
 |
|
NWNX2/SQLite/Windows XP SP3
Any suggestions why the following SQL causes NWNX_ODBC.DLL to crash (causing NWN Server to crash):
| Quote: | | SELECT dummy FROM dual |
Table definition:
| Quote: | | CREATE TABLE dual ( dummy text not null ) |
No rows in the table.
Regards,
Script Wrecked. |
|
| Back to top |
|
 |
Script Wrecked
Joined: 15 Apr 2012
Posts: 4
|
| Posted: Mon Apr 16, 2012 7:54 Post subject: |
|
|
I noticed that the database file had grown to 100MiB, even though the database only had one table with no data. I deleted the database file and rebuilt the database from the SQL. It all seems to be working now.
No idea what caused the initial "corruption". |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
