ACR Compile Error Details

AcadiusLost · Post by **AcadiusLost** » Thu Aug 30, 2007 9:28 pm

I can't browse the DB from work, but I'll look when I'm home.

Normally, any errors in writing to the DB should be logged in xp_mysql.txt - so that'd be the first place to check if you suspect problems- otherwise, you can just log into the database (vault.alandfaraway.org) with an SQL browser and the same connection info from xp_mysql.ini and look for yourself.

It may well be that the table definition is still subtly incorrect.

If needs be and you can't find any leads to follow up, you can 7zip up the module/directory and I'll see if I can give it a once-over tonight.

indio · Post by **indio** » Thu Aug 30, 2007 9:50 pm

Would it be useful for me to send you my database file so you can transfer working tables over to the remote database server?

AcadiusLost · Post by **AcadiusLost** » Thu Aug 30, 2007 9:55 pm

Might be worth a shot, if you can export it somehow (assuming you mean the contents of your working SQL table, as opposed to the NWN2/database contents)

indio · Post by **indio** » Thu Aug 30, 2007 10:00 pm

Ok...I'll try exporting the SQL tables. Never done it before, but who knows what's possible.

indio · Post by **indio** » Sun Sep 02, 2007 5:24 am

AcadiusLost wrote: you can just log into the database (vault.alandfaraway.org) with an SQL browser and the same connection info from xp_mysql.ini and look for yourself.

I've downloaded Toad, this SQL Browser. Trying to connect using the details in the ini file, but I'm not having any luck. Any help connecting would be appreciated.

indio · Post by **indio** » Sun Sep 02, 2007 5:27 am

Here's the error.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

AcadiusLost · Post by **AcadiusLost** » Sun Sep 02, 2007 6:33 am

TSF is writing to the DB though, I can see the the records for all the PCs from the quest earlier recorded there. Doesn't seem to be writing to the spelltrack table though, which explains at least one bug (aberrant restoration of spells on relogging or resting).

I can also see records for everyone who tried to take quests, szPlotState = 1 for each quest taken.

So, it's not as simple as a failure to connect to the DB, but I'm still at a loss as to how to explain it satisfactorily. I'll keep on the testing.

indio · Post by **indio** » Sun Sep 02, 2007 8:16 pm

Ok. Beauty.

AcadiusLost · Post by **AcadiusLost** » Sun Sep 02, 2007 8:25 pm

Indio, could you put a 7zip'd copy of your directory up somewhere (your FTP, tech FTP, etc) so I can try it that way? Might make all the difference.

indio · Post by **indio** » Sun Sep 02, 2007 9:06 pm

http://www.thesivermarches.net/uploads/sept3.rar

Give it 10 minutes before downloading...still uploading.

I've stripped out all areas except for the start area and High Hold, so there's something to test on, but small enough to upload quickly. 20MB.