🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#31 2024-01-30 19:58:50
- raupie
- Member
- 2023-07-11
- 12
Re: Piwigo 14.1.0 and PHP 8.3 blows up
TLDR; Can you run `mediainfo <IMG>` and check for the creation date?
Is it every image or just specific images?
Offline
#32 2024-01-30 19:58:54
- John R
- Member
- 2023-04-17
- 25
Re: Piwigo 14.1.0 and PHP 8.3 blows up
I do use the plugin, but have it set to v4 as I prefer the way that looks.
Offline
#33 2024-01-30 20:01:28
- raupie
- Member
- 2023-07-11
- 12
Re: Piwigo 14.1.0 and PHP 8.3 blows up
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.
Offline
#34 2024-01-30 20:01:28
- John R
- Member
- 2023-04-17
- 25
Re: Piwigo 14.1.0 and PHP 8.3 blows up
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%)
Offline
#35 2024-01-30 20:02:57
- raupie
- Member
- 2023-07-11
- 12
Re: Piwigo 14.1.0 and PHP 8.3 blows up
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)
```
Offline
#36 2024-01-30 21:19:22
- raupie
- Member
- 2023-07-11
- 12
Re: Piwigo 14.1.0 and PHP 8.3 blows up
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.
Offline
#37 2024-01-31 01:14:03
- erAck
- Only trying to help
- 2015-09-06
- 2043
Re: Piwigo 14.1.0 and PHP 8.3 blows up
John R wrote:
This would suggest it's possible with %r and %p
That formats a stored datetime value for display, not in storage.
Running Piwigo at https://erack.net/gallery/
Offline
#38 2024-01-31 01:18:23
- John R
- Member
- 2023-04-17
- 25
Re: Piwigo 14.1.0 and PHP 8.3 blows up
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.
Offline