ZenphotoCMS Forum
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 getImageMetaData() function and retrieve all necessary metadata information.




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 hasMedadata (with a d) and the second one is hasMetadata (with a t). so i guess queries are not fooled and my db is not screwed. now i'm just wondering what is the hasMedadata field for ?




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: hasMedadata int(1) DEFAULT 0,

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.