INSTALL DB: duplicate column name error

Bug #887891 reported by mcsooks
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
metadatagames
Fix Committed
Critical
Vincent Van Uffelen

Bug Description

When I tried setting up a new database and importing mg.mysql.0.8.2.sql, I get the following error:

Error

SQL query:

CREATE TABLE IF NOT EXISTS `game_submission` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`submission` TEXT NOT NULL ,
`turn` INT( 11 ) NOT NULL DEFAULT 0,
`session_id` INT( 11 ) NOT NULL ,
`played_game_id` INT( 11 ) NOT NULL ,
`turn` DATETIME NULL ,
PRIMARY KEY ( `id` ) ,
CONSTRAINT `fk_game_submissions_sessions1` FOREIGN KEY ( `session_id` ) REFERENCES `session` ( `id` ) ON DELETE CASCADE ON UPDATE NO ACTION ,
CONSTRAINT `fk_game_submissions_played_games1` FOREIGN KEY ( `played_game_id` ) REFERENCES `played_game` ( `id` ) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE = InnoDB;

MySQL said: Documentation
#1060 - Duplicate column name 'turn'

Revision history for this message
mcsooks (sukie88) wrote :
Revision history for this message
Vincent Van Uffelen (novazembla) wrote :

fix commited. sha1: aea44d0fc7a04b5210cc92ebaa4fdcaf7480ee2e

mcsooks (sukie88)
Changed in metadatagames:
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.