As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

User talk:Malafaya/Removed options causing problems

From OmegaWiki
< User talk:Malafaya
Revision as of 17:17, 21 August 2009 by Kipcool (talk | contribs) (What the real world option is)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

What the real world option is[edit]

Hi, I looked a bit into the sql database.

For the last error you corrected

update uw_option_attribute_values set remove_transaction_id=317785 where option_id=420234;

it seems possible to know the real world option corresponding to this by

select * from uw_option_attribute_options where option_id=420234 ;

this gives option_mid=5612, i.e. DefinedMeaning:noun_(5612) and language_id=136, apparently "English (United Kingdom)". --Kipcool 11:49, 27 April 2009 (EDT)

I went more deeply into the code User:Kipcool/From DefinedMeaning to attributes
in your last exemple you have option_id=420235
the query SELECT * FROM uw_option_attribute_options where option_id=420235 ;
gives attribute_id=409106, which can then be understood with
SELECT * FROM uw_class_attributes WHERE object_id=409106 ;
giving attribute_mid=358760 which is the DM number for part of speech. --Kipcool 16:17, 21 August 2009 (UTC)