View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
20308Bug reportsDatabase designpublic2025-10-17 09:312025-10-17 16:33
Reportermferraz Assigned Tolajosarpad  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version6.6.x 
Summary20308: CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "NOT" LINE 1:
Description

Hi,
During the last database upgrade, on the last update, I get this:

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

CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "NOT" LINE 1: ...surveys" ALTER COLUMN "lastmodified" TYPE timestamp NOT NULL ^

File updatedb_helper.php, line 2815.

Steps To Reproduce

Steps to reproduce

Try a database upgrade on PostgreSQL installation

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build) 6.15.18+251016
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 15+248
Server OS (if known)
Webserver software & version (if known)
PHP Version8.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

lajosarpad

lajosarpad

2025-10-17 16:28

developer   ~83601

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=39105
c_schmitz

c_schmitz

2025-10-17 16:32

administrator   ~83602

To get your instance to work again, just fix this line in ‎application/helpers/update/updates/Update_638.php

https://github.com/LimeSurvey/LimeSurvey/commit/deb9fa7547234068749acdb96412d91f9924a169#diff-211ddf0475bc4662f4a41220933aaee85f27c04a4f9aa41f26b4d4b77f311e13L22
LimeBot

LimeBot

2025-10-17 16:33

administrator   ~83603

Fixed in Release 6.15.19+251017

Related Changesets

LimeSurvey: master deb9fa75

2025-10-17 16:28

lajosarpad

Committer: GitHub


Details Diff		 Fixed issue 20308: Update bug with Postgres Affected Issues
20308
mod - application/helpers/update/updates/Update_638.php Diff File
mod - application/libraries/Api/Command/V1/SurveyDetail.php Diff File

Issue History

Date Modified Username Field Change
2025-10-17 09:31 mferraz New Issue
2025-10-17 16:28 lajosarpad Changeset attached => LimeSurvey master deb9fa75
2025-10-17 16:28 lajosarpad Note Added: 83601
2025-10-17 16:28 lajosarpad Assigned To => lajosarpad
2025-10-17 16:28 lajosarpad Status new => resolved
2025-10-17 16:28 lajosarpad Resolution open => fixed
2025-10-17 16:28 lajosarpad Bug heat 0 => 2
2025-10-17 16:32 c_schmitz Note Added: 83602
2025-10-17 16:32 c_schmitz Bug heat 2 => 4
2025-10-17 16:33 LimeBot Note Added: 83603
2025-10-17 16:33 LimeBot Status resolved => closed
2025-10-17 16:33 LimeBot Bug heat 4 => 6