Bug #614

Install fails with PostgreSQL on trunk (1.6)

Added by Chris W. B. over 2 years ago. Updated over 2 years ago.

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

Revision 4646
Added by Tom Moore over 2 years ago

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

Also available in: Atom PDF