View previous topic :: View next topic |
Author |
Message |
Drakken
Joined: 09 Jan 2005 Posts: 2
|
Posted: Sun Jan 09, 2005 9:59 Post subject: I get this error on a recall type stone |
|
|
What could be wrong here? I looked in the "nwn" DB, and there is no table named pwdata, but the nwnxLeto tables are all there and working fine.
o Connect successfull.
o Got request: SELECT player FROM pwdata WHERE player='Drakken_Raed' AND tag='Silvadir Goldleaf' AND name='Return_Orb'
! SQL Error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'pwdata'. Make sure it exists and that its name is spelled correctly.
o Sent response (-1 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Drakken_Raed','Silvadir Goldleaf','Return_Orb','#AREA#FountainofLife#POSITION_X# 37.712409973#POSITION_Y# 36.898441315#POSITION_Z# 0.000000000#ORIENTATION# 294.019714355#END#',0) |
|
Back to top |
|
|
Manuel
Joined: 30 Dec 2004 Posts: 51
|
Posted: Sun Jan 09, 2005 10:52 Post subject: |
|
|
I believe the test module that is distributed with NWNX creates this table for you. Or you could create it yourself.
Code: |
USE nwn;
CREATE TABLE pwdata (
player varchar(64) default '',
tag varchar(64) default '',
name varchar(64) default '',
val text,
expire int(11) default '0',
last timestamp(14) NOT NULL,
KEY idx (player,tag,name)
) TYPE=MyISAM;
|
|
|
Back to top |
|
|
Rat Bastard!!!
Joined: 10 Jan 2005 Posts: 11
|
Posted: Mon Jan 10, 2005 4:19 Post subject: |
|
|
Or, if you use MySQL it would be:
Code: | CREATE TABLE `pwdata` (
`player` varchar(64) default '',
`tag` varchar(64) default '',
`name` varchar(64) default '',
`val` text,
`expire` int(11) default '0',
`last` timestamp(14) NOT NULL,
KEY `idx` (`player`,`tag`,`name`)
) TYPE=MyISAM;
|
Slightly different, but bascially the same. |
|
Back to top |
|
|
Papillon x-man
Joined: 28 Dec 2004 Posts: 1060 Location: Germany
|
Posted: Tue Jan 11, 2005 10:58 Post subject: |
|
|
Both statements are equivalent and work with MySQL. _________________ 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
|