[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #14 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-11-07 17:36:43 UTC --- Dmitriy, does it work now? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because:

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #15 from Dmitriy c...@uniyar.ac.ru 2010-11-08 07:05:19 UTC --- Aryeh, yes, I've re-imported old 1.15 sql dump, updated local trunk, and re-run php update.php and it seems to work fine. Thank you, Roan. Next time, if I'll spot the

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 Roan Kattouw roan.katt...@gmail.com changed: What|Removed |Added CC|

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #11 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-11-05 20:42:54 UTC --- It's 1000 bytes total at three bytes per characters, so you've got 333 characters total for the two columns. Alternatively, you could make them

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #12 from Roan Kattouw roan.katt...@gmail.com 2010-11-05 22:07:53 UTC --- (In reply to comment #11) It's 1000 bytes total at three bytes per characters, so you've got 333 characters total for the two columns. Alternatively, you

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #13 from Roan Kattouw roan.katt...@gmail.com 2010-11-05 22:16:36 UTC --- (In reply to comment #12) varbinary sounds good, I'll do that Done in r76150. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added Status|REOPENED|RESOLVED

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #5 from Dmitriy c...@uniyar.ac.ru 2010-10-14 10:41:27 UTC --- Please post the output of SHOW CREATE TABLE wiki_categorylinks\G. I have a guess as to how this could happen, but would like to confirm it. Here's the output: CREATE

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #7 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-10-14 21:47:51 UTC --- (and thanks to Max for CC'ing me) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #3 from Dmitriy c...@uniyar.ac.ru 2010-10-13 08:57:51 UTC --- Created attachment 7731 -- https://bugzilla.wikimedia.org/attachment.cgi?id=7731 Fixes index of categorylinks of 1.17 schema in myisam mode -- Configure bugmail:

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added CC|

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 --- Comment #1 from Dmitriy c...@uniyar.ac.ru 2010-10-12 18:30:36 UTC --- By the way, that wiki was happily going 1.12 to 1.14 then to 1.15 (in myisam mode) and I don't recall such errors while running update.php (hope my memory is not too

[Bug 25503] Specified key was too long error in update.php script while altering categorylinks table which has myisam engine

https://bugzilla.wikimedia.org/show_bug.cgi?id=25503 Max Semenik maxsem.w...@gmail.com changed: What|Removed |Added AssignedTo|wikibug...@lists.wikimedia.