06424: SQL Server Error - Taking Survey - LimeSurvey bugs, patches and feature requests

(20177)
Mazi (developer)
2012-08-03 23:49

I can reproduce the problem following the steps described above.

Can you attach the DB backup which was created prior to the update (should be located at /tmp?!
We can mark this ticket private so only developers will be able to access the file.

From which version did you update?

(20208)
c_schmitz (administrator)
2012-08-05 18:38
edited on: 2012-08-06 11:23

Which DB driver are you using in config.php?
mssql_n, mssql_odbc or mssqlnative ?

(20218)
c_schmitz (administrator)
2012-08-06 11:23

?

(20226)
tim44202 (reporter)
2012-08-06 15:05

ODBC Support enabled
Active Persistent Links 0
Active Links 1
ODBC library Win32

(20227)
c_schmitz (administrator)
2012-08-06 15:06

I am sorry, that's not the answer to my question. Can you please re-read?

(20228)
tim44202 (reporter)
2012-08-06 15:30

Sorry is this what you wanted?

$databasetype = 'odbc_mssql';
$databaselocation = 'SQL02';
$databasename = 'limesurvey'

(20233)
c_schmitz (administrator)
2012-08-06 20:58
edited on: 2012-08-06 21:00

Yes, thank you. I will retest the upgrade and let you know.
The quickfix for you is to add a field 'lastpage' of type 'int' to every survey_<surveyID> table. Ideally the upgrade should have done this for you. Did you maybe upgrade with too tight security settings? You should have received lots of errors during DB upgrade, though.

Maybe you can restore the original database and try to assign root permissions to the LimeSurvey DB user, then run the upgrade again. Because if this has failed more stuff may have failed.

(20234)
tim44202 (reporter)
2012-08-06 21:26

The workaround cured the problem.

I just noticed that only one of the two Limesurvey websites has this problem.
Perhaps one of the updates altered the db and it was skipped and or failed on one of them.

(20254)
c_schmitz (administrator)
2012-08-07 20:47

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9262 [^]

(20255)
c_schmitz (administrator)
2012-08-07 20:47

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9263 [^]

(20256)
c_schmitz (administrator)
2012-08-07 20:47

It was indeed an error in the update script. Thank you for bringing this to our attention.

Related Changesets
LimeSurvey: master 9f131938 Timestamp: 2012-08-07 11:44:05 Author: c_schmitz Committer: Carsten Schmitz [ Details ] [ Diff ]	Fixed issue 06424: Lastpage field not being added in MSSQL when upgrading from 1.85 or older
	mod - common_functions.php	[ Diff ] [ File ]

LimeSurvey: Yii 2401db5a Timestamp: 2012-08-07 11:47:01 Author: c_schmitz Committer: Carsten Schmitz [ Details ] [ Diff ]	Fixed issue 06424: Lastpage field not being added in MSSQL when upgrading from 1.85 or older
	mod - application/helpers/database_helper.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2012-08-03 23:26	tim44202	New Issue
2012-08-03 23:49	Mazi	Note Added: 20177
2012-08-03 23:49	Mazi	Assigned To	=> c_schmitz
2012-08-03 23:49	Mazi	Status	new => feedback
2012-08-05 18:38	c_schmitz	Note Added: 20208
2012-08-06 11:23	c_schmitz	Note Edited: 20208	View Revisions
2012-08-06 11:23	c_schmitz	Note Added: 20218
2012-08-06 15:05	tim44202	Note Added: 20226
2012-08-06 15:05	tim44202	Status	feedback => assigned
2012-08-06 15:06	c_schmitz	Note Added: 20227
2012-08-06 15:06	c_schmitz	Status	assigned => feedback
2012-08-06 15:30	tim44202	Note Added: 20228
2012-08-06 15:30	tim44202	Status	feedback => assigned
2012-08-06 20:58	c_schmitz	Note Added: 20233
2012-08-06 21:00	c_schmitz	Note Edited: 20233	View Revisions
2012-08-06 21:26	tim44202	Note Added: 20234
2012-08-07 20:47	c_schmitz	Changeset attached	=> LimeSurvey Yii 2401db5a
2012-08-07 20:47	c_schmitz	Note Added: 20254
2012-08-07 20:47	c_schmitz	Resolution	open => fixed
2012-08-07 20:47	c_schmitz	Changeset attached	=> LimeSurvey master 9f131938
2012-08-07 20:47	c_schmitz	Note Added: 20255
2012-08-07 20:47	c_schmitz	Note Added: 20256
2012-08-07 20:48	c_schmitz	Status	assigned => resolved
2012-08-07 20:48	c_schmitz	Fixed in Version	=> 1.92+
2012-08-08 13:55	c_schmitz	Status	resolved => closed

Notes
(20177) Mazi (developer) 2012-08-03 23:49	I can reproduce the problem following the steps described above. Can you attach the DB backup which was created prior to the update (should be located at /tmp?! We can mark this ticket private so only developers will be able to access the file. From which version did you update?

(20208) c_schmitz (administrator) 2012-08-05 18:38 edited on: 2012-08-06 11:23	Which DB driver are you using in config.php? mssql_n, mssql_odbc or mssqlnative ?

(20218) c_schmitz (administrator) 2012-08-06 11:23	?

(20226) tim44202 (reporter) 2012-08-06 15:05	ODBC Support enabled Active Persistent Links 0 Active Links 1 ODBC library Win32

(20227) c_schmitz (administrator) 2012-08-06 15:06	I am sorry, that's not the answer to my question. Can you please re-read?

(20228) tim44202 (reporter) 2012-08-06 15:30	Sorry is this what you wanted? $databasetype = 'odbc_mssql'; $databaselocation = 'SQL02'; $databasename = 'limesurvey'

(20233) c_schmitz (administrator) 2012-08-06 20:58 edited on: 2012-08-06 21:00	Yes, thank you. I will retest the upgrade and let you know. The quickfix for you is to add a field 'lastpage' of type 'int' to every survey_<surveyID> table. Ideally the upgrade should have done this for you. Did you maybe upgrade with too tight security settings? You should have received lots of errors during DB upgrade, though. Maybe you can restore the original database and try to assign root permissions to the LimeSurvey DB user, then run the upgrade again. Because if this has failed more stuff may have failed.

(20234) tim44202 (reporter) 2012-08-06 21:26	The workaround cured the problem. I just noticed that only one of the two Limesurvey websites has this problem. Perhaps one of the updates altered the db and it was skipped and or failed on one of them.

(20254) c_schmitz (administrator) 2012-08-07 20:47	Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9262 [^]

(20255) c_schmitz (administrator) 2012-08-07 20:47	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9263 [^]

(20256) c_schmitz (administrator) 2012-08-07 20:47	It was indeed an error in the update script. Thank you for bringing this to our attention.

Relationships