Simon,
We understand how SQlite is compiled into programs. We weren?t sure if the
issues were Navicat which we sometimes use for a front end or the Perl DB
stuff. My money was on Navicat being the problem. I was wrong, it was the DB
version.
The sqlite version is 3.7.17 on Ubuntu 14.04 server.
Rob
> On 17 Sep 2015, at 15:00, Simon Slavin <slavins at bigfraud.org> wrote:
>
>
>> On 17 Sep 2015, at 2:47pm, Rob Willett <rob.sqlite at robertwillett.com>
>> wrote:
>>
>> 3. We cannot get WITHOUT ROWID working using Perl DBI. We get the following
>> error
>>
>> DBD::SQLite::db prepare failed: malformed database schema (postcode) - near
>> ?WITHOUT"
>>
>> This appears to be due to mismatched SQLite version but we are running
>>
>> macpro:postcode rwillett$ sqlite3 --version
>> 3.8.5 2014-08-15 22:37:57 c8ade949d4a2eb3bba4702a4a0e17b405e9b6ace
>>
>> The SQLite web page on WITHOUT ROWID indicates we need 3.8.2 or higher so
>> we?re confused as to what the problem is.
>
> SQLite is not 'installed in your system'. It is compiled separately into
> each program which uses it. The version number returned by the command-line
> tool (sqlite3) is the version of SQLite that is compiled into the
> command-line tool.
>
> Your version of Perl will have a different version of SQLite compiled into
> it. To find out which version that is, I think you can do this:
>
> $dbh->{sqlite_version};
>
> assuming $dbh is your handle to a SQLite connection.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
