Færdiggjort

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:

wincent

can be done quickly.

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

5 freelancere byder i gennemsnit $34 på dette job

NickolaS

Hi, please, check your PM

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

Hi, please see PM.

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

Hi. Can fix that. Please check PM.

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

Lets get [login to view URL] see PMB

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