tagged pictures are not saved

vincent3569

Hi

on 1.4.1.5, I have added a tag on 30 pictures (the tag is "portfolio").
with that, I have created a dynamic album to show my portfolio.

something goes wrong with that :
If I do a backup/restore of the database, I have only 20 pictures with this tag.

is this a known issue ?

acrylian

Is the database backup really from after you tagged 30 pictures? Otherwise this would make sense...:-)

vincent3569

hi

of couse, my backup is realy done with my 30 pictures :-)

I explain what I do
- I have 2 web site : a production one and a pre-production one (who is a copy of the 1st one), and one course, I am sure that all pictures are on the two website.
- I have 30 pictures tagged with "portfolio" on the 1st one
- I do a backup and I copy the zdb file on the 2nd one.
-> when I do the restore on the 2nd one, I have only 20 pictures tagged with "portfolio"

what the problem could be ?

acrylian

Just to ask, you did use our backup tool or something like phpmyadmin?

The only reason I could imagine this not matching would be that the albums (on filesystem) changed before re-importing the backup.

vincent3569

I have tried the backup tool and a dump of the base using phpmyadmin.
the result is still the same

As said before, I am sure of my albums (I have done a copy/paste of /albums from the 1st site to the 2nd site)

acrylian

Ok, sorry then I have no idea.

vincent3569

this sql statment
`
SELECT zp_images.id, zp_images.filename, zp_images.title, zp_albums.id, zp_albums.title, zp_tags.name
FROM zp_images, zp_albums, zp_obj_to_tag, zp_tags
WHERE (zp_images.albumid=zp_albums.id)and(zp_images.id=zp_obj_to_tag.objectid)and(zp_obj_to_tag.tagid=zp_tags.id)and(zp_tags.name='Portfolio')
`
give 30 pictures, on my web site
and gives 20 pictures, on my backup site

how verify if the db of my prod site is corrupted ?

sbillard

There may be some orphaned database entries. There is a problem in the 1.4.1 release that garbage collecting does not properly clear out orphaned tag entries.

Given your above SQL, I would presume that this is the issue. Clearly the two databases do not have the same content.

vincent3569

I do some tests with 1.4.2 :

I still have some tags wich are loosed during the migration.
These tags have been manualy added on pictures (they are not in exifs).

I explain my tests :
- I do a backup my database by using mySQL (the back up is correct and all the tags are presents in the export)
- I import my database via mySQL
- I immediatly check via SQL query that complete information can be found in the new database

after the setup, I still have complete information in the new database

when I'm navigate on images (on the visitors or the admin), the manualy added tags disappear.

=> after a fresh install with import of a database, is there a resync of metadata (maybe one representative pictures of albums) ?

In this case, this would explain the loss of tags that are not in the EXIF ??images.

sbillard

There is no explicit metadata refresh on upgrade. But if anything were out of sync with the database the images might appear to be "new".

So I did perform an upgrade from 1.4.1.6 to 1.4.2 RC3 and did not loose my manually applied tags. Must be something in your upgrade process.

vincent3569

I don't make an upgrate but I do a mirror site to backup my prod site.

when I do that with the process describe above (but it'is the same by using the database backup function of zenphoto), I lose the tags that were only in the database but not included in the EXIF ??of the photo.

But if anything were out of sync with the database the images might appear to be "new".

wich data could be out of synch (I do copy/paste of all pictures between two sites) ?

sbillard

If the site is different from the one where the database was made then the timestamps of the images are unlikely to match the timestamp in the database. Thus the images "new".