Search found 5 matches
- Wed Dec 23, 2009 3:32 pm
- Forum: Installation
- Topic: no login after updated to 1.5.1
- Replies: 22
- Views: 83526
Re: no login after updated to 1.5.1
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 ...
- Wed Dec 23, 2009 3:17 pm
- Forum: Installation
- Topic: no login after updated to 1.5.1
- Replies: 22
- Views: 83526
Re: no login after updated to 1.5.1
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 tab...
- Wed Dec 23, 2009 2:42 pm
- Forum: Installation
- Topic: no login after updated to 1.5.1
- Replies: 22
- Views: 83526
Re: no login after updated to 1.5.1
it seems like the .sql file was not a simple text file anymore after you edited it... try with the attached one
- Wed Dec 23, 2009 1:50 pm
- Forum: Installation
- Topic: no login after updated to 1.5.1
- Replies: 22
- Views: 83526
Re: no login after updated to 1.5.1
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)
- Tue Dec 22, 2009 2:21 pm
- Forum: Installation
- Topic: no login after updated to 1.5.1
- Replies: 22
- Views: 83526
Re: no login after updated to 1.5.1
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 column...