#8 Install Issues, SQLite

[Anonymous]

Apache 2, PHP 4, SQLite 2.8x Install problems...

a) in tools/wheatblog-sqlite.sql (sql file to build
database) line 27, (creating id field for wbtbl_links)
the instruction to add field "id" fails in SQLite

id integer not null primary key auto_increment

I changed it to...

id integer primary key not null,

and that fixed the problem.

b) includes/backend_sqlite.php is missing the DB_quote
function. I had to bring it over from
includes/backend_mysql.php file for wheatblog to function.

c) includes/backend_sqlite.php line 43 (I think) is
missing a semicolon, which causes a fault.

[Joe Bugreporter]

Logged In: YES
user_id=1249834

function DB_quote($q){
return sqlite_escape_string($q);
}