In another case I am trying to put a web front-end to
CPANTS - an already existing SQLite database.
http://cpants.dev.zsi.at/cpants_paper.html
Once I a access the thing using Maypole I get the following error in the
apache log file:
SQL ERROR: 'BIGINT' is not a recognized data type!
I tried deleting the tables[1] with the BIGINT fields but then I get:
SQL ERROR: Unknown column constraint: 'unsigned'!
deleteing these tables too I still get:
SQL ERROR: Unknown column constraint: 'default'!
Then Maypole can already display the list of the tables but
it is still crashing when I try to access either one of them.
Deleting the remaing two tables elimitae the crashes but having an empty
database is not that much fun.
Does anyone have an idea why does this happen ?
[1] I am using the command line interface of SQLite v2.8.14 and it
can read the database.
perl -MDBD::SQLite -e'print $DBD::SQLite::VERSION'
0.31
AFAIK this is the latest version of DBD::SQLite using the 2.8.*
database structure and I assume the file is of that version if
the command line tool can read.
Gabor
_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole
This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:56 GMT