[MonoTouch] SPAM-LOW: Re: Your sqlite3 version is old - please upgrade to at least v3.5.0!
Ali Shafai
Ali at PlatySoft.com.au
Fri Nov 27 19:14:43 EST 2009
nope, I paid AUD35 and upgraded to snow leopard, got my mac settings all
back with time machine and found out windows 7's system backup is good for
Mr Gate's mom. lost some personal and business data and learned my lesson...
2009/11/28 Mike Bluestein <mike.bluestein at gmail.com>
> 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
>>
>
>
--
Cheers,
Ali
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/monotouch/attachments/20091128/90120333/attachment-0001.html
More information about the MonoTouch
mailing list