Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

No Datetime Conversion of EXIF data

Kleingedrucktes   ( User )

Commented 2 years ago

Steps to reproduce bug:

1. Have a photo with EXIF data specifying shooting date in non SQL standard form.
2. Try to upload photo to item.

SQLSTATE[22007]: Invalid date time format: 1366 Incorrect integer value: '' for column `akaunting`.`mediables`.`media_id` at row 1 (SQL: insert into `mediables` (`media_id`, `mediable_id`, `mediable_type`, `order`, `tag`) values (, 7, App\Models\Common\Item, 1, picture))

I shot the photograph with date format dd.mm.yy but Mysql expects yy--mm--dd.
Changing localization date didn't help, but removing EXIF data does.

Maybe someone with more abilities is able to fix this problem.

Denis Dulici   ( Admin )

Commented 2 years ago

That's not related to Akaunting but the following package which handles media:

https://github.com/plank/laravel-mediable

Feel free to create an issue there.

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions