View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04043Bug reportsInstallationpublic2010-01-12 17:442010-01-27 22:46
Reporterlowprofile Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionno change required 
Product Version1.87+ 
Summary04043: When installing errors of duplicate columns appear
Description

Upgrading from 1.86 to 1.87+
Log from install, limesurvey is working ok but these errors probably ? shouldnt show

Executing.....ALTER TABLE lime_survey_99666 ADD lastpage integer...Failed!
Reason: Duplicate column name 'lastpage'
Executing.....ALTER TABLE lime_survey_99982 ADD lastpage integer...Failed!
Reason: Duplicate column name 'lastpage'
Executing.....UPDATE lime_settings_global SET stg_value='139' WHERE
stg_name='DBVersion'...Success!
Executing.....ALTER TABLE lime_surveys ADD emailresponseto text DEFAULT
NULL...Failed! Reason: Duplicate column name 'emailresponseto'
Executing.....UPDATE lime_settings_global SET stg_value='140' WHERE
stg_name='DBVersion'...Success!
Executing.....ALTER TABLE lime_surveys ADD tokenlength tinyint(2) NOT NULL
default '15'...Failed! Reason: Duplicate column name 'tokenlength'
Executing.....UPDATE lime_settings_global SET stg_value='141' WHERE
stg_name='DBVersion'...Success!
Executing.....ALTER TABLE lime_surveys CHANGE expires expires
datetime...Success!
Executing.....ALTER TABLE lime_surveys CHANGE startdate startdate
datetime...Success!
Executing.....UPDATE lime_settings_global SET stg_value='142' WHERE
stg_name='DBVersion'...Success!

Database update finished (2010-01-12 10:50:37)

Database has been successfully upgraded to version 142
Please log in.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8227
I will donate to the project if issue is resolved
Browser
Database type & versionmysql 5.1
Server OS (if known)win2003
Webserver software & version (if known)iis6
PHP Version5.2.9-1

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-01-12 18:07

  ~10753

On my knowledge there was no error, because the script just tried to add a a column, which already exists and therefore wasn't created which is the correct behavior.
@ c_schmitz: Am I right?
c_schmitz

c_schmitz

2010-01-13 15:35

administrator   ~10765

You are right. Most probably you had some previous dev or RC version installed.

Issue History

Date Modified Username Field Change
2010-01-12 17:44 lowprofile New Issue
2010-01-12 17:44 lowprofile Status new => assigned
2010-01-12 17:44 lowprofile Assigned To => user372
2010-01-12 17:44 lowprofile LimeSurvey build number => 8227
2010-01-12 17:44 lowprofile Database & DB-Version => mysql 5.1
2010-01-12 17:44 lowprofile Operating System (Server) => win2003
2010-01-12 17:44 lowprofile Webserver => iis6
2010-01-12 17:44 lowprofile PHP Version => 5.2.9-1
2010-01-12 18:07 user372 Note Added: 10753
2010-01-12 18:07 user372 Assigned To user372 => c_schmitz
2010-01-13 15:35 c_schmitz Note Added: 10765
2010-01-13 15:36 c_schmitz Status assigned => resolved
2010-01-13 15:36 c_schmitz Resolution open => no change required
2010-01-27 22:46 c_schmitz Status resolved => closed