09351: Database error during update - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09351	Bug reports	ComfortUpdate	public	2014-11-10 11:09	2014-11-13 17:11

Reporter	dichteros	Assigned To	c_schmitz
Priority	normal	Severity	block
Status	closed	Resolution	fixed
Product Version	2.05+
Fixed in Version	2.05+

Summary	09351: Database error during update
Description	Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation: CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "PRIMARY" LINE 1: ALTER TABLE questions DROP PRIMARY KEY, ADD PRIMARY KEY (qid... ^
Steps To Reproduce	Comfort-Update
Tags	No tags attached.
Attached Files	Bildschirmfoto 2014-11-12 um 01.16.27.png (54,108 bytes) Bildschirmfoto 2014-11-12 um 01.16.27.png (54,108 bytes)

Bug heat	20
Complete LimeSurvey version number (& build)	Version 2.05+ Build 141109
I will donate to the project if issue is resolved	No
Browser	Safari/Firefox/Chrome
Database type & version	Postgresql 9.1.14
Server OS (if known)	Ubuntu
Webserver software & version (if known)	Apache/2.2.22
PHP Version	5.3.10

User List	dichteros

c_schmitz 2014-11-10 12:49 administrator ~30936	Please apply the patch below.

dichteros 2014-11-10 15:40 reporter ~30938	doesn't work still the same failure

dichteros 2014-11-10 15:41 reporter ~30939	u did it for mysql, but not for postgres

c_schmitz 2014-11-10 16:44 administrator ~30940	It is not supposed to run for Postgres.

dichteros 2014-11-10 19:07 reporter ~30941	Sorry, I don'T understand. Limesurvey is not longer supporting postgres? Cause the failure just happens while using postgres

c_schmitz 2014-11-11 09:20 administrator ~30944	If you apply the patch the issue is gone for postgres.

dichteros 2014-11-11 11:59 reporter ~30946	Thanks a lot, But after doin' the patch just a Frey Screen appears in the browser

c_schmitz 2014-11-11 14:08 administrator ~30949	Frey?

dichteros 2014-11-11 14:15 reporter ~30950	Grey

c_schmitz 2014-11-11 14:31 administrator ~30951	I think you did not properly patch. Just use the file from the latest version where this is already fixed.

dichteros 2014-11-12 01:17 reporter ~30952	fixed it, as described, still the same issue (see new attached file)

c_schmitz 2014-11-12 23:48 administrator ~30956	Sorry for the inconvenience. I have created a new patch where this is properly fixed now.

c_schmitz 2014-11-12 23:49 administrator ~30957	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14616

c_schmitz 2014-11-13 17:11 administrator ~30986	Version 2.05 Build 141113 released

Date Modified	Username	Field	Change
2014-11-10 11:09	dichteros	New Issue
2014-11-10 11:09	dichteros	Status	new => assigned
2014-11-10 11:09	dichteros	Assigned To	=> c_schmitz
2014-11-10 11:10	dichteros	Issue Monitored: dichteros
2014-11-10 12:49	c_schmitz	Note Added: 30936
2014-11-10 12:49	c_schmitz	Status	assigned => resolved
2014-11-10 12:49	c_schmitz	Fixed in Version	=> 2.05+
2014-11-10 12:49	c_schmitz	Resolution	open => fixed
2014-11-10 12:49	c_schmitz	Changeset attached	=> LimeSurvey master c93626ab
2014-11-10 15:40	dichteros	Note Added: 30938
2014-11-10 15:41	dichteros	Note Added: 30939
2014-11-10 16:44	c_schmitz	Note Added: 30940
2014-11-10 19:07	dichteros	Note Added: 30941
2014-11-11 09:20	c_schmitz	Note Added: 30944
2014-11-11 11:59	dichteros	Note Added: 30946
2014-11-11 14:08	c_schmitz	Note Added: 30949
2014-11-11 14:15	dichteros	Note Added: 30950
2014-11-11 14:31	c_schmitz	Note Added: 30951
2014-11-12 01:16	dichteros	File Added: Bildschirmfoto 2014-11-12 um 01.16.27.png
2014-11-12 01:17	dichteros	Note Added: 30952
2014-11-12 23:45	c_schmitz	Summary	SQLSTATE[42601] => Database error during update
2014-11-12 23:46	c_schmitz	Relationship added	has duplicate 09359
2014-11-12 23:47	c_schmitz	Relationship added	has duplicate 09357
2014-11-12 23:48	c_schmitz	Note Added: 30956
2014-11-12 23:49	c_schmitz	Changeset attached	=> LimeSurvey master 39994ee0
2014-11-12 23:49	c_schmitz	Note Added: 30957
2014-11-12 23:49	c_schmitz	Changeset removed	LimeSurvey master c93626ab =>
2014-11-13 17:11	c_schmitz	Note Added: 30986
2014-11-13 17:11	c_schmitz	Status	resolved => closed
2021-08-03 18:52	guest	Bug heat	18 => 20

LimeSurvey: master 39994ee0 2014-11-12 23:49 c_schmitz Details Diff	Fixed issue 09351: Database error during update when using a database other than MySQL		Affected Issues 09351
	mod - application/helpers/update/updatedb_helper.php		Diff File

View Issue Details

Relationships

Users monitoring this issue

Activities

Related Changesets

Issue History

has duplicate	09359	closed	c_schmitz	Database error during migration from 1.90+ Build 9642 to 2.05+ Build 141110
has duplicate	09357	closed	c_schmitz	Trying to upgrade from 2.00+ to 2.05+. Config.php seems not to be read. Database upgrade contains incorrect details.