Dependency Graph

View IssueRelationship GraphVerticalShow Summary
Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
09357Bug reportsInstallationpublic2014-11-11 15:522014-11-12 23:47
Reporterrhianed Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionduplicate 
Product Version2.05+ 
Summary09357: Trying to upgrade from 2.00+ to 2.05+. Config.php seems not to be read. Database upgrade contains incorrect details.
Description

Trying to upgrade from 2.00+ to 2.05+. Config.php seems not to be read. Database upgrade contains incorrect details.

Steps To Reproduce

Backup sql server
Copy config.php, tmp, upgrades, web.config and aspnetclient from existing iis 7 folder.
Delete contents of this folder
Unzip 2.05+ into said folder
Replace copied out folders
Clear browser history
Visit http://<mysite>/admin
Database upgrade info lists following incorrect information:
Database type: sqlsrv
Database name:
Table prefix: lime
Site name: LimeSurvey
Root URL: /index.php?r=admin/update
The database name is available in the config.php file.
Clicking next regardless gives the following error:
The LimeSurvey database is being upgraded (2014-11-11 14:48:40) .

Please be patient...

An non-recoverable error happened during the update. Error details:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'PRIMARY'.

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)build141110
I will donate to the project if issue is resolvedNo
BrowserFirefox, Chrome and IE
Database type & versionSQL Server 2012
Server OS (if known)Windows Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.24

Relationships

Relationship GraphDependency Graph
duplicate of 09351 closedc_schmitz Database error during update 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-11-11 15:52 rhianed New Issue
2014-11-12 23:47 c_schmitz Status new => closed
2014-11-12 23:47 c_schmitz Assigned To => c_schmitz
2014-11-12 23:47 c_schmitz Resolution open => duplicate
2014-11-12 23:47 c_schmitz Relationship added duplicate of 09351