Also, you might want to perform all the upgrade steps in a transaction. At least in this case it would have preserved the db, eg.:

sqlite> create table foo ( a int );
sqlite> create table bar ( a int );
sqlite> begin transaction;
sqlite> drop table foo;
sqlite> alter table bar add column b int;
SQL ...

oops, sorry, I forgot to mention it: you need to replace your db with a backup before trying to upgrade it again.

Yes, tempauthors did get created and authors was dropped. So if you don't have a backup, users need to be manually reinserted in the db...

Maybe 1.5.2 could check whether the authors ...

it seems like the .sql file was not a simple text file anymore after you edited it... try with the attached one

first you need to fix the sql script, as described above. Then you can force s9y to re-apply it following the instructions for "My upgrade failed" (http://www.s9y.org/11.html#A20)

The problem is the upgrade script for SQLite. This happens trying to upgrade from 1.4 to 1.5.1:

Warning: sqlite_query() [function.sqlite-query]: near "ALTER": syntax error in [...]/include/db/sqlite.inc.php on line 233

Warning: sqlite_query() [function.sqlite-query]: 9 values for 10 columns in ...