1.8.8 Update Failed

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Upgrading from version
2. Used db.file and configuration.php file along with index and custom client 
theme.
3. Cannot login whatsoever I get unknown error occurred and on backend I get 
Authentication Failed while trying to login as admin user.

What is the expected output? What do you see instead?
Expect database to upgrade.

What version of the product are you using? On what operating system?
1.8.6.1, Windows 7 Operating System.

Please provide any additional information below.

Error executing query (UPDATE parameter SET value = '1_8_8' WHERE name = 
'version'; CREATE TEMPORARY TABLE user_backup(id,time,user,type,item,details); 
INSERT INTO user_backup SELECT 
id,name,description,password,a1password,permission_mode,email,auth,is_group 
FROM user; DROP TABLE user; CREATE TABLE user ( id INTEGER PRIMARY KEY, name 
varchar(255) NOT NULL, description varchar(255) NOT NULL DEFAULT '', password 
varchar(128) NULL, a1password varchar(128) NULL, permission_mode char(2) NULL, 
email varchar(128) NULL, auth varchar(8) NULL, is_group TINYINT(1) NOT NULL, 
expiration bigint(11) NULL ); INSERT INTO user SELECT 
id,name,description,password,a1password,permission_mode,email,auth,is_group,NULL
 FROM user_backup; DROP TABLE user_backup;): table user_backup has 6 columns 
but 9 values were supplied

Original issue reported on code.google.com by mariokr...@gmail.com on 1 Jul 2013 at 6:54

[GoogleCodeExporter]

There was a mistake in upgrade script, attached is corrected version (replace 
backend/include/sqlite/sql/1_8_7-1_8_8.sql)

Original comment by samuli.j...@gmail.com on 11 Jul 2013 at 7:02

• Changed state: Accepted

Attachments:

• 1_8_7-1_8_8.sql

[GoogleCodeExporter]

Original comment by samuli.j...@gmail.com on 7 Sep 2013 at 9:27

• Changed state: Fixed