View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04028 | Bug reports | Installation | public | 2010-01-02 16:21 | 2010-01-27 22:46 |
Reporter | Assigned To | gandalfar | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87RC5 | ||||
Fixed in Version | 1.90b | ||||
Summary | 04028: 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 ^ ==== Location of the bug ==== the bug is in admin/update/upgrade-postgres.php lines 182-183: ==== Correction ==== The proper PostgreSQL syntax would be : ALTER TABLE prefix_surveys ALTER COLUMN "startdate" TYPE timestamp; | ||||
Additional Information | Thanks for this great software ! | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | |||||
I will donate to the project if issue is resolved | |||||
Browser | any | ||||
Database type & version | PostgreSQL 8.3.9 | ||||
Server OS (if known) | Debian Lenny | ||||
Webserver software & version (if known) | Apache/2.2.9 | ||||
PHP Version | 5.2.6 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2010-01-02 16:21 |
|
New Issue | |
2010-01-02 16:21 |
|
Status | new => assigned |
2010-01-02 16:21 |
|
Assigned To | => user372 |
2010-01-02 16:21 |
|
Browser | => any |
2010-01-02 16:21 |
|
Database & DB-Version | => PostgreSQL 8.3.9 |
2010-01-02 16:21 |
|
Operating System (Server) | => Debian Lenny |
2010-01-02 16:21 |
|
Webserver | => Apache/2.2.9 |
2010-01-02 16:21 |
|
PHP Version | => 5.2.6 |
2010-01-03 19:48 |
|
Assigned To | user372 => rakete |
2010-01-05 21:50 |
|
Issue Monitored: gandalfar | |
2010-01-12 22:13 |
|
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 |