Post by sidotij » Thu Feb 21, 2019 11:12 pm

Good Morning,

I have a fresh clean install of opencart Version 3.0.3.1, out of the box, no extensions loaded and all the test data still in the database.
When added a new product I get a white screen after hitting save

No errors in the error log at all

any ideas?

Thanks
John

Newbie

Posts

Joined
Thu Feb 21, 2019 7:23 am

Post by thekrotek » Thu Feb 21, 2019 11:52 pm

White scree always has an error, you just don't see it. Enable displaying errors to see the error message.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by sidotij » Fri Feb 22, 2019 1:52 am

here's a useful error

Code: Select all

Fatal error: Uncaught Exception: Error: Duplicate entry '0' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_advertise_google` (`product_id`, `store_id`, `google_product_category`) SELECT p.product_id, p2s.store_id, (SELECT c2gpc.google_product_category FROM `oc_product_to_category` p2c LEFT JOIN `oc_category_path` cp ON (p2c.category_id = cp.category_id) LEFT JOIN `oc_category_to_google_product_category` c2gpc ON (c2gpc.category_id = cp.path_id AND c2gpc.store_id = 0) WHERE p2c.product_id = p.product_id AND c2gpc.google_product_category IS NOT NULL ORDER BY cp.level DESC LIMIT 0,1) as `google_product_category` FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p2s.product_id = p.product_id AND p2s.store_id = 0) LEFT JOIN `oc_product_advertise_google` pag ON (pag.product_id = p.product_id AND pag.store_id=p2s.store_id) WHERE pag.product_id IS NULL AND p2s.store_id IS NOT NULL AND p.product_id IN (59) in /home/stormsce/public_html/b-moviebeauty.com/system/library/db/mysqli.php:40 Stack trace: #0 in /home/stormsce/public_html/b-moviebeauty.com/system/library/db/mysqli.php on line 40

Newbie

Posts

Joined
Thu Feb 21, 2019 7:23 am

Post by thekrotek » Fri Feb 22, 2019 6:17 am

Make sure you have Auto Increment checked for oc_product_advertise_google table.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by sidotij » Sat Feb 23, 2019 9:47 am

thank you for the tip
I appreciate it :)

Newbie

Posts

Joined
Thu Feb 21, 2019 7:23 am
Who is online

Users browsing this forum: grgr, lockbox, nonnedelectari and 89 guests