I am getting this error everytime i try and edit a product on my site, it was working fine and then all of a sudden this started happening, and production has come to a screaming hault. the error message is below in red
Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
DELETE pov.*,povd.* FROM opn_product_option_value pov LEFT JOIN opn_myoc_product_option_value_discount AS povd ON pov.product_option_value_id = povd.product_option_value_id WHERE product_id = '295' in/hermes/waloraweb019/b1361/moo.hortmanca/hortmanca/shop/system/database/mysql.php on line 49
I was advised the following, but I still do not know how i can fix the problem "your given SQL code is not used in OpenCart" I have a bunch of 3rd party add ons installed on my site, and I could provide if someone has any idea how to help
How may options does this product have?
TOP 5 Opencart Extensions:
1:Opencart Reservations
2:Stock Report, import/export stock levels with Excel
3:3D Carousel
4:Product Price Changer by Category
5:Set price Inclusive Taxes
DEMO SHOP
Who is online
Users browsing this forum: No registered users and 18 guests
