Piwigo.org

raupie · 2024-01-30 19:58:50

TLDR; Can you run `mediainfo <IMG>` and check for the creation date?

Is it every image or just specific images?

John R · 2024-01-30 19:58:54

I do use the plugin, but have it set to v4 as I prefer the way that looks.

raupie · 2024-01-30 20:01:28

The viewer options doesn't matter. I believe you and I have the same issue. Which is missing creation_date metadata from the file itself.

Are you trying to run a `Synchronise metadata` or generate thumbnails? What action in the UI is triggering the mysql error regarding invalid timestamp?

I believe the plugin doesn't fail gracefully enough for missing metadata. There must be required attributes it looks for.

John R · 2024-01-30 20:01:28

mediainfo 20240129011110-e5d21535.jpg
General
Complete name : 20240129011110-e5d21535.jpg
Format : JPEG
File size : 125 KiB

Image
Format : JPEG
Width : 768 pixels
Height : 1 024 pixels
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Compression mode : Lossy
Stream size : 125 KiB (100%)

raupie · 2024-01-30 20:02:57

Yeah. there you go. Probably no creation date.

Working:

```
mediainfo PXL_20240129_235202219.mp4 | grep date
Encoded date : 2024-01-29 23:52:16 UTC
Tagged date : 2024-01-29 23:52:16 UTC
Encoded date : 2024-01-29 23:52:16 UTC
Tagged date : 2024-01-29 23:52:16 UTC
Encoded date : 2024-01-29 23:52:16 UTC
Tagged date : 2024-01-29 23:52:16 UTC
```

Broken: "missing date"

```
mediainfo _T8424T1023160071_2024_01_19_17_20_20.mp4 | head -5
General
Complete name : _T8424T1023160071_2024_01_19_17_20_20.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
```

raupie · 2024-01-30 21:19:22

I was able to clean up the missing `creation_date` EXIF metadata on my mp4s

I hope this helps you out. I believe the plugin should do some extra data validation for missing required fields IMHO with a clearer warning.

```
ffmpeg -i _T8424T1023160071_2024_01_19_17_20_20.mp4.org -c copy -map 0 -metadata creation_time="2024-01-19T17:20:20" _T8424T1023160071_2024_01_19_17_20_20.mp4
```

piwigo-videojs seems happy when I synchronize and generates the missing posters and no mysql error.

erAck · 2024-01-31 01:14:03

John R wrote:
This would suggest it's possible with %r and %p

That formats a stored datetime value for display, not in storage.

John R · 2024-01-31 01:18:23

Well, I'm back to square one then, the IOS app just doesn't seem to be able to handle a phone using 12hr format.

Piwigo.org

Announcement

#31 2024-01-30 19:58:50

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#32 2024-01-30 19:58:54

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#33 2024-01-30 20:01:28

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#34 2024-01-30 20:01:28

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#35 2024-01-30 20:02:57

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#36 2024-01-30 21:19:22

Re: Piwigo 14.1.0 and PHP 8.3 blows up

#37 2024-01-31 01:14:03

Re: Piwigo 14.1.0 and PHP 8.3 blows up

John R wrote:

#38 2024-01-31 01:18:23

Re: Piwigo 14.1.0 and PHP 8.3 blows up

Board footer