![]() |
|
images table in database - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: images table in database (/thread-8241.html) |
images table in database - frankm - 2011-02-13 hi, i was just looking at the database and it appears that there are two fields called 'hasMetadata' in the images table. all my images have metadata. with that the first field has always a value of 0 and the second field has a value of 1. is that just my database that has been screwed somewhat or is it just normal ? with that said, in context ZP_IMAGE, i can call the images table in database - sbillard - 2011-02-13 I really do not know how a database can have two identical table fields. Certainly there should be only one. Given that there are two, queries could be "fooled". But fortunately I think we only retrieve this field with a general all fields query, so I guess the two get somehow merged. Anyway, I would say your database is screwed up. Mine has only one such field (which is as it should be.) images table in database - frankm - 2011-02-13 my mistake... the two fields really have two very similar but different names. the first one is called images table in database - sbillard - 2011-02-14 Good question. Not a field that we have now. Maybe for "health care" data images table in database - frankm - 2011-02-14 looks like the field is created and never used. i "grepped" it on the latest nightly build and here is the output: setup.php:1618: nothing is really done after that so it is not a big issue. images table in database - acrylian - 2011-02-14 Could be a sneaked in typo... images table in database - sbillard - 2011-02-14 Ok, that was a typo. You can delete the field. Fortunately the upgrade process made sure the proper field was there. |