Hello,

From time to time, my website host changes the MySQL version.
I have to rerun the setup.

After redoing the setup and putting the site back online, some of my VR album titles were replaced by
"charset = Ascii {"info":{"gyro_stabilized":true,"initial_view_changed":fal "
Some images keep their titles.

The involved album contains copies of images from other albums (for pc or smartphones)
I would like to understand why and how to prevent this in the future.

No idea where this comes from. Actually re-running setup should not change data…

That is a Js/json array apparently and it looks as if this comes from some image metadata perhaps?

Problem comes from metadata:

adminedit.php, Metadata section shows :

Modèle d’appareil: insta360 oners
Titre de l’image: IMG_20230914_162848_00_492.insp
Date et heure de la prise de vue: 09/15/2023 16:46
Date et heure originale de la prise de vue: 09/14/2023 16:28

IMG_20230914_162848_00_492.insp is the name that replaces the title, in french only, english and german titiles are emptied.

Description, tags, codeblocks are kept (no change.)
Only some titles.
Only in my VR album. VR cameras (insta )

Encoding problem ? metadata from my camera ?
I do not know.

If I erase all exif data in my localhost VR album images,
Then I replace those images online,
will I keep my titles, description, or will zenphoto think they are new images ?

Only some titles.
Only in my VR album. VR cameras (insta )

Hm, did/can you look at the metadata titles of these albums? Do they store anything unusal as the title?

Maybe try to refresh the metadata on one problematic image manually and see what happens then.

Also please look at Options > Image > Metadata refresh behaviour there you can generally prevent updates on title+description or all metadata (as tags could be involved, too). That had been added quite a while ago as you might want to refresh without loosing the main fields usually edited manually after importing.

I still don't know why this should be updated via setup run… I could only imagine some file/folder permission issues and problems to read images somehow so they are always re-read.

If I erase all exif data in my localhost VR album images,
Then I replace those images online,
will I keep my titles, description, or will zenphoto think they are new images ?

As long as you directly overwrite the files with the same named files Zenphoto should not consider them new because they are already in the database. To be on the sure side do this step by step. Just in case…

Also be sure to close your site for visitors during that as there is always a tiny moment the image is missing and if someone or bot catches that it might fail.

I did try the Metadata refresh utility on my localhost machine : I loose the same titles
I always manually enter new titles with the edit page
Those titles were also lost when O2switch upgraded the version of Mysqli needing a Zenphoto setup.

I do not use Metadata.
Maybe I need to deactivate the metadata plugin.
How can I do this ?

If it is requested by Zenphoto, I should not loose the titles I have manually entered

here is an image :

Custom data:

English (United States)

Location:

English (United States)

City:

English (United States)

State:

English (United States)

Country:

English (United States)

Credit:

English (United States)

Copyright:

English (United States)

Metadata:

Camera Maker: Insta360
Camera Model: Insta360 Pro2
Image Title: charset = Ascii {"info":{"gyro_stabilized":false,"initial_view_changed":false}}
Date and Time Taken: 05/24/2024 18:16
Copyright Holder: D Ratel
Shutter Speed: 1/2427 sec
Aperture: f/2.4
ISO Sensitivity: 100
Exposure Compensation: 0 EV
Original Width: 300 px
Original Height: 169 px
Orientation: 1 : Horizontal (normal)
Software: GIMP 2.10.38
Latitude: 48.354420833333
Latitude Reference: N
Longitude: 5.6886186111111
Longitude Reference: E
Altitude: 284 m

The title was :
Bazoilles, grotte de la roche aux fées / Bazoilles, cave, fairy Rock / Bazoilles, Höhle, Feenfelse

After metadata plugin action (or runing setup), french title became
charset = Ascii {"info":{"gyro_stabilized":false,"initial_view_changed":false}}

No english and no german title.

Here is a metadata from an image that does not change the title :

Metadata:

Date and Time Taken: 05/17/2019 10:50
Copyright Holder: D Ratel
Original Width: 300 px
Original Height: 169 px
Software: GIMP 2.10.10

There is no title in this Metadata !
The Metadata utility did not change that title !

This answer is a bit long, but I think my camera gives wrong metadata titles !

Those titles were also lost when O2switch upgraded the version of Mysqli needing a Zenphoto setup.

This should not be happening! MySQLi is just the PHP library handler and not the database itself. But encoding mismatches can always result in "funny" results…

The Metadata utility did not change that title !
Okay, good to hear that you are sure its not a bug from our side.

This answer is a bit long, but I think my camera gives wrong metadata titles !

That might indeed be or it did store them wrong due to an error (A camera nowadays is just a computer …). We had in the past (more often) that some cameras did some "creative usages" of the more or less existing EXIF/IPTC standards.

We have a process what to use for the title as described here:
https://www.zenphoto.org/news/zenphoto-image-metadata-processing/
But what you see seems really be off… I guess if you edit the file itself and add a proper title it should work.

If you get comments via mail notification and still read this, please note that we will close the forum temporarily (see the news on the site).

Your new forum is really nice, well done.

Here's how I fixed the problem:

1. Website taken offline
2. Removing exif data from photos taken with my insta360 cameras
3. phpMyAdmin query:
   UPDATE zp_images SET EXIFDescription = NULL;
   
   4.Tests (setup, refresh metadata)
4. Website restored

Conclusion: Too many specific characters in the EXIF ​​data of some cameras. This conflicts with certain Zenphoto functions!

Note : I cannot format the phpmyadmin query correctly with tabs or code> or blockquote>

Your new forum is really nice, well done.

Thanks!

Glad you were able to find a workaround. Do you have any indication what characters that were and is there anything we can try to fix?

Note : I cannot format the phpmyadmin query correctly with tabs or code> or blockquote>

It looks a bit formatted to me. The markdown support is an own plugin solution as we didn't want to use the default MyCode/bbCode formatting, also for compatibility of all the old posts.

You can technically use four spaces or for inline code backticks. They appear in red at least but somehow not inline and code blocks seem to lack stylig alltogether. We'll see if we can somehow fix something here.

Made some styling additions, inline code is now inline and blue and clode blocks generally work as well. But you have to put four spaces before each line.

Some code block 
Some code block 

For multiline blocks using three backticks before and after the block works:

Some code block 
Some code block 

charset = Ascii {"info":{"gyro_stabilized":false,"initial_view_changed":false}}

creates the problem

That indeed looks really like a camera mistake.