Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
 Posted: Wed Feb 02, 2005 12:23 Post subject: Problem viewing SQLite database |
 |
|
Im trying to use the SQLiteCC to view the database that NWNX has created, however it seems to crash SQLiteCC every time though NWNX has no problems with the database.
Here is a typical log from the ODBC plug in, this is the only data that is in the database:
| Code: | NWNX ODBC2 plugin V.0.9.2.3
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using SQLite connection.
o Hooking SCO....hooked at 5c4320
o Hooking RCO....hooked at 5c4200
o Connect successful.
o Got request: SELECT areaid FROM grid WHERE xaxis = 500 AND yaxis = 500 AND zaxis = 500 AND aaxis = 500 AND baxis = 500 AND caxis = 500
o Sent response (3 bytes): 998
o Got request: CREATE TABLE grid (areaid varchar(255),xaxis varchar(255),yaxis varchar(255),zaxis varchar(255),aaxis varchar(255),baxis varchar(255),caxis varchar(255))
! SQL Error: SQL error: table grid already exists
o Got request: CREATE TABLE arealists (areaid varchar(255),n varchar(255),s varchar(255),e varchar(255),w varchar(255),u varchar(255),d varchar(255),ap varchar(255),an varchar(255),bp varchar(255),bn varchar(255),cp varchar(255),cn varchar(255))
! SQL Error: SQL error: table arealists already exists
o Got request: INSERT INTO arealists VALUES (1, 0003, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (2, 0000, 0000, 0000, 0001, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (3, 0000, 0000, 0001, 0001, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (4, 0003, 0000, 0000, 0001, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (5, 0000, 0000, 0000, 0003, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (6, 0003, 0000, 0000, 0003, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
...snip.....
o Got request: INSERT INTO arealists VALUES (945, 0005, 0013, 0013, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: INSERT INTO arealists VALUES (946, 0005, 0013, 0013, 0011, 0000, 0099, 0000, 0000, 0000, 0000, 0000, 0000)
o Got request: SELECT areaid FROM grid WHERE xaxis = 500 AND yaxis = 500 AND zaxis = 499 AND aaxis = 500 AND baxis = 500 AND caxis = 500
o Sent response (0 bytes):
o Got request: SELECT areaid FROM grid WHERE xaxis = 500 AND yaxis = 500 AND zaxis = 499 AND aaxis = 500 AND baxis = 500 AND caxis = 500
o Sent response (0 bytes):
o Disconnecting from database.
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
