View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
09949Bug reportsComfortUpdatepublic2015-12-09 09:39
Reporterpgee Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionduplicate 
Product Version2.06+ 
Summary09949: unable to upgrade due to error in migration script upgradeTokenTables179
Description

a reopen of issue 09579
exactly the same issue.

Steps To Reproduce

osx 10.10.5
php
mysql 5.6.26 Source distribution
PHP 5.5.27
github 2.06 branch on server with 2.05 set up.

Additional Information

in order to proceed i had to manually remove indexes on some of my token tables
ALTER TABLE lime_tokens_11324 DROP INDEX idx_lime_tokens_11324_efl;
ALTER TABLE lime_tokens_37624 DROP INDEX idx_lime_tokens_37624_efl;
ALTER TABLE lime_tokens_77686 DROP INDEX idx_lime_tokens_77686_efl;
ALTER TABLE lime_tokens_79415 DROP INDEX idx_lime_tokens_79415_efl;
ALTER TABLE lime_tokens_92878 DROP INDEX idx_lime_tokens_92878_efl;

note only some of my token tables had multiple indexes on them.
this was caused by upgradedb_helper::upgradeTokenTables179 setting the last name field

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build) 88c14fc12aa9a32c146c08ce126
I will donate to the project if issue is resolvedNo
Browserchrome 45.0.2454.101
Database type & versionmysql 5.6.26
Server OS (if known)osx 10.10.5
Webserver software & version (if known)Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.2d DAV/2 PHP/5.5.29
PHP VersionPHP 5.5.27

Relationships

related to 09579 closedc_schmitz system.db.CDbCommand MYSQL -> 2.06a1 Build 150305 

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-10-06 04:20 pgee New Issue
2015-10-06 04:20 pgee Status new => assigned
2015-10-06 04:20 pgee Assigned To => c_schmitz
2015-12-09 09:34 c_schmitz Relationship added related to 09579
2015-12-09 09:39 c_schmitz Status assigned => closed
2015-12-09 09:39 c_schmitz Resolution open => duplicate