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 
 
I get this error on a recall type stone

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Drakken



Joined: 09 Jan 2005
Posts: 2

PostPosted: Sun Jan 09, 2005 9:59    Post subject: I get this error on a recall type stone Reply with quote

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
View user's profile Send private message
Manuel



Joined: 30 Dec 2004
Posts: 51

PostPosted: Sun Jan 09, 2005 10:52    Post subject: Reply with quote

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
View user's profile Send private message
Rat Bastard!!!



Joined: 10 Jan 2005
Posts: 11

PostPosted: Mon Jan 10, 2005 4:19    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website AIM Address
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Tue Jan 11, 2005 10:58    Post subject: Reply with quote

Both statements are equivalent and work with MySQL.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related 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