I don't know what I've done wrong...

[NoMercy]

I'm also expierencing problems with the object storage, objects seem to be saved out fine under SQLite but crash nwserver in a similar fassion to the original poster when trying to read them back.

Files generated, no change to default module:
DrWatson Dump
NWNX ODBC log

Upgraded to 0.9.2.1, and tested with MySQL, and it seems it can't connect anymore, "Client does not support authentication protocol requested by server" (then crashed when issueing the CREATE statement), hey ho :)

[Papillon]

MacLir, since I am not able to reproduce the crash on my computers, we will have to test several things to nail the problem down. I will create a special odbc2 module for you, which hooks sco/rco a bit differently, and we will see how that goes.
_________________
Papillon

[MacLir]

Sounds good to me. At this point, I'm willing to try anything.

[Papillon]

Try this one: http://nwnx.org/fileadmin/user_upload/nwnx_odbc.zip
_________________
Papillon

[Papillon]

And this one: http://nwnx.org/fileadmin/user_upload/nwnx_odbca.zip
_________________
Papillon

[Papillon]

Btw, please also test both methods in demo_obj_load, they work quite different internally.
_________________
Papillon

[MacLir]

Ok, testing done.

As an aside, I just wanted to point out that my testing has, from the start (3 days ago), been on the downloadable Stand-Alone Server. I placed it in the Neverwinter Nights directory as the 'Server' directory (full path is 'E:\Neverwinter Nights\Server\nwserver.exe').

I've also noticed that storage to MySQL 4.1.8 seems instantaneous, whereas SQLite lags a bit and increases as more items are stored.

Sorry, results:

Method 1 - 1st plugin

SQLite

3 items - 4 retrieve calls - Success


5 items - 5 retrieve calls - Failure


6 items - 3 retrieve calls - Failure

MySQL

3 items - 2 retrieve calls - Failure


5 items - 2 retrieve calls - Failure


6 items - 2 retrieve calls - Failure

Method 2 - 1st plugin

SQLite

3 items - 1 retrieve call* - Failure


5 items - 1 retrieve call* - Failure


6 items - 1 retrieve call* - Failure

MySQL

3 items - 1 retrieve call* - Failure


5 items - 1 retrieve call* - Failure


6 items - 1 retrieve call* - Failure

Method 1 - 2nd plugin

SQLite

3 items - 2 retrieve calls - Failure


5 items - 3 retrieve calls - Failure


6 items - 2 retrieve calls - Failure

MySQL

3 items - 2 retrieve calls - Failure


5 items - 2 retrieve calls - Failure


6 items - 3 retrieve calls - Failure

Method 2 - 2nd plugin

SQLite

3 items - 1 retrieve call* - Failure


5 items - 1 retrieve call* - Failure


6 items - 1 retrieve call* - Failure

MySQL

3 items - 1 retrieve call* - Failure


5 items - 1 retrieve call* - Failure


6 items - 1 retrieve call* - Failure

* - Indicates that the retrieve call never finished in full, it was always a 'partial' retrieve call.
Success - retrieval worked with no crash.
Failure - server crashed.

At least we're getting somewhere, one success is better than none.

[Papillon]

Can someone who experiences these crashes give me remote desktop access to one of his machines ? I'd like to step through this with OllyDbg (my debugger of choice). Please PM if possible.
_________________
Papillon

[MacLir]

Grr... If I had access to configure the router I'm behind, I'd be more than happy to... As it stands, I can't even host for friends; unless we do a seperate LAN, in which case internet access is gone as I only have one NIC...

[MacLir]

Well on a positive note, it works now... But I have just 'upgraded' to WinXP Home.

At least now I can play with some ideas I have...