Ask, reply and learn. Join the community of Akaunting.
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.
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.
Showing 1 to 2 of 2 discussions