Page 1 of 1

Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 3:43 am
by dargon
Well, I decided to start working on a minor side project, slowly working on a somewhat live-like shard. for two reasons, I love live shards, but my choice is pretty much Old Stonehange, which has some non live-like features (a few quests, and TOA encounters) So I figured, if I can make custom classes, new encounters, and other decent mods, Why couldn't I make livelike shard that can also help storm grow (I plan to give any and all scripts I fix/make As well as give out any DB mods.) So

HERES MY ISSUE BELOW
Code: Select all
Error 1 The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLDatabase\Connection\DataConnection.cs 26 19 DOLDatabase Error 2 The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLDatabase\Handlers\SQLiteObjectDatabase.cs 29 19 DOLDatabase Warning 3 The primary reference "System.Data.SQLite" could not be resolved because it was built against the ".NETFramework,Version=v4.5" framework. This is a higher version than the currently targeted framework ".NETFramework,Version=v4.0". DOLDatabase

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 7:30 am
by Leodagan
Try to upgrade your .NET Framework to version 4.5 (even 4.5.2)

http://www.microsoft.com/en-us/download ... x?id=42642

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 12:29 pm
by dargon
Same error even after installing 4.5.2, and even rebooting.
Code: Select all
Warning 1 The primary reference "System.Data.SQLite" could not be resolved because it was built against the ".NETFramework,Version=v4.5" framework. This is a higher version than the currently targeted framework ".NETFramework,Version=v4.0". DOLDatabase Error 2 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\DOLDatabase.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\GameServer\CSC GameServer Error 3 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\DOLDatabase.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\UnitTests\CSC UnitTests Error 4 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\GameServer.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\UnitTests\CSC UnitTests Error 5 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\DOLDatabase.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLServer\CSC DOLServer Error 6 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\GameServer.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLServer\CSC DOLServer Error 7 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\DOLDatabase.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\GameServerScripts\CSC GameServerScripts Error 8 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\GameServer.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\GameServerScripts\CSC GameServerScripts Error 9 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\DOLDatabase.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLConfig\CSC DOLConfig Error 10 Metadata file 'C:\Users\Mannik\Desktop\WorldsOfDaoc\debug\lib\GameServer.dll' could not be found C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLConfig\CSC DOLConfig Error 11 The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLDatabase\Connection\DataConnection.cs 26 19 DOLDatabase Error 12 The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) C:\Users\Mannik\Desktop\WorldsOfDaoc\DOLDatabase\Handlers\SQLiteObjectDatabase.cs 29 19 DOLDatabase Warning 13 A custom tool 'ResXFileCodeGenerator' is associated with file 'Resources.resx', but the output of the custom tool was not found in the project. You may try re-running the custom tool by right-clicking on the file in the Solution Explorer and choosing Run Custom Tool. DOLConfig

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 1:04 pm
by Leodagan
Obviously you should also update the compile target to 4.5 in your IDE ;)

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 2:02 pm
by dargon
Hopfully last question, and hate to be a bother, I've pretty much learned C# through messing with DOL Code, so while i can write some scripts, i dont know much about visual studio, So sorry, but how would i go about this? I tried a google, but didnt find much info.

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 2:12 pm
by Leodagan
I use SharpDevelop, I never tried visual studio ;)

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 2:29 pm
by Tolakram
I had no issue getting the latest version and building, so I'm not sure what the issue is.

the .NET version is set for each project.

Image

Re: Building a fresh shard Error on SQLite

PostPosted: Mon Aug 25, 2014 4:30 pm
by HunabKu

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 6:30 am
by Leodagan
I had no issue getting the latest version and building, so I'm not sure what the issue is.

the .NET version is set for each project.
I think the way I shipped the SQLite DLL is giving a lot of trouble for people using different compile options than the default one I(We?) use while building...

I don't have a lot of knowledge around library distribution, and I added this SQLite module to allow one-click start of server, if it makes more troubles than previous version maybe it's not a great idea ? (Even with MySQL enforced in configuration I'm pretty sure DOL will need to find the SQLite DLL regardless...)

Is the Autobuilder working nicely with this revision ? (if we still have an Autobuilder ?)

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 12:25 pm
by Tolakram
No idea on AutoBuilder.

I have my own solution for the Core code but it has all the projects and the Database Project has a reference to SQLite and it compiles and runs without issue. I don't recall updating my .NET runtimes for a long while yet I build without a problem. I think this is a .NET install issue where there is a missing version of .NET in some installs.

I'd like to remind people that Microsoft touted .NET 1.0 and references as the way to get rid of DLL hell! Now we have reference hell.

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 3:05 pm
by Graveen
Effectively the autobuild is not working. fixing it now...

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 4:38 pm
by Graveen
updated to .NET4.5 and removed bad Storm reference

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 4:55 pm
by dargon
Using the link given by HunabKu, I was able to build. Thank you all!

Re: Building a fresh shard Error on SQLite

PostPosted: Tue Aug 26, 2014 8:07 pm
by Graveen
updated back to .NET4.0, but installed assemblies for SQLite ngen'ed for .NET4.0. Anyhow it should not break your GAC !