Difference between revisions of "Talk:WikiDB/Tables"

From TestWiki
Jump to: navigation, search
(Archived old stuff. Note about update.)
(Bug reports moved to 'Bugs' page.)
 
(4 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
== Field too long ==
 
== Field too long ==
  
−
wikidb_fielddata
+
Moved to [[WikiDB/Bugs#Field too long]].
−
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. --[[User:HappyDog|HappyDog]] 23:54, 5 January 2007 (GMT)
+
== SQL error when creating tables ==
 +
 
 +
Moved to [[WikiDB/Bugs#SQL error when creating tables]].

Latest revision as of 21:35, 7 February 2022

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[edit]

Moved to WikiDB/Bugs#Field too long.

SQL error when creating tables[edit]

Moved to WikiDB/Bugs#SQL error when creating tables.

Retrieved from ‘https://kennel17.co.uk/testwiki/index.php?title=Talk:WikiDB/Tables&oldid=19293’