Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1104 error and weird header junk


Guest

Recommended Posts

Posted

I get the following error at the bottom of every product page

 

1104 - 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[/b]
[b]select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1595' and opa.orders_id = opb.orders_id and opb.products_id != '1595' 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 15[/b]
[b][TEP STOP][/b]
[b]

 

I have no idea what it is or why it just popped up out of nowhere all of the sudden. I haven't made any changes to the website in a long time. I searched and found a few suggestions but no of them fixed this error. Then the next morning I have some weird mumbo jumbo above my header like im missing a opening or closing tag somewhere. I know I haven't messed with the code so I restored my website back to the first of the month and it didn't phase it. Can someone please advise me on where and what to look for. here is the URL direct one of the product pages that shows the errors http://thecustomconnectiononline.com/bag-brackets-rear-air-bag-brackets-bag-mount-for-15-dom-4-link-bars-p-1595.html

Posted

ok sorry folks the weird hearder thing was my fault! I must have deleted the opening php tag when searching for the problem. the 1104 is the main thing anyway. Any help is much much much appreciated!!

Archived

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

×
×
  • Create New...