https://bugzilla.wikimedia.org/show_bug.cgi?id=26999

           Summary: Reflect extension DB setup fails
           Product: MediaWiki extensions
           Version: any
          Platform: All
               URL: http://www.mediawiki.org/wiki/Extension:Reflect
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: [other]
        AssignedTo: wikibugs-l@lists.wikimedia.org
        ReportedBy: br...@pobox.com


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.)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to