06594: upgrading from 1.87+ build 8518 to 2.00+ build 120926

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

06594	Bug reports	Installation	public	2012-09-26 16:23	2012-09-30 15:22

Reporter	sshawl	Assigned To	c_schmitz
Priority	normal	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	06594: upgrading from 1.87+ build 8518 to 2.00+ build 120926
Description	Lines 580 and 581 of the /application/helpers/update/updatedb_helper.php (seen here) Yii::app()->db->createCommand()->dropIndex('user_in_groups_idx1','{{user_in_groups}}'); addPrimaryKey('user_in_groups', array('ugid','uid')); needed to be commented out in order for the update to run past this point. I was running 1.87+ build 8518 db version 142. (started at 1.87+ with a fresh install)
Steps To Reproduce	Follow the upgrade instructions to upgrade from an install of 1.87+ build 8518 db 142 to 2.00+ build 120926 db 162
Tags	No tags attached.

Bug heat	2
Complete LimeSurvey version number (& build)	120926
I will donate to the project if issue is resolved	No
Browser
Database type & version	Mysql 5.0.77
Server OS (if known)	Centos 5.3
Webserver software & version (if known)	Apache 2.2.3
PHP Version	5.3.3

User List	There are no users monitoring this issue.

c_schmitz 2012-09-27 08:40 administrator ~20832	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9561

c_schmitz 2012-09-27 08:40 administrator ~20833	Thank you!

c_schmitz 2012-09-30 15:22 administrator ~20910	New Version 2.00+ Build 120930 released. If you are using 120926 you should be able to update by ComfortUpdate. All earlier versions need to update manually.

Date Modified	Username	Field	Change
2012-09-26 16:23	sshawl	New Issue
2012-09-26 21:35	c_schmitz	Assigned To	=> c_schmitz
2012-09-26 21:35	c_schmitz	Status	new => assigned
2012-09-27 08:40	c_schmitz	Changeset attached	=> LimeSurvey master 75cb4918
2012-09-27 08:40	c_schmitz	Note Added: 20832
2012-09-27 08:40	c_schmitz	Resolution	open => fixed
2012-09-27 08:40	c_schmitz	Note Added: 20833
2012-09-27 08:40	c_schmitz	Status	assigned => resolved
2012-09-27 08:40	c_schmitz	Fixed in Version	=> 2.00+
2012-09-30 15:22	c_schmitz	Note Added: 20910
2012-09-30 15:22	c_schmitz	Status	resolved => closed

LimeSurvey: master 75cb4918 2012-09-26 23:39:54 c_schmitz Details Diff	Fixed issue 06594: Error when upgrading from version 1.87		Affected Issues 06594
	mod - application/helpers/update/updatedb_helper.php		Diff File