[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #10 from Joerg mueller062001-...@yahoo.de 2012-01-08 22:43:38 UTC --- Created attachment 9824 -- https://bugzilla.wikimedia.org/attachment.cgi?id=9824 Output of mysqldump --no-data Attached is the DB structure, which I got with mysqldump --nodata Only 19 tables do have a primary key. And I don't know, if these are how they should be). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #7 from Joerg mueller062001-...@yahoo.de 2012-01-04 23:45:02 UTC --- Yes, that is quite likely. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #8 from Reedy s...@reedyboy.net 2012-01-04 23:58:42 UTC --- John, as you assigned this to yourself, are you likely to get round to it any time soon? Might be nice to get it in 1.19/1.18.1, finally! -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #9 from Reedy s...@reedyboy.net 2012-01-05 00:56:44 UTC --- (In reply to comment #7) Yes, that is quite likely. Any chance you could do a dump of your database schema layout? Gives a slightly nicer working point, rather than a list of old (now somewhat renamed) tables SHOW CREATE TABLE tablename; mysql show create table user\G *** 1. row *** Table: user Create Table: CREATE TABLE `user` ( `user_id` int(5) unsigned NOT NULL AUTO_INCREMENT, `user_name` varbinary(255) NOT NULL DEFAULT '', `user_real_name` varbinary(255) NOT NULL DEFAULT '', `user_password` tinyblob NOT NULL, `user_newpassword` tinyblob NOT NULL, `user_email` tinyblob NOT NULL, `user_options` blob NOT NULL, `user_touched` varbinary(14) NOT NULL DEFAULT '', `user_token` varbinary(32) NOT NULL DEFAULT '', `user_email_authenticated` varbinary(14) DEFAULT NULL, `user_email_token` varbinary(32) DEFAULT NULL, `user_email_token_expires` varbinary(14) DEFAULT NULL, `user_registration` varbinary(14) DEFAULT NULL, `user_newpass_time` varbinary(14) DEFAULT NULL, `user_editcount` int(11) DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`), KEY `user_email_token` (`user_email_token`) ) ENGINE=InnoDB AUTO_INCREMENT=16029390 DEFAULT CHARSET=binary 1 row in set (0.00 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 Mark A. Hershberger m...@everybody.org changed: What|Removed |Added Priority|Unprioritized |Low -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #5 from Joerg mueller062001-...@yahoo.de 2011-12-18 16:22:27 UTC --- It surely used MW 1.4 and maybe also an earlier version. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #6 from John Du Hart j...@compwhizii.net 2011-12-18 17:46:42 UTC --- Given that the earliest database entry was May 2004 it was probably 1.2 or 1.3 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 John Du Hart j...@compwhizii.net changed: What|Removed |Added Status|NEW |ASSIGNED CC||j...@compwhizii.net AssignedTo|wikibugs-l@lists.wikimedia. |j...@compwhizii.net |org | --- Comment #1 from John Du Hart j...@compwhizii.net 2011-12-17 21:40:31 UTC --- Issue is likely due to r5210, user_id was converted to a PRIMARY KEY but a patch was never made. -- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #2 from Joerg mueller062001-...@yahoo.de 2011-12-17 22:44:19 UTC --- The problem is also present for a number of other tables as well, for example cur, math, text, user_rights or watchlist. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 --- Comment #3 from Reedy s...@reedyboy.net 2011-12-18 00:23:41 UTC --- (In reply to comment #2) The problem is also present for a number of other tables as well, for example cur, math, text, user_rights or watchlist. Of course, math is now in an extension -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 33228] User table misses Primary Key
https://bugzilla.wikimedia.org/show_bug.cgi?id=33228 Reedy s...@reedyboy.net changed: What|Removed |Added CC||s...@reedyboy.net --- Comment #4 from Reedy s...@reedyboy.net 2011-12-18 01:33:10 UTC --- What version was that wiki installed at? Out of interest... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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