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 | ||||
| Git branch / Pull Request URL | |||||
|
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 |