Freelancer Community Network
Reminder: Internet Explorer 6 or below are NOT supported.
HomeHome
ForumForum
WikiWiki
DownloadsDownloads
ForgeForge
Multiplayer Connection Tutorial
Collapse/Expand Random Image
Planet and Cityscape 07
Collapse/Expand Login
Username:

Password:

Remember me



Lost Password?

Register now!
Collapse/Expand Main Menu
Collapse/Expand Forum
Collapse/Expand Chat
Collapse/Expand Who's Online
106 user(s) are online (55 user(s) are browsing Forum)

Members: 0
Guests: 106

more...
Collapse/Expand Donations
Monthly costs: -30€
Income (ads): +5€
Donations (last month): +0€

Current balance: 55€
(last updated 04/2021)

Please make a donation if you want to help keeping The-Starport online:

Thanks!
Collapse/Expand Links
Collapse/Expand Advertisement
There are currently 52 users playing Freelancer on 43 servers.
 March. 29, 2023

Browsing this Thread:   1 Anonymous Users



 Bottom   Previous Topic   Next Topic  Register To Post

« 1 (2) 3 »


Sushi
Re: DSAccountManager Version 1.4
#16
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
Quote:

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?

Posted on: 2011/10/2 22:00
Open in new window
Top
J.Walker
Re: DSAccountManager Version 1.4
#17
Quite a regular
Joined:
2008/6/13 4:53
From Canada
Group:
Registered Users
Posts: 121
Offline
Not sure if this will help or not, but a couple things you can check:

1) 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

2) verify that you are running the correct 'bit depth' version of dsam.

3) 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.

Posted on: 2011/10/2 22:40
Top
HeIIoween
Re: DSAccountManager Version 1.4
#18
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1781
Offline
Quote:

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

Posted on: 2011/10/2 22:56
Open Sirius Mod
Top
Sushi
Re: DSAccountManager Version 1.4
#19
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
Quote:

HeIIoween wrote:
Quote:

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

Code:
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)


Posted on: 2011/10/3 0:36
Open in new window
Top
M1C
Re: DSAccountManager Version 1.4
#20
Quite a regular
Joined:
2010/5/29 11:40
Group:
Registered Users
Posts: 176
Offline
I'll send you a debug build this evening (GMT+2)..
ugly bug..

Posted on: 2011/10/3 6:53
Top
Sushi
Re: DSAccountManager Version 1.4
#21
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
You're awesome, M1C. Thanks

Posted on: 2011/10/3 11:24
Open in new window
Top
M1C
Re: DSAccountManager Version 1.4
#22
Quite a regular
Joined:
2010/5/29 11:40
Group:
Registered Users
Posts: 176
Offline
I sent you a link via Skype. You received it, don't you?

Posted on: 2011/10/3 18:32
Top
Sushi
Re: DSAccountManager Version 1.4
#23
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
Quote:

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!

Posted on: 2011/10/4 2:57
Open in new window
Top
M1C
Re: DSAccountManager Version 1.4
#24
Quite a regular
Joined:
2010/5/29 11:40
Group:
Registered Users
Posts: 176
Offline
Hmm, I don't know your e-mail-adress
I sent you a private message

Posted on: 2011/10/4 7:17
Top
Sushi
Re: DSAccountManager Version 1.4
#25
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
Quote:

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:

Code:
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


Posted on: 2011/10/4 11:16
Open in new window
Top
M1C
Re: DSAccountManager Version 1.4
#26
Quite a regular
Joined:
2010/5/29 11:40
Group:
Registered Users
Posts: 176
Offline
arghh.. see you in skype^^

Posted on: 2011/10/4 12:20
Top
Sushi
Re: DSAccountManager Version 1.4
#27
Starport Admin
Joined:
2008/6/24 16:40
From http://www.freeworlds-tow.net/dev
Group:
Registered Users
Starport Admin
$$$ Supporters $$$
Posts: 1123
Offline
M1C fixed it. Not sure what he did, but it works now

Posted on: 2011/10/4 22:21
Open in new window
Top
M1C
Re: DSAccountManager Version 1.4
#28
Quite a regular
Joined:
2010/5/29 11:40
Group:
Registered Users
Posts: 176
Offline
Wut? I did nothing but pressing the recompile button..

Posted on: 2011/10/5 6:47
Top
HeIIoween
Re: DSAccountManager Version 1.4
#29
Home away from home
Joined:
2008/9/11 15:55
From Somewhere at Moscow
Group:
Registered Users
FLServer Admins
$$$ Supporters $$$
Senior Members
Posts: 1781
Offline
@M1C perfomance suggestion:
Code:
conn = new SQLiteConnection("Data Source=" + AppSettings.Default.setAccountDir + "\\dsam.db; Cache Size=2000;Synchronous=Off;count_changes=0;temp_store=0;");


Posted on: 2011/11/8 19:36
Open Sirius Mod
Top
carloak
Re: DSAccountManager Version 1.4
#30

Joined:
2011/11/19 2:17
Group:
Registered Users
Posts: 25
Offline
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

Posted on: 2011/12/26 2:33
Top
Top Top   Previous Topic   Next Topic
« 1 (2) 3 »

  Register To Post