View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04841 | Bug reports | Installation | public | 2011-01-02 19:06 | 2011-01-07 20:44 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.90+ | ||||
Fixed in Version | 1.91RC1 | ||||
Summary | 04841: 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. | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 9343 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | n/a | ||||
Database type & version | postgres (8.4.5) | ||||
Server OS (if known) | Ubuntu Linux 10.10 | ||||
Webserver software & version (if known) | Apache2 | ||||
PHP Version | PHP 5.3.3-1ubuntu9.1 | ||||
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: The rest appears to have succeeded. |
|
And as a result, the admin pages fail: (ip altered) |
|
http://stackoverflow.com/questions/787722/postgresql-autoincrement/787774#787774 suggests SERIAL as a workaround. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2011-01-02 19:06 |
|
New Issue | |
2011-01-02 19:12 |
|
Note Added: 13837 | |
2011-01-02 19:23 |
|
Note Added: 13838 | |
2011-01-03 05:28 |
|
Note Added: 13839 | |
2011-01-03 05:34 |
|
Issue Monitored: user11360 | |
2011-01-03 05:34 |
|
Issue End Monitor: user11360 | |
2011-01-03 05:34 |
|
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 |