Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Would some guide me thru an SQL error?


CluelessinNY

Recommended Posts

Posted

hi, I successfully installed the Shop by price mod, but im getting an sql error messge, I have phpmyadmin on my server but I am cluesless as how to use it.

 

the contrib says to do this, but I have not a clue as how to. anyone with SQL knowledge, I appreciate it.

 

This is a bugfix release for shop_by_price.php. SQL error that you get when you click on the shop _by_price.php

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

select count(*) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4' left join specials s on p.products_id = s.products_id where p.products_status = '1' and [/i]

Archived

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

×
×
  • Create New...