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 
 
not writing to the database

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



Joined: 16 Dec 2013
Posts: 9

PostPosted: Mon Dec 16, 2013 3:56    Post subject: not writing to the database Reply with quote

The database stays at 0 bytes.
According to the sample module it can delete and create the table but isn't retrieving the string, just returns "......" and database stays at 0 bytes.

It's running on an xp machine.

Also there were a lot of files in the download that were not mentioned at all in the install instructions. Was I supposed to do something with them?

Is my ODBC just not set up right for sqlite? I don't know anything about ODBC!


Last edited by slappy on Mon Dec 16, 2013 13:48; edited 1 time in total
Back to top
View user's profile Send private message
Lokey



Joined: 02 Jan 2005
Posts: 158

PostPosted: Mon Dec 16, 2013 13:23    Post subject: Reply with quote

There'll be some dlls needed out of what you downloaded (nwnx2.exe, its dlls and the odbc plugin and that's all covered somewhere here.) The important thing is setting the nwnx2.ini stuff under the sqlite section...but I haven't used that and not sure what non-obvious things need to be done there before figuring out if it's something on your system (it probably assumes you have the service packs at least).
_________________
Neversummer PW NWNx powered mayhem Wink
Back to top
View user's profile Send private message
slappy



Joined: 16 Dec 2013
Posts: 9

PostPosted: Mon Dec 16, 2013 13:49    Post subject: Reply with quote

Thanks for reply. I do have nwnx2 running fine to restart the server. It is only the odbc plugin I recently added that's not working.
Back to top
View user's profile Send private message
slappy



Joined: 16 Dec 2013
Posts: 9

PostPosted: Mon Dec 16, 2013 23:57    Post subject: Reply with quote

to be clear about what I said earlier, the ODBC instructions say drop a .dll in your nwn folder and import an erf.

The package however, comes with waaaaaaaay more files than that. (specifically, in the src folder)

Am I supposed to be doing something with those?
Back to top
View user's profile Send private message
Lokey



Joined: 02 Jan 2005
Posts: 158

PostPosted: Tue Dec 17, 2013 1:18    Post subject: Reply with quote

It's the source files. If you're not going to compile or change yourself, you can ignore.

You will still need to change the ini file, and possibly recompile scripts in your module (and adjust the scripting, make sure the example module works first).
_________________
Neversummer PW NWNx powered mayhem Wink
Back to top
View user's profile Send private message
slappy



Joined: 16 Dec 2013
Posts: 9

PostPosted: Tue Dec 17, 2013 1:55    Post subject: Reply with quote

Scripts compile, includes are included, I start the server using nwnx, ini looks like everyone else's posted, sample mod still gives me".........." return string, and .db stays 0bytes...

I read somewhere a guy didn't have the right version of sqlite installed on his computer. Could that be it?
Back to top
View user's profile Send private message
slappy



Joined: 16 Dec 2013
Posts: 9

PostPosted: Tue Dec 17, 2013 3:36    Post subject: Reply with quote

Oh I didn't have sqlite at all.

This is what I was missing: http://www.tutorialspoint.com/sqlite/sqlite_installation.htm

Sorry, I don't know anything about sqlite. the only thing it said about it in the docs that I saw was that it was packaged with nwnx2 and "automatic".

Whoops!

Works now.
Back to top
View user's profile Send private message
sandronejm



Joined: 02 Jan 2014
Posts: 15

PostPosted: Thu Jan 02, 2014 22:52    Post subject: slappy Reply with quote

I want to make my nwn module be a persistent world. Could anybody help me?

I have dedicaded server, nwnx2, mysql and the module. I configure nwnx.ini correctly

; Use these five settings for MySQL connections
source = mysql
server = localhost
user = nwn
pwd = 123456789
db = nwn

but DATABASE don't receive nothing. Is 0 bytes.

for SQLites connections,

I tried to install the sqlite by your link, but i don't understend this part:

* Add C:\>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3 command, which should display a result something as below.

C:\>sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

Please, help me anybody.
Back to top
View user's profile Send private message Send e-mail
sandronejm



Joined: 02 Jan 2014
Posts: 15

PostPosted: Thu Jan 02, 2014 22:54    Post subject: slappy Reply with quote

slappy,

How you make this work?

Can you teach me?
Back to top
View user's profile Send private message Send e-mail
sandronejm



Joined: 02 Jan 2014
Posts: 15

PostPosted: Thu Jan 02, 2014 23:00    Post subject: Slappy Reply with quote

slappy wrote:
Oh I didn't have sqlite at all.

This is what I was missing: http://www.tutorialspoint.com/sqlite/sqlite_installation.htm

Sorry, I don't know anything about sqlite. the only thing it said about it in the docs that I saw was that it was packaged with nwnx2 and "automatic".

Whoops!

Works now.


Thank you, i will be waiting to you.
Back to top
View user's profile Send private message Send e-mail
sandronejm



Joined: 02 Jan 2014
Posts: 15

PostPosted: Mon Jan 06, 2014 1:01    Post subject: Works Reply with quote

I have reinstalled all step by step and it works. Thank you
Back to top
View user's profile Send private message Send e-mail
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