Проблема при оформление заказа

[Sport7]

От покупателей поступила жалоба. Вот такая ошибка выскакивает.

 

При попытке оформить заказ получаю:

 

 

Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Error No: 1104

DELETE `order`, order_product, order_option, order_download, order_total,order_voucher FROM `order` LEFT JOIN order_product ON order_product.order_id = `order`.order_id LEFT JOIN order_option ON order_option.order_id = `order`.order_id LEFT JOIN order_download ON order_download.order_id = `order`.order_id LEFT JOIN order_total ON order_total.order_id = `order`.order_id LEFT JOIN order_voucher ON order_voucher.order_id = `order`.order_id WHERE `order`.order_id = '812' AND `order`.order_status_id = 0 in /hosting/b12-31909/data/www/sport7.com.ua/system/database/mysql.php on line 49

[SPositive]

Пишем хостеру:

sql_big_selects = 1

И на всякий пожарный:

max_join_size 5 000 000
sql_max_join_size 5 000 000

 

Чтоб такого больше не возникало :oops: