logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Database not showing while server running??

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support
View previous topic :: View next topic  
Author Message
CelticLord



Joined: 10 Nov 2012
Posts: 3

PostPosted: Sat Nov 10, 2012 16:58    Post subject: Database not showing while server running?? Reply with quote

I'm using SQLite and when I leave to the game with my PC it shows [nwnx_odbc] the database and info was created and written.
The problem is I don't see the databse with sqlitecc unless i shut down the server.

ODBC...............
NWNX ODBC2 plugin V.0.9.2.4
(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 5d5830
o Hooking RCO....hooked at 5d5710
o Connect successful.
o Got request: DROP TABLE KiealalThor
! SQL Error: no such table: KiealalThor
o Got request: CREATE TABLE KiealalThor (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val blob,expire int(11) NOT NULL default '0',last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name))
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='NW_IT_GEM003'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','NW_IT_GEM003','Item_0',0)
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='NW_IT_GEM004'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','NW_IT_GEM004','Item_1',0)
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='NW_IT_MEDKIT001'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','NW_IT_MEDKIT001','Item_2',0)
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='NW_IT_GEM014'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','NW_IT_GEM014','Item_3',0)
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='X1_WMGRENADE001'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','X1_WMGRENADE001','Item_4',0)
o Got request: SELECT player FROM KiealalThor WHERE player='~' AND tag='' AND name='NW_IT_MPOTION003'
o Got request: INSERT INTO KiealalThor (player,tag,name,val,expire) VALUES('~','','NW_IT_MPOTION003','Item_5',0)
Back to top
View user's profile Send private message
luna



Joined: 20 Jan 2012
Posts: 28

PostPosted: Mon Dec 10, 2012 23:39    Post subject: Reply with quote

Try a different program perhaps.
One of the ones we use is SQLyog which works fine.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group