Unused skill points lost. ! SQL Error: No such table: pwdata

[Kato]

Hi,

I'm having a problem with skill points not carrying over when taking LLs. All the other modifications are made correctly, though. Any help would be greatly appreciated.

My nwnx_odbc.txt:

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: SELECT val FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Kato_Yang','§ Kato §','ControlClass','5',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Kato_Yang','§ Kato §','PointsAvailable','3',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='ControlClass'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Kato_Yang','§ Kato §','ControlClass','5',0)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='Kato_Yang' AND tag='§ Kato §' AND name='PointsAvailable'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Disconnecting from database.


Many thanks in advance!

[drake127]

Your server tries to tell you that you are missing table pwdata. You need to create it first (command should be in documentation of ODBC).

[Kato]

[Fireboar]

Probably a different version of SQLite. You should run SQLExecDirect to execute the database queries to create the table as documented. Or you could run the aps_demo module to create it automatically. Make sure you delete the current .db file though, otherwise it will fail.

[Kato]