Additional Product Images - Version: 2.1
I'm working locally with mamp pro, mysql version 5.7.23 and php 7.1.22
When I load an additional image it gives me error 503 and this error log;
[16-Jan-2019 10:46:56 Europe/Rome] Request URI: /ADMIN/additional_product_images_upload.php?products_id=108&action=insert, IP address: ::1
#1 trigger_error() called at [/Applications/MAMP/htdocs/MYDOMAINE/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/Applications/MAMP/htdocs/MYDOMAINE/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/Applications/MAMP/htdocs/MYDOMAINE/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/Applications/MAMP/htdocs/MYDOMAINE/Hoist-gzM-Adult/additional_product_images_upload.php:45]
with mysql version 5.6 everything works fine
[16-Jan-2019 10:46:56 Europe/Rome] PHP Fatal error: 1364:Field 'category_id' doesn't have a default value :: insert into additional_images
(products_id, additional_image, status)
values ('108',
'additional/myimage.jpg',
'1') ==> (as called by) /Applications/MAMP/htdocs/MYDOMAINE/ADMIN/additional_product_images_upload.php on line 45 <== in /Applications/MAMP/htdocs/MYDOMAINE/includes/classes/db/mysql/query_factory.php on line 171
PHP Code:
$db->Execute("insert into " . TABLE_ADDITIONAL_IMAGES . "
(products_id, additional_image, status)
values ('" . zen_db_input((int)$_GET['products_id']) . "',
'" . $additional_image_name . "',
'1')");
Thanks for your help
Bookmarks