Problem Creating Table

[Massocre]

Hi:

I run a PW that I wanna add persistance too using NWNx2 and MySQL. I decided to add a "player owned housing system" by f0wl Cr0w, which creates tables as players buy the houses. When testing, the nwnx2_odbc log gave me this error:

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: 524288 bytes
o Log level: Everything will be logged.
o Using MySQL connection.
o Hooking SCO....hooked at 5c4320
o Hooking RCO....hooked at 5c4200
o Connect successful.
o Got request: SELECT ResRef FROM hearthdaleplayerhousing WHERE FurnID='00000'
! SQL Error: Table 'nwn.hearthdaleplayerhousing' doesn't exist
o Got request: SELECT Facing FROM hearthdaleplayerhousing WHERE FurnID='00000'
! SQL Error: Table 'nwn.hearthdaleplayerhousing' doesn't exist
o Got request: SELECT ResRef FROM shack_a1 WHERE FurnID='00000'
o Got request: UPDATE hearthdaleplayerhousing SET Facing='' WHERE FurnID='00000'
! SQL Error: Table 'nwn.hearthdaleplayerhousing' doesn't exist
o Disconnecting from database.

Can someone possibly help me out with understanding what is wrong?

[JeroenB]

It seems that your table is not yet been made. I assume you know what the SELECT statement does, it wants to fetch data from a table that does not exist. So, you must first create the table in your nwn database.

[Massocre]

Well, the idea is that the tables make themselves from the mod. When i went to MySQL control panel, I saw the new table it made (called shack_a1) but no info was stored....

If I have to make the table manually, what one to make? "hearthdaleplayerhousing"? How do I do that exactly? I can do fair scripting, but this DB stuff is very new.

[JeroenB]

As far as I can tell, the shack_a1 table was not the one you were refering to in the first post (hearthdaleplayerhousing). Also, SQL doesn't create tables on itself. You must create a statement like: