View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04028Bug reportsInstallationpublic2010-01-27 22:46
Reporteruser5992Assigned Togandalfar  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.87RC5 
Fixed in Version1.90b 
Summary04028: PostgreSQL syntax errors while upgrading from 1.80 to 1.87
Description

==== Errors ====

when calling http://enquetes.postgresql.fr//admin/install/index.php

i got the following errors :

Executing.....ALTER TABLE lime_surveys ALTER COLUMN "startdate" timestamp...Failed! Reason: ERROR: syntax error at or near "timestamp" LINE 1: ALTER TABLE lime_surveys ALTER COLUMN "startdate" timestamp ^
Executing.....ALTER TABLE lime_surveys ALTER COLUMN "expires" timestamp...Failed! Reason: ERROR: syntax error at or near "timestamp" LINE 1: ALTER TABLE lime_surveys ALTER COLUMN "expires" timestamp ^

==== Location of the bug ====

the bug is in admin/update/upgrade-postgres.php lines 182-183:
modify_database("", "ALTER TABLE prefix_surveys ALTER COLUMN \"startdate\" timestamp"); echo $modifyoutput; flush();
modify_database("", "ALTER TABLE prefix_surveys ALTER COLUMN \"expires\" timestamp"); echo $modifyoutput; flush();

==== Correction ====

The proper PostgreSQL syntax would be :

ALTER TABLE prefix_surveys ALTER COLUMN "startdate" TYPE timestamp;
ALTER TABLE prefix_surveys ALTER COLUMN "expires" TYPE timestamp;

Additional Information

Thanks for this great software !

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browserany
Database type & versionPostgreSQL 8.3.9
Server OS (if known)Debian Lenny
Webserver software & version (if known)Apache/2.2.9
PHP Version5.2.6

Users monitoring this issue

gandalfar

Activities

gandalfar

gandalfar

2010-01-24 22:18

reporter   ~10869

Thanks, I've applied this fix to dev tree

Issue History

Date Modified Username Field Change
2010-01-02 16:21 user5992 New Issue
2010-01-02 16:21 user5992 Status new => assigned
2010-01-02 16:21 user5992 Assigned To => user372
2010-01-02 16:21 user5992 Browser => any
2010-01-02 16:21 user5992 Database & DB-Version => PostgreSQL 8.3.9
2010-01-02 16:21 user5992 Operating System (Server) => Debian Lenny
2010-01-02 16:21 user5992 Webserver => Apache/2.2.9
2010-01-02 16:21 user5992 PHP Version => 5.2.6
2010-01-03 19:48 user372 Assigned To user372 => rakete
2010-01-05 21:50 user372 Issue Monitored: gandalfar
2010-01-12 22:13 user372 Assigned To rakete => gandalfar
2010-01-24 22:18 gandalfar Note Added: 10869
2010-01-24 22:18 gandalfar Status assigned => resolved
2010-01-24 22:18 gandalfar Fixed in Version => 1.90b
2010-01-24 22:18 gandalfar Resolution open => fixed
2010-01-27 22:46 c_schmitz Status resolved => closed