Difference between revisions of "Talk:WikiDB/Tables"

Revision as of 06:30, 16 February 2007

Just going through the setup here. Not sure what Key - MUL refers to. I guess 'mutual' from a Google search but I don't see this in phpmyadmin.

Also, not sure how to setup the indexes but haven't quite gotten to that yet. Blckdmnd99 18:16, 1 October 2006 (BST)

Hi! I originally set this page up as a way to get feedback on the schema, and have not officially released the extension yet, as it is still very much in an alpha stage of development. Ultimately I will include a .sql file that does the update for you. In the meantime feel free to recreate the tables from this definition if you like. However, two caveats: (1) the schema may change as the extension develops and change may be incompatible with the current version, and (2) I cannot be held responsible for any problems or damage that may arise from using this pre-release software... standard disclaimer, etc. :)

Anyway, in answer to your questions, I believe MUL means that it is used in multiple index, or possibly that it is part of a multi-field index. Either way, that is not very important regarding the setup of the tables. Ditto indexes - you can safely omit these (apart from the primary key). Their purpose is to speed up queries, so without them everything will work fine, but possibly slightly slower. Given that the code is horribly unoptimised at the moment, it's probably no big deal...

I would appreciate any feedback you have from using the extension - let me know how you get on! --HappyDog 18:31, 1 October 2006 (BST)

Thanks for the disclaimer... certainly understandable! :) Glad to hear about the tables. I'll offer my thoughts as best I can... feel free to disregard any of my ramblings! Blckdmnd99 19:19, 1 October 2006 (BST)

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)

Hi, I am trying to create the tables but cannot work through. I user 2.27 MySql and get error of "MySQL error number 1064. You have an error in you sql syntax. I used the Mysql administrator so the sql query to create table is automatically generated. Do you know what is wrong? Thanks! Jim