CluelessinNY Posted August 8, 2005 Share Posted August 8, 2005 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] Link to comment Share on other sites More sharing options...
CluelessinNY Posted August 8, 2005 Author Share Posted August 8, 2005 thanks but never mind, I found someone to wallk me thru it. :D Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.