Talk:WikiDB/Tables

From TestWiki
< Talk:WikiDB
Revision as of 02:53, 6 July 2007 by HappyDog (Talk | contribs) (Archived old stuff. Note about update.)

Jump to: navigation, search

Most old comments have been archived[1]. They were largely questions regarding table creation, due to the fact that my WikiDebug extension used to just display an unwieldy table. Now the required SQL is displayed directly in the page, and the questions are no longer relevant (I think!).

Field too long

wikidb_fielddata 1071 - Specified key was too long. Max key length is 500 :(

I'm guessing that this error is occuring when you are creating the indexes in your local copy of the wikidb_fielddata table. This may be because the version of MySQL you are using is incompatible with my DB - I haven't tested on anything except 3.23.58. I'm guessing the binary fields require 2 bytes per character, and with a 255 character limit, that means a key of 510 bytes. Perhaps this is a config setting. Please let me know if you find a good fix for this, or if I am off the mark with my diagnosis, and thanks for taking the trouble to write. --HappyDog 23:54, 5 January 2007 (GMT)