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

Dmitriy <c...@uniyar.ac.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |

--- Comment #8 from Dmitriy <c...@uniyar.ac.ru> 2010-11-03 20:14:24 UTC ---
Aryeh, I've decided not to open new bug but reopen this one instead, because in
r75939 with MyISAM utf8 tables 'php update.php' gave me another "key too long"
message (this time in Windows, but that probably makes no difference):
.........
Fixing collation for 11510 rows.
1000 done.
2000 done.
3000 done.
4000 done.
5000 done.
6000 done.
7000 done.
8000 done.
9000 done.
10000 done.
11000 done.
11491 done.
Creating msg_resource table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE UNIQUE INDEX mrl_message_resource ON `wiki_msg_resource_links`
(mrl_mess
age, mrl_resource)
"
from within function "DatabaseBase::sourceFile(
C:\www\phase3/maintenance/archiv
es/patch-msg_resource.sql )".
Database returned error "1071: Specified key was too long; max key length is
100
0 bytes (127.0.0.1)"

SHOW CREATE TABLE gives the following output:
CREATE TABLE `wiki_msg_resource_links` (
  `mrl_resource` varchar(255) NOT NULL,
  `mrl_message` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8

I still haven't tried to correct the length of fields manually, so I don't know
if that is a last error of such kind. I hope so.

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

Reply via email to