Re: Received fatal signal 11 using a prosqlite predicate

Much is appreciated Nicos,

I have been able to return the following.
?- sqlite_query('SELECT id, title, visit_count FROM moz_places',Row).
Row = row(2, 'Web Search - CrunchBang', 193) ;
Row = row(4, '', 1) ;
Row = row(5, 'Donate to the CrunchBang Project - CrunchBang', 1) ;
Row = row(11, '', 0) ;
Row = row(13, 'Billing Information - PayPal', 1) ;
Row = row(14, '', 1) ;
Row = row(15, 'Yahoo', 187) ;
Row = row(16, '', 1) ;
Row = row(17, '', 1) ;
Row = row(18, 'The 66th Annual Cannes Film Festival - Premiere | Photo  
Gallery - Yahoo! Movies', 1).

I've verified these results via sqlite3.
sqlite> SELECT id, title, visit_count FROM moz_places;
2|Web Search - CrunchBang|193
4||1
5|Donate to the CrunchBang Project - CrunchBang|1
11||0
13|Billing Information - PayPal|1
14||1
15|Yahoo|187
16||1
17||1
18|The 66th Annual Cannes Film Festival - Premiere | Photo Gallery -  
Yahoo! Movies|1

Again I Thank you.

Best Regards,


Bob Ly




Quoting "Nicos Angelopoulos" <[email protected]>:

>
>
> Dear Bob,
>
> Further to my last email, the errors on my local set up
> where due to Sqlite returning zero length Texts and non-zero Nills.
> As far as I understand it this should n't be the case.
> I am not sure if it is the files that are wrong or Sqlite.
> I have taken a pragmatic approach and added extra length checks.
> In my set up I can now read Firefox's places.sqlite.
>
> You can test the changes by getting prosqlite.c from
> http://www.swi-prolog.org/git/packages/prosqlite.git/tree/HEAD:/c
> and putting it in <SWILIBdir>/packs/prosqlite/c/prosqlite.c
>
> then rebuild the pack
>
> ?- pack_rebuild(prosqlite).
>
> hope it helps,
>
> Nicos Angelopoulos.
>
>