V.1.0.9: SetPersistentObject() does not write into table

[DrGala]

Hello everybody, this is my first message.
First of all, thanks to the NWNX staff and community: great job.

Now to my problem: I've downloaded and installed V1.0.9, replacing the old one I was using.

I'm using MySQL database to store my info. My PW has been running from almost 2 years now, and we successfully used SLQ queries.

I was trying the SCO/RCO functions to enhance the permanent chests system we are using, but cannot manage to store data in the table.

I hope someone could give me an hint of what is going wrong.

1) the DB table exist (used the CREATE TABLE statement taken from the demo module)
2) connection with the DB is ok (other queries do work ok)
3) called

SetPersistentObject(
oPC, // owner of the object
sVarName, // var name associated to the stored object
oItem, // item to be stored
100, // days before expire
"l2_forzieri_permanenti"); // table name

but I get no rows into the table.

In xp_mysql.txt (log set to log everything) I can see the query performed by SetPersistentObject() to check if the row already exist:

* Executing: SELECT player FROM l2_forzieri_permanenti WHERE player='DrGala' AND tag='Cenere' AND name='Ogg0'
* SCO query:
* RCO query:

but I see no sign of the INSERT INTO that should have put data into the table.

I guess such command should have been performed by the hooked StoreCampaignObject()... but it seems like nothing happened.

Thanks a lot for your time.
_________________
Ladiun2 - Admin/Developer

[_Mordred_]

I have the same problem with the sql database. I posted it in the script section. Let me know if you find a solution