Page MenuHomePhabricator

[Reflect] DB setup fails
Closed, DeclinedPublic

Description

As of r81113

Following install directions at http://www.mediawiki.org/wiki/Extension:Reflect

$ php maintenance/sql.php extensions/Reflect/reflect.sql
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: CREATE TABLE reflect_bullet_current (
blc_id mediumint(9) NOT NULL AUTO_INCREMENT,
bl_id mediumint(9),
comment_id mediumint(9),
bl_rev_id mediumint(9),
PRIMARY KEY blc_id (blc_id),
FOREIGN KEY (comment_id) REFERENCES comments(comment_ID) ON DELETE SET NULL ON UPDATE CASCADE,
FOREIGN KEY (bl_id) REFERENCES reflect_bullets_revision(bl_id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (bl_rev_id) REFERENCES reflect_bullets_revision(bl_rev_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB, DEFAULT CHARSET=binary

Function: DatabaseBase::sourceStream
Error: 1005 Can't create table 'wikidb.reflect_bullet_current' (errno: 150) (localhost)

$ perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed

May be related to the non-existence of a reflect_bullets_revision table. (There is a reflect_bullet_revision defined, but it's not defined yet when reflect_bullet_current is created, and it's spelled differently.)


Version: unspecified
Severity: normal
Whiteboard: extension[unmaintained]
URL: http://www.mediawiki.org/wiki/Extension:Reflect

Details

Reference
bz26999

Event Timeline

bzimport raised the priority of this task from to Lowest.Nov 21 2014, 11:15 PM
bzimport set Reference to bz26999.
bzimport added a subscriber: Unknown Object (MLST).

Homepage of author seems to be down too.
Candidate to close, together with updating the extension homepage.

The extension has be migrated to git.