[MonoTouch] SPAM-LOW: Re: Your sqlite3 version is old - please upgrade to at least v3.5.0!
Mike Bluestein
mike.bluestein at gmail.com
Fri Nov 27 18:02:49 EST 2009
did you guys find a solution for this on leopard?
thanks,
Mike
On Mon, Oct 26, 2009 at 9:51 AM, Jonathan Pryor <jonpryor at vt.edu> wrote:
> So, after tons of debugging, we think we know part of the problem.
> You're on the wrong operating system.
>
> It works for me because I'm on Snow Leopard (10.6). It appears to fail
> for Simon because he's on Leopard (10.5).
>
> BUT, here's where it gets funny:
>
> $ nm
> /Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator3.1.2.sdk/usr/lib/libsqlite3.dylib
> | grep _next
> 0000c5a0 T _sqlite3_next_stmt
>
> That should be the same everywhere (it's part of the SDK, not the OS).
>
> So what appears to be the problem is that when running within the
> simulator, instead of picking up the libsqlite3.dylib provided by
> iPhoneSimulator.platform, it instead picks up /usr/lib/libsqlite3.dylib.
> Snow Leopard's libsqlite3.dylib is a more recent version than Leopard's
> (and Snow Leopard's apparently better matches what's on the device),
> which is why it works on both Snow Leopard Simulator & the device.
>
> What I don't know is the solution for Leopard -- how do we get Mono
> within the simulator to pick up iPhoneSimulator's libsqlite3.dylib
> instead of /usr/lib/libsqlite3.dylib? This will require additional
> investigation.
>
> - Jon
>
> On Mon, 2009-10-26 at 21:55 +1100, Ali Shafai wrote:
> >
> ?ui=2&view=att&th=124907be3c8a79b6&attid=0.1&disp=attd&realattid=ii_124907be3c8a79b6&zw
> >
> > 2009/10/26 Craig Dunn <craig.dunn at conceptdevelopment.net>
> > Good news Jonathan - after a bit of fiddling with the 'unused'
> > mainwindowxib and adding the correct references I got the
> > following output (on simulator) from the sample
> > at http://monotouch.net/Documentation/System.Data
> >
> >
> > (Row (PersonID '1') (FirstName 'First') (LastName 'Last'))
> > (Row (PersonID '2') (FirstName 'Dewey') (LastName 'Cheatem'))
> > (Row (PersonID '3') (FirstName 'And') (LastName 'How'))
> >
> >
> >
> >
> > I also added it to another sample, just to be sure
> >
> http://conceptdev.blogspot.com/2009/10/monotouch-corp411-part-iii-revenge-of.html
> >
> >
> > craig
> >
> >
> > p.s. excuse the dup post - there is another 'answer' in the
> > ether with a too-large attachment...
> >
> >
> >
> >
> >
> > On Mon, Oct 26, 2009 at 1:23 PM, Jonathan Pryor
> > <jonpryor at vt.edu> wrote:
> >
> > So I'm terribly confused. Apparently the sample code
> > works for me, but not for anyone else. :-/
> >
> >
> > As a last-ditch effort at reproducibility, I've
> > updated the monocatalog-md sample to use
> > Mono.Data.Sqlite:
> >
> >
> >
> http://anonsvn.mono-project.com/source/trunk/monotouch/samples/monocatalog-md/
> >
> >
> > Specifically:
> >
> >
> >
> http://anonsvn.mono-project.com/source/trunk/monotouch/samples/monocatalog-md/MonoDataSqlite.xib.cs
> >
> >
> > That sample works for me, without error, on both the
> > simulator and the device. Does this work for anyone
> > else?
> >
> >
> > Thanks,
> > - Jon
> >
> >
> > On Oct 25, 2009, at 6:24 PM, Ali Shafai wrote:
> >
> >
> >
> > > it was actually exactly that example that gave me
> > > the error. I ran on simulator only. don't have
> > > access to my mac at work. to test on device I have
> > > to wait for another 8 hours :(
> > >
> > > Cheers,
> > > Ali
> > >
> > > 2009/10/26 Simon Guindon <simon at nureality.ca>
> > > I ran this on the simulator first and that's
> > > the result I got. I'll run on device and let
> > > you know the results.
> > >
> > >
> > > I'll give the example a run as well.
> > >
> > >
> > > Thanks,
> > > Simon
> > >
> > >
> > > ____________________________________________
> > > From: jonpryor at vt.edu
> > >
> > > To: simon at nureality.ca
> > >
> > > Subject: Re: [MonoTouch] Your sqlite3
> > > version is old - please upgrade to at least
> > > v3.5.0!
> > >
> > > Date: Sun, 25 Oct 2009 12:49:48 -0400
> > > CC: ali at platysoft.com.au;
> > > monotouch at lists.ximian.com
> > >
> > >
> > >
> > > Odd. Does the example code at
> > >
> http://monotouch.net/Documentation/System.Data#Example work for you?
> > >
> > >
> > > Which iPhoneOS version & hardware is this?
> > >
> > >
> > > Thanks,
> > > - Jon
> > >
> > > On Oct 25, 2009, at 12:01 PM, Simon Guindon
> > > <simon at nureality.ca> wrote:
> > >
> > >
> > >
> > > I'm also getting this error.
> > >
> > >
> > > I don't think it's related to using
> > > a function that isn't in 3.0 because
> > > I'm getting this exception on the
> > > connection.Open()
> > >
> > >
> > > I'm doing the following:
> > >
> > >
> > > SqliteConnection.CreateFile(dbPath);
> > > SqliteConnection connection = new
> > > SqliteConnection("Data Source=" +
> > > dbPath);
> > > connection.Open();
> > >
> > >
> > > Thanks,
> > > Simon
> > >
> > > > From: jonpryor at vt.edu
> > > > To: Ali at PlatySoft.com.au
> > > > Date: Sun, 25 Oct 2009 08:26:22
> > > -0400
> > > > CC: monotouch at lists.ximian.com
> > > > Subject: Re: [MonoTouch] Your
> > > sqlite3 version is old - please
> > > upgrade to at least v3.5.0!
> > > >
> > > > On Sun, 2009-10-25 at 19:07 +1100,
> > > Ali Shafai wrote:
> > > > > I'm trying to use Sqlite in my
> > > app using the lib from here :
> > > > >
> > >
> http://monotouch.net/Documentation/System.Data
> > > > >
> > > > > when I run my app I get this
> > > error: Your sqlite3 version is old -
> > > > > please upgrade to at least
> > > v3.5.0!
> > > >
> > > > Can you provide source code that
> > > demonstrates this bug?
> > > >
> > > > Also keep in mind the limitations:
> > > >
> > > >
> > >
> http://monotouch.net/Documentation/System.Data#Mono.Data.Sqlite
> > > >
> > > > You're probably attempting to use
> > > one of the functions that isn't in
> > > > SQLite v3.0 (which is what
> > > iPhoneOS provides).
> > > >
> > > > Thanks,
> > > >
> > > > - Jon
> > > >
> > > >
> > > >
> > >
> _______________________________________________
> > > > MonoTouch mailing list
> > > > MonoTouch at lists.ximian.com
> > > >
> > >
> http://lists.ximian.com/mailman/listinfo/monotouch
> > >
> > >
> > >
> > > ____________________________________
> > > CDN College or University student?
> > > Get Windows 7 for only $39.99 before
> > > Jan 3! Buy it now!
> > >
> > >
> > > ____________________________________________
> > > Ready for a deal-of-a-lifetime? Find
> > > fantastic offers on Windows 7, in one
> > > convenient place.
> > >
> > >
> > >
> > > --
> > > Cheers,
> > > Ali
> > >
> >
> >
> >
> >
> > _______________________________________________
> > MonoTouch mailing list
> > MonoTouch at lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/monotouch
> >
> >
> >
> >
> >
> >
> > --
> > Cheers,
> > Ali
> >
>
> _______________________________________________
> MonoTouch mailing list
> MonoTouch at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/monotouch
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/monotouch/attachments/20091127/513a51f5/attachment-0001.html
More information about the MonoTouch
mailing list