This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
We were using the LS 4 nightly from 20110901, and just attempted to migrate to LS 5. After fixing all of the dependencies (new SQLite providers, etc), it is now "running", but we are receiving a very odd error. When calling UnitOfWork.Find However, the table we're trying to load has no booleans defined. The table is defined (in SQL) as:
The Lightspeed model for this table is defined as:
There are no boolean values defined anywhere within this table. I had originally tried migrating to the March 8th nightly, but then reverted to the LS 5 release - both have the same issue. This appears to be occurring from the original opening of the SQLite database, as the StackTrace (while it doesn't contain much) does show:
I'm not sure if this is a matter of having the wrong provider versions? We used the 1.0.82.0 System.Data.Sqlite.dll from the Lightspeed install folder, but it does not include the interop.dll for x86/x64 support, so we had to use the current version. Where can we get the proper SQLite assemblies (both x86 + x64) to work with the LS 5 build? This error is occurring in x86 - we can't get x64 to run at all, as the 1.0.82 assembly provided appears to be x86 only. Thank you, Reed |
|
|
Sounds a bit odd - what does your connection string look like? Are there any boolean options in it? Given the stack trace Im very curious what the problem might be :) In terms of the provider versions you can grab these from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki - we compile against the 32 bit bundled version by default.
|
|
|
Jeremy, Our connection string is very simple - it's generated by:
The 1.0.84.0 versions (from that link) were giving errors (I am not on my build system -so I can't post the exact errors I was having) - I know you're building against an older version (1.0.82.0) which I can't find online anywhere. Do you have a copy available of the versions you're building against? Otherwise, can you migrate to the latest/current version? -Reed |
|
|
Should the "Foreign Keys=ON" be "Foreign Keys=True"? I would assume thats where the parsing failure if occurring - can you give that a try? Im afraid I only have the 32 bit bundled assembly here (the one we compile against) but I will look at updating the provider version soon. In the meantime you can use a binding redirect to target a newer provider version, e.g.
|
|
|
Jeremy, Good call on the =ON vs =True - for some reason, the newer SQLite assemblies changed their requirements here. That, with the binding redirect, has got me past that point... Thanks for the help. It would be nice if we could get a version that built against a 1.0.84.0 version of the assemblies at some point. The binding redirect works (temporarily) for me, but we're building a plugin for a 3rd party app, and we can't enforce app.config changes (since we don't control the application runtime environment), so it's not a good long term solution for us... -Reed |
|