Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Request with text


ullerfriend

Recommended Posts

My website hosted by netfirms utilized Commerce pro

 

I have the following text showing up under each of my items for sale?

 

How can i get rid of this text? Any help would be appreciated

 

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 =

> '137' and opa.orders_id = opb.orders_id and opb.products_id != '137'

> 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

Link to comment
Share on other sites

I have the following text showing up under each of my items for sale?

 

How can i get rid of this text? Any help would be appreciated

 

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

Using Google to search here (SET SQL_BIG_SELECTS=1 also_purchased_products.php site:www.oscommerce.com/forums ) I came across the following topic that describes the problem and gives a solution (probably re-writing the code with the queries on the page on which this query is found - also_purchased_products.php - is a better solution but that's another topic :) )

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...