DSAccountManager Version 1.4
-
M1C wrote:
The System.Data.SQLite error is known, I tried many things to fix but… but none worked…
Hmm there are a few bugs on my list… I’ll have to find some time to fix them…Sushi are you sure you deleted the right db? and is the Char File Directory set to the right value?
It should create all missing tables in “GetConnection()”…The character file directory is set to the multiplayer file. I deleted the .db in the multiplayer file. It has 0 bytes, though.
Any other thoughts?
-
Not sure if this will help or not, but a couple things you can check:
- go to: http://sqlitebrowser.sourceforge.net/ and download this applicaiton. once downloaded run it, and open the dsam.db file. verify that the table: CharacterList has actually been created. and contains the following table columns:
CharPath, AccDir,Charame, IsDeleted, Location, Ship, Money, Rank, Created, Updated, OnLineSecs, LastOnline
-
verify that you are running the correct ‘bit depth’ version of dsam.
-
if 2 is correct, verify that the System.Data.SQLite.dll for your bit depth is actually the correct bit depth dll for that version.
if none of the above works for you load the ‘DSAccountManager_2010.sln’ in Visual Studio 2010 (if you do not have VS 2010, download the VS C# Express Edition from Microsoft) , open DataAccess.cs, find the line:
private SQLiteConnection GetConnection()
and set a breakpoint on the first if statement in that function and step through it one line at a time, this will tell you what line is actually barfing the error. Then post here what line number throws the error. This will help narrow down where the problem is.
-
Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)Give it what it wants: 1.0.66.0 version
-
HeIIoween wrote:
Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)Give it what it wants: 1.0.66.0 version
Thanks for the link. Tried it and I got the same issue but with this error
Error 'SQLite error no such table: CharacterList' when updating db Loading player information... Error 'SQLite error no such table: CharacterList' at at DAM.DataAccess.GetConnection() at DAM.DataAccess.GetBanList(BanListDataTable dsTable, Boolean onlyExistent) at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e) -
You’re awesome, M1C. Thanks
-
M1C wrote:
I sent you a link via Skype. You received it, don’t you?Sadly, no. Maybe send it to email? Thanks for working on this so quickly!
-
M1C wrote:
Hmm, I don’t know your e-mail-adress
I sent you a private message
OK. Got it.
Here’s what came up:
Opening database... Loading game data... Error 'Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.' at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e) in C:\Documents and Settings\User\Desktop\DSAccountManager1.4.1\src\MainWindow.cs:line 249 -
M1C fixed it. Not sure what he did, but it works now
-
@M1C perfomance suggestion:
conn = new SQLiteConnection("Data Source=" + AppSettings.Default.setAccountDir + "\\dsam.db; Cache Size=2000;Synchronous=Off;count_changes=0;temp_store=0;"); ```:) -
So is there a fix for this? I keep getting an error
Cannot access database. Check your "Player Accounts Directory’It was doing the same thing with dsam 1.41, but exiting with a runtime error shortly after that. Details showed a
SystemBadFormatImage.So I went to 1.4 and no runtime error, but can’t access the player’s database. FLHook 1.61, DS Process Manager, DSAM 1.4 64 bit, Running Discovery 4.85.
I only have 1 character as my server is still in testing and construction. I delete the dsam.db file and after the run of DSAM it is back, but still says can’t access the player database.
Just about to tear out what little of the hair I have left
-
Well, I finally got it working, but I had to go back to v1.1. I would prefer using the latest version, but they don’t work on my system. Don’t know why, but they just keep saying “Cannot access the player database. Check your ‘Player Account Directory’”.
No matter. It’s working now so I’m happy.
