Error on OSCommerce website

Following error message present on every page of the catalog:


1104 - 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

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '139' and opa.orders_id = opb.orders_id and opb.products_id != '139' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6


Looking for the professional to remove this error.

Evner: PHP, Script Installering

Se mere: this error, the select group, group o, error on website, select pproducts_id pproducts_image orders_products opa oscommerce, 1104 select examine oscommerce, message error, error 0, error, error php, desc, website error, examine, set oscommerce, oscommerce oscommerce catalog, website orders, error oscommerce php, oscommerce error message, group script php, oscommerce php error

Om arbejdsgiveren:
( 10 bedømmelser ) Atlanta, United States

Projekt ID: #190809

Tildelt til:


can be done quickly.

$30 USD in 0 dage
(85 bedømmelser)

5 freelancere byder i gennemsnit $34 på dette job


Hi, please, check your PM

$30 USD in 0 dage
(332 bedømmelser)

Hi, please see PM.

$50 USD in 0 dage
(48 bedømmelser)

Hi. Can fix that. Please check PM.

$30 USD på 1 dag
(75 bedømmelser)

Lets get [login to view URL] see PMB

$30 USD in 0 dage
(121 bedømmelser)