NWNX Unable to read from MySQL db (but can write)

[FireWraith]

So I had a server hard drive die on me last night, and had to bring up a new server. Luckily all the backups were fine of the NWN stuff, but I had to reinstall MySQL. The files I had for 5.0, which we'd been using, refused to install, so I went and pulled down the latest version (5.7). Everything seems to be set up correctly, and NWNX reports that it's hooked properly and all, so far as I can tell.

The only problem is, NWN is unable to read anything from the databases, and keeps returning 0/etc, even though it can clearly write to the databases. I even tested this by clearing one of the tables completely - sure enough, more data gets entered correctly, but NWN still keeps returning '0' anytime a script executes a database variable check, even for ones that I can see (using SELECT in the MySQL command line) exist.

Any ideas? Did 5.7 change something so that it breaks the syntax for read commands in aps_include?

[Baaleos]

Can you post some scripts and logs?
Eg:
nwnx_odbc.txt - with debug mode set to 3 or higher.

Also - are you sure your db user has read access?

[FireWraith]

Should have all permissions. I went ahead and granted them all again, and SELECT specifically just to be sure.

When running a script that should tell me how much xp the character has earned today gives a value of '0' and no errors in the ODBC log, even though I can see. specifically, but it hasn't changed anything.

Running the logs, I don't see any errors when I run a script that should read from the database. This is what it gives me:


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: 1048576 bytes
o Log level: Everything will be logged.
o Using MySQL 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='PLAYERNAME' AND tag='CHARACTERNAME' AND name='Wounded'
o Sent response (0 bytes):
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='' AND name='aet_storedItem199'
o Got request: SELECT val FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='Alter_Self_Effect'
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='CurrentHP'
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('PLAYERNAME','CHARACTERNAME','CurrentHP','150',0)
o Got request: SELECT player FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='Wounded'
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('PLAYERNAME','CHARACTERNAME','Wounded','0',0)
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='X3_ELFMOUNT001' AND name='Alter_Self_Effect'
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='Alter_Self_Effect'
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='CurrentHP'
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('PLAYERNAME','CHARACTERNAME','CurrentHP','150',0)
o Got request: SELECT player FROM pwdata WHERE player='PLAYERNAME' AND tag='CHARACTERNAME' AND name='Wounded'
o Sent response (0 bytes):

[FireWraith]

I used the x64 version of MySQL 5.7, too - that's about the only other thing I can think of at this point that might be doing it. I'm going to try uninstalling and switching to the 32 bit version.

[FireWraith]

Update - reverting to the x86 version of MySQL appears to have fixed the problem.

[Terra_777]

It just looks like you never ran SQLInit() in mod load first, without doing that you don't get the exchange buffers nwnx_odbc uses to retrieve data.
_________________
I dun have any signature, I'm happy anyway.