| View previous topic :: View next topic |
| Author |
Message |
Trimme
Joined: 05 Nov 2005
Posts: 11
|
 Posted: Sat Jan 28, 2006 23:21 Post subject: Strange Problem |
 |
|
My server has starting to crash from time to time, and in one of my logs i get this error.
Just wanna say im running on internal database the normal sqlite
| Code: |
NWN Extender V.2.6.1
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
* Loading plugins...
* Plugin deletechar is loaded.
* Plugin leto is loaded.
* NWNX2 activated.
* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* Library ODBC!EXEC does not exist.* NWNX2 shutting down...
* NWNX2 shutdown successfull.
|
Im not using ODBC 
Thanks in advance
Trimme |
|
| Back to top |
|
 |
Trimme
Joined: 05 Nov 2005
Posts: 11
|
| Posted: Sun Jan 29, 2006 15:06 Post subject: |
|
|
And if i put in the odbc2 it looks like this, but just to stress it i have connemted sqlite local database
| Code: |
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 5c65d0
o Hooking RCO....hooked at 5c64b0
o Connect successful.
o Got request: SELECT val FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('wakka13','Elimea','ControlClass','33',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('wakka13','Elimea','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('wakka13','Elimea','ControlClass','33',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='wakka13' AND tag='Elimea' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('wakka13','Elimea','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','ControlClass','4',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='isisgodess1' AND tag='snowflake Menson' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('isisgodess1','snowflake Menson','PointsAvailable','0',0)
! SQL Error: no such table: pwdata
o Disconnecting from database.
|
here is my nwnx file
| Code: |
[NWNX]
ServerPort = 5121
ModuleName = "EXTREME_LOTR"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = yes
RestartDelay = 10
ServerVault = C:/NeverwinterNights/NWN/servervault/
[DELETECHAR]
LogLevel = 1 ; 0=nothing, 1=write a log
DeleteOrMove = 0 ; 0=move file out of player dir, 1=delete file
MoveToPath = C:/NeverwinterNights/NWN/deletevault/ ; this directory needs to already exist
[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything
; Use these two settings for the SQLite internal database
source = sqlite
file = sqlite.db
; Use these two settings for ODBC connections
;source = odbc
;dsn = nwn
; Use these five settings for MySQL connections
;source = mysql
;server = localhost
;user = nwn
;pwd = nwn
;db = nwn
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack
|
hope somebody can tell me whats wrong
Regards
Trimme |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Sun Jan 29, 2006 19:09 Post subject: |
|
|
First, does the sqlite.db file exist?
Second, did you run the demo module to create the pwdata table in the sqlite.db database file? |
|
| Back to top |
|
|
Trimme
Joined: 05 Nov 2005
Posts: 11
|
| Posted: Sun Jan 29, 2006 22:07 Post subject: |
|
|
well now i just made a table in the database folder in nwn
it seems to have solved the problem. but now some of them gets this error...
| Code: |
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using SQLite connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
o Connect successful.
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Gothboi','Adept of the Silent Blade','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Gothboi','Adept of the Silent Blade','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Gothboi','Adept of the Silent Blade','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Gothboi','Adept of the Silent Blade','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Gothboi' AND tag='Adept of the Silent Blade' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Gothboi','Adept of the Silent Blade','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='gimmile' AND tag='†§øul†' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='gimmile' AND tag='†§øul†' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('gimmile','†§øul†','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='gimmile' AND tag='†§øul†' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='gimmile' AND tag='†§øul†' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('gimmile','†§øul†','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='xkorbx' AND tag='Lestat Drakul' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='xkorbx' AND tag='Lestat Drakul' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('xkorbx','Lestat Drakul','ControlClass','33',0)
o Got request: SELECT val FROM pwdata WHERE player='xkorbx' AND tag='Lestat Drakul' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='xkorbx' AND tag='Lestat Drakul' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('xkorbx','Lestat Drakul','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Final IX' AND tag=' ».†Lørd Ðéémš†.«' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Final IX' AND tag=' ».†Lørd Ðéémš†.«' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Final IX',' ».†Lørd Ðéémš†.«','ControlClass','9',0)
o Got request: SELECT val FROM pwdata WHERE player='Final IX' AND tag=' ».†Lørd Ðéémš†.«' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Final IX' AND tag=' ».†Lørd Ðéémš†.«' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Final IX',' ».†Lørd Ðéémš†.«','PointsAvailable','1',0)
|
|
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Mon Jan 30, 2006 2:28 Post subject: |
|
|
You are confusing how the NWN database and the NWNX databases work and the differences between them....
The SQLITE.DB does NOT go in the "database" folder, it belongs in the root of the NWN directory. You cannot just "make" a table, you have to used the SQlite utilities to create the table with the proper parameters as the data going into it.
If you are not experienced in databases I would highly recommend follow the directions to the letter, including running the demo module that creates the table for you.
You can also download a functional SQLite database from here:
http://nurrana.radcon.org/Downloads/sqlite.zip
Extract the contents into your NWN directory. Do NOT put it in the "database" folder..... |
|
| Back to top |
|
|
Trimme
Joined: 05 Nov 2005
Posts: 11
|
| Posted: Mon Feb 06, 2006 16:00 Post subject: |
|
|
I thank you for your help, but i still got this in mu obdc2 log
| Code: |
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 5c65d0
o Hooking RCO....hooked at 5c64b0
o Connect successful.
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','ControlClass','9',0)
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Final IX' AND tag=' »†Lðrd Ðééms†« ' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Final IX' AND tag=' »†Lðrd Ðééms†« ' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Final IX',' »†Lðrd Ðééms†« ','ControlClass','9',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Final IX' AND tag=' »†Lðrd Ðééms†« ' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Final IX' AND tag=' »†Lðrd Ðééms†« ' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Final IX',' »†Lðrd Ðééms†« ','PointsAvailable','3',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤','ControlClass','7',0)
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤','ControlClass','7',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤','ControlClass','7',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','¤=¤Nicho¤=¤{(MKD)}=¤General¤#2¤','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Messiah of Hades' AND tag='Clitorus' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Messiah of Hades' AND tag='Clitorus' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Messiah of Hades','Clitorus','ControlClass','29',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Messiah of Hades' AND tag='Clitorus' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Messiah of Hades' AND tag='Clitorus' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Messiah of Hades','Clitorus','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Fyrebane' AND tag='Al Bundy' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Fyrebane' AND tag='Al Bundy' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Fyrebane','Al Bundy','ControlClass','29',0)
o Got request: SELECT val FROM pwdata WHERE player='Fyrebane' AND tag='Al Bundy' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Fyrebane' AND tag='Al Bundy' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Fyrebane','Al Bundy','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','ControlClass','9',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='=‡=Nicho=({MKD})=General=#2=‡=' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='=‡=Nicho=({MKD})=General=#2=‡=' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','=‡=Nicho=({MKD})=General=#2=‡=','ControlClass','33',0)
o Got request: SELECT val FROM pwdata WHERE player='SexyPerson' AND tag='=‡=Nicho=({MKD})=General=#2=‡=' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('0_RaVeN_0','Emily the Strange','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='SexyPerson' AND tag='=‡=Nicho=({MKD})=General=#2=‡=' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('SexyPerson','=‡=Nicho=({MKD})=General=#2=‡=','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('0_RaVeN_0','Emily the Strange','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('0_RaVeN_0','Emily the Strange','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('0_RaVeN_0','Emily the Strange','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='0_RaVeN_0' AND tag='Emily the Strange' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('0_RaVeN_0','Emily the Strange','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='mine73' AND tag='Elvithrar Wefnesifer' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='mine73' AND tag='Elvithrar Wefnesifer' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('mine73','Elvithrar Wefnesifer','ControlClass','29',0)
o Got request: SELECT val FROM pwdata WHERE player='mine73' AND tag='Elvithrar Wefnesifer' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='mine73' AND tag='Elvithrar Wefnesifer' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('mine73','Elvithrar Wefnesifer','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','ControlClass','9',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Xen_Cobra' AND tag='Xen The Sorc' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Xen_Cobra','Xen The Sorc','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','ControlClass','33',0)
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','ControlClass','33',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Bobfred21' AND tag='MooCow' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Bobfred21','MooCow','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Samyx','Slortar','ControlClass','10',0)
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Samyx','Slortar','PointsAvailable','0',0)
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Samyx','Slortar','ControlClass','10',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='PointsAvailable'
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: SELECT player FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='ControlClass'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Samyx','Slortar','ControlClass','10',0)
! SQL Error: columns player, tag, name are not unique
o Got request: SELECT val FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='PointsAvailable'
o Got request: SELECT player FROM pwdata WHERE player='Samyx' AND tag='Slortar' AND name='PointsAvailable'
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Samyx','Slortar','PointsAvailable','0',0)
! SQL Error: columns player, tag, name are not unique
o Disconnecting from database.
|
And why is it running OBDC when its uncommented
| Code: |
[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything
; Use these two settings for the SQLite internal database
source = sqlite
file = sqlite.db
; Use these two settings for ODBC connections
;source = odbc
;dsn = nwn
; Use these five settings for MySQL connections
;source = mysql
;server = localhost
;user = nwn
;pwd = nwn
;db = nwn
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack
|
Is it because hookscorco is set to true..??
Hope anyone can help. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Mon Feb 06, 2006 21:28 Post subject: |
|
|
Do not confuse the ODBC plugin with the ODBC connection type. The latter is disabled in your NWNX.INI, the former is the plugin that offers database connectivity in general (including SQLite, mysql, odbc).
Is your pwdata table empty ? It looks like as if the data your script is trying to insert already exists in the table (and thus the warnings about unique columns).
_________________
Papillon |
|
| Back to top |
|
|
|
|
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
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
