OpenCart Community

Hello, my opencart works beautifully, however after clicking the SAVE button in the add product page, i get this:
This page isn’t working www.xxxxxxxxx.com is currently unable to handle this request.
HTTP ERROR 500

Are there any ways to troubleshoot this issue?

Hello,

1. which OpenCart version is used
2. which additonal extensions are installed

Beside this, have you already checked the server log?

Opencart Version 3.0.3.1
It's a clean version of opencart, no extension is installed.

I've checked the error log but nothing seems to be out of normal.

nghongkai wrote: ↑

Mon Mar 04, 2019 9:56 pm

I've checked the error log but nothing seems to be out of normal.

Error 500 is a generic error and actual error message is ALWAYS saved in the log. Check again, maybe different log. Or enable displaying errors and try to save the product again.

nghongkai wrote: ↑

Mon Mar 04, 2019 9:56 pm

I've checked the error log but nothing seems to be out of normal.

I have written Server log, not OpenCarts embedded internal log.
Because, such errors are normally not logged in the internal log due their nature.
And many users have not enabled the internal log ..

But the servers log is always available, simply goto your server panel.

thekrotek wrote: ↑

Mon Mar 04, 2019 10:30 pm

Error 500 is a generic error and actual error message is ALWAYS saved in the log.

Not always, if it's an .htaccess error for example

paulfeakins wrote: ↑

Tue Mar 05, 2019 6:55 pm

Not always, if it's an .htaccess error for example

Very unlikely, considering that the error occurs on product save.

check if the product was saved then you know if the error occurred before, after or during the sql part.

you might need to enable error_reporting in your php.ini file so you can see exactly what causes this

I have exactly the same problem that 500 error show after clicking save button at the adding new product page,a clean installation of opencart3.0.3.1+journal3.
now i am trying to solve it ,if done ,I will come back to share the solution

the solution is to use phpmyadmin to execute the following sql command

ALTER TABLE oc_product_advertise_google CHANGE product_advertise_google_id product_advertise_google_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

if use opencart3.0.3.2,you will not have this bug of opencart3.0.3.1

Access your database through phpMyAdmin or adminer. Move to oc_product_advertise_google table and add the AI (auto-increment) property ot it's id field.
If you still have difficulties, feel free to contact our support team through Contact Us form here: https://www.opencart.com/index.php?rout ... rt/contact