Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Would some guide me thru an SQL error?


Recommended Posts

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


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

  • Create New...