Bug #614
Install fails with PostgreSQL on trunk (1.6)
| Status: | Rejected | Start date: | 12/23/2009 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 100% |
|
| Category: | - | |||
| Target version: | - | |||
| Reproducibility: | Always | Database Type: | PostgreSQL | |
| Reported In MyBB Version: | 1.6.0 | Database Version: | 8.4.2 | |
| PHP Version: | SQA assignments: | |||
| Browser: |
Description
When trying to install a fresh copy of the trunk (1.6) with the PostgreSQL engine, it fails at the Table Creation stage with a SQL error:
Creating table mybb_datacache...done
Creating table mybb_delayedmoderation...
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
42601 - ERROR: syntax error at or near "auto_increment" LINE 2: did int NOT NULL auto_increment, ^
Query:
CREATE TABLE mybb_delayedmoderation ( did int NOT NULL auto_increment, type varchar(30) NOT NULL default '', delay int NOT NULL default '0', uid int NOT NULL default '0', fid smallint NOT NULL default '0', tids text NOT NULL, dateline bigint NOT NULL default '0', inputs text NOT NULL default '', PRIMARY KEY (did) );
Associated revisions
Fixes Install fails on PostgreSQL on trunk (fixes:614)
History
#1 Updated by Tom Moore over 2 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Applied in changeset r4646.
#2 Updated by Chris W. B. over 2 years ago
- Status changed from Resolved to Closed
#3 Updated by Ryan Gordon over 2 years ago
The fix is bad. should be serial and should also be applied to the upgrade scripts.
Chris, this ticket was submitted on a WIP feature (the delayed moderation feature). Please don't create completely separate bug reports on WIP features, they should stay with the feature itself. This is because the developer of the feature knows what to change, the other developers don't.
#4 Updated by Ryan Gordon over 2 years ago
- Status changed from Closed to Rejected
#5 Updated by Chris W. B. over 2 years ago
Sorry, will do in future.
Chris