In Progress

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.

Skills: PHP, Script Install

See more: this error, select group, group o, 1104 select examine oscommerce, message error, error 0, error, error php, desc, website error, examine, set oscommerce, website orders, error oscommerce php, oscommerce error message, group script php, oscommerce php error, error message oscommerce, oscommerce products catalog, script pending orders, group page script, limit orders, group script, pending orders script, script limit

About the Employer:
( 10 reviews ) Atlanta, United States

Project ID: #190809

Awarded to:

wincent

can be done quickly.

$30 USD in 0 days
(85 Reviews)
6.0

5 freelancers are bidding on average $34 for this job

NickolaS

Hi, please, check your PM

$30 USD in 0 days
(332 Reviews)
7.5
imszone

Hi, please see PM.

$50 USD in 0 days
(48 Reviews)
6.4
nknk

Hi. Can fix that. Please check PM.

$30 USD in 1 day
(75 Reviews)
6.0
exitsol

Lets get started.Pls see PMB

$30 USD in 0 days
(121 Reviews)
5.9