PW Data not saved

[The Moofia]

My wife and I run a PW and our quest data is not being saved , and players have experienced that they are able to do the same quests after each server restart . The logs read no pwdata ??

Any help would be great as our usual tech guys is unavailable ( NWN2 ))

[Frang]

You dont have the pwdata table in your mysql atabase. you can get the aps_demo mod from the vault and launch it via the nwnx.exe log into the mod and pull a lever and create the table.

[odenien]

Off hand, I would say your query to update the pw table is failing. Without a log, probably near impossible to determine why.

[The Moofia]

OK... perhaps I should explain a bit more... we have inherited this server and do not know much about what was going on ( except from a DM/Player standpoint ) So I have a few questions... Does it matter which version of MySQL I decide to download and use? Will different versions run the already written quests and tracking the same way? Which version is the easiest on system resources? Which is the most user friendly?

Will my system specs come in handy?

HP Pavilion Media Center TV m7640n - Athlon 64 X2 5000+ 2.6 GHz

* Full specifications
* See manufacturer info
* See similar products
* Compare with most popular Desktops

CNET full specifications
HP Pavilion Media Center TV m7640n - Athlon 64 X2 5000+ 2.6 GHz
Processor
Processor manufacturer AMD
Processor type Athlon 64 X2
Clock speed 2.6 GHz
Installed processor qty 1
Max supported processor qty 1
RAM
RAM installed 2 GB
Memory specification compliance PC2-4200
Memory speed 533 MHz
RAM form factor DIMM 240-pin
RAM technology DDR II SDRAM
System
Windows Vista certification Windows Vista Premium Ready
Recommended use Home use
System type Media center
Video Output
TV tuner type Analog TV
Video output form factor Integrated
Display (Projector)
Display type None.
Service & Support
Service & Support type 1 year warranty
Optical Storage
CD / DVD read speed 40x (CD) / 16x (DVD)
CD / DVD rewrite speed 32x (CD) / 6x (DVD-RW) / 8x (DVD+RW) / 5x (DVD-RAM)
CD / DVD write speed 40x (CD) / 16x (DVD±R) / 4x (DVD-R DL) / 8x (DVD+R DL)
Optical storage interface type IDE
Storage Hard Drive
Hard drive interface Serial ATA-300
Hard drive installed qty 1
Hard drive size 320 GB
Hard drive type Standard
Spindle speed 7200 rpm
Audio Input
Audio input type None
Interface Provided
Interface 1 Mouse Generic, 1 Keyboard Generic, 1 Display / video VGA, 1 Display / video S-video output, 1 Display / video Ethernet 10Base-T/100Base-TX, 2 Hi-Speed USB Output, 2 IEEE 1394 (FireWire) Input, 1 Network Input, 1 Audio Line-in, 1 Headphones Line-out, 2 Microphone Output, 2 Audio Phone line, 1 Audio, 1 Audio, 3 Audio, 1 Modem
Connector Type 6 pin mini-DIN (PS/2 style), 15 pin HD D-Sub (HD-15), 4 pin USB Type A, RJ-45, RCA, Mini-phone stereo 3.5 mm, Mini-phone 3.5 mm, RJ-11
Storage Hard Drive (2nd)
2nd hard drive type None
Optical Storage (2nd)
2nd optical storage type None
Storage Controller (2nd)
2nd storage controller form factor Integrated
2nd storage controller installed qty 1
2nd storage controller interface type ATA-100
2nd storage controller type IDE
Modem
Modem 56 Kbps Fax / modem PCI Plug-in card
Audio Output
Audio output form factor Integrated
Audio output type Sound card
Sound card name Intel HD Audio
Speaker (s) Type None
Cabinet (Chassis)
Cabinet form factor Tower
Cache Memory
Cache 1 MB L2 cache
Cache per processor size 1 MB
Card Reader
Supported flash memory cards Microdrive, Memory Stick, MultiMediaCard, SD Memory Card, SmartMedia Card, XD-Picture Card, Memory Stick Duo, Memory Stick Pro, Memory Stick PRO Duo, CompactFlash Card type I, CompactFlash Card type II
Mainboard
Data bus speed 1000 MHz
Miscellaneous
Included accessories Remote control
Networking
Compliant standards IEEE 802.3
Data link protocol Ethernet, Fast Ethernet
Networking Network adapter Integrated
Dimensions & Weight
Depth 16.5 in
Height 15.2 in
Weight 26.9 lbs
Width 7.6 in
Bay Provided
Expansion bays 2 (1 free) Front accessible 5.25" x 1/2H, 2 (1 free) Internal 3.5" x 1/3H, 1 (1 free)
Storage Floppy Drive
Floppy drive type None
Service & Support Details
Full contract period 1 year
Service & Support details Limited warranty
Service included Parts and labor
Input Device
Input device Mouse, Keyboard
Mouse technology Optical
Power Device
Power device type Power supply
Printer
Printer type None
Storage Removable
Removable storage type None
Slot Provided
Slot provided 4 (2 free) Memory DIMM 240-pin, 1 (0 free) Processor, 1 (1 free) PCI Express x16, 3 (1 free) PCI
Storage Controller
Storage controller form factor Integrated
Storage controller installed qty 1
Storage controller interface type Serial ATA-150
Storage controller type Serial ATA
Software
Software type Drivers & Utilities, Microsoft Internet Explorer

[FunkySwerve]

More experienced admins I know use 4.X and shy away from 5 as unproven, though I lack the knowledge to give a more in-depth explanation than that. I think the difference in userfriendliness is non-existant, so you really should be fine with whatever version you choose.
Funky

[The Moofia]

OK... been doing some checking... I now have MySQL v.5 but do not yet have it setup. Any ideas on how to do this easily? Is easy possible?

Where is this aps_mod? I have looked at NWVault and didn't come up with anything other than a mod that would my current server to HCR3.2... something I do NOT want to do at this time.

Would someone take a look at my above system specs and let me know if this system is good enough to do all this on? I should add that I have a 5Mbs DL and a 1Mbs UL.

Perhaps a link to the aps_mod?

Catch me on IM or I check here frequently... IM @ jkeller2791@hotmail.com

[The Moofia]

Anyone?

[Frang]

Heres the link for aps http://nwvault.ign.com/View.php?view=Other.Detail&id=762

As for mysql I use 4.1 its easier to setup its pretty much just install and hit next a few times...make sure you choose to run it as a service and to setup a root password. After you install mysql you will either need to add the odbc2.dll file into your nwn directory or find and download the mysql.dll file from the vault I use the odbc2 myself. then copy the other files noted in the install directions for nwnx into your nwn directory. Open the nwnx.ini file and make the changes from using sqlite to odbc then load up the aps mod using nwnx2.exe it will then load nwserver and if you left the module name the same in the nwnx.ini file aps mod will load...login and use the levers to make the database. Close everything down open your nwn directory look for folder logs.0 check the odbc file for errors. If everything is setup correctly you should see where it created the database. Hope this helps.

Frang

[The Moofia]

Thanks for the info and link... the server already had NWNx2 attached to it, I have inherited it from a friend that ran it for some time and then dropped it due to DM/Admin conflicts. It should already be set up to work with MySQL, but I am on it and checking for compatibility.

[The Moofia]

All is good on the server now... at least as far as PWData. No to try and get some of the other things up and running without very much documentation. Thanks again to everyone that helped out on this.