XP 64-bit

[silentcricket]

I currently have 2 servers: 32 & 64 bit. All development has been done on the 32 bit. Now I want to run the PW on the 64 bit but having some issues on inserting into the DB.

Should the 32 bit baked mod work on the 64 bit?

Do I have to bake the mod on the 64 bit to run on 64 bit?

Both servers have the same version of NWNX4 and MySQL. Both server have their own database but with identical data and structure. But mod runs on 32 bit only.

Issue: upon creation of new PC I get the error message below in the xp_mysql.txt file:
! SQL Error: Field 'PCID' doesn't have a default value (1364).

The PCID field is auto-incrementing, it shouldn't need a default value.

Any suggestions would be appreciated. Thanks,

SilentCricket

[silentcricket]

Well, I figured out my own problem. Come to find out the PCID field was not set to auto-incrementing as I had thought. All this happened because I used a DB user without all permissions to perform a backup and restore from prod to dev db server. This doesn't work well at all. You must be root or a user with ALL permissions. DUH!