View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
04841Bug reportsInstallationpublic2011-01-07 20:44
Reporteruser11360Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.91RC1 
Summary04841: Postgres installation fails on AUTO_INCREMENT
Description

admin/install/create-postgres.sql contains an AUTO_INCREMENT; as far as I know, postgres doesn't support it.

Steps To Reproduce

sudo php /usr/share/limesurvey/admin/install.done/cmd_install.php install

Additional Information

Working on packaging this up for debian/ubuntu, so it's possible I've screwed something else up as well.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)9343
I will donate to the project if issue is resolvedNo
Browsern/a
Database type & versionpostgres (8.4.5)
Server OS (if known)Ubuntu Linux 10.10
Webserver software & version (if known)Apache2
PHP VersionPHP 5.3.3-1ubuntu9.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

user11360

2011-01-02 19:12

  ~13837

Executing.....CREATE TABLE lime_failed_login_attempts ( id integer NOT NULL AUTO_INCREMENT, ip character varying(37) NOT NULL, last_attempt character varying(20) NOT NULL, number_attempts integer NOT NULL)...Failed! Reason:
ERROR: syntax error at or near "AUTO_INCREMENT"
LINE 1: ...lime_failed_login_attempts ( id integer NOT NULL AUTO_INCRE...

The rest appears to have succeeded.

user11360

2011-01-02 19:23

  ~13838

And as a result, the admin pages fail:
SELECT FROM "lime_failed_login_attempts" WHERE ip='192.168.1.1';
ERROR: relation "lime_failed_login_attempts" does not exist LINE 1: SELECT
FROM "lime_failed_login_attempts" WHERE ip='192.168.... ^

(ip altered)

user11360

2011-01-03 05:28

  ~13839

http://stackoverflow.com/questions/787722/postgresql-autoincrement/787774#787774 suggests SERIAL as a workaround.

Issue History

Date Modified Username Field Change
2011-01-02 19:06 user11360 New Issue
2011-01-02 19:12 user11360 Note Added: 13837
2011-01-02 19:23 user11360 Note Added: 13838
2011-01-03 05:28 user11360 Note Added: 13839
2011-01-03 05:34 user11360 Issue Monitored: user11360
2011-01-03 05:34 user11360 Issue End Monitor: user11360
2011-01-03 05:34 user11360 Issue Monitored: user11360
2011-01-03 20:56 c_schmitz Status new => resolved
2011-01-03 20:56 c_schmitz Fixed in Version => 1.91RC1
2011-01-03 20:56 c_schmitz Resolution open => fixed
2011-01-03 20:56 c_schmitz Assigned To => c_schmitz
2011-01-07 20:44 c_schmitz Status resolved => closed