Thank you - perfect solution :)
Printable View
Having a bit of a problem, implemented it as per the instructions, however, when i go to my specials page... it still doesn't list the sales?
Please help!
If you go to http://gbsa.tyrmida.co.za/shop/all-products
you'll see the first shoe top left (alma hi) is on special, and the shoe to the right of it (alma lo) is on sale.
If you go to the specials page http://gbsa.tyrmida.co.za/shop/specials
it only shows the alma hi.
Please help, this is rather urgent
If you want to show the sales on the front page, use my "What's On Sale" contribution in the Free Software Add Ons at the top left of this page.
I went ahead and made a hack that lets you add multiple items to Specials at one time. Is anyone still interested in this? Don't want to waste my time putting this out there if no one needs it.
Hi
Using version 1.3.9h I am getting an error with Numinix fix
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 ‘*) as total FROM products p LEFT JOIN specials s ON (s’ at line 1
in:
[select count(distinct *) as total FROM products p LEFT JOIN specials s ON (s.products_id = p.products_id) LEFT JOIN products_description pd ON (pd.products_id = p.products_id) LEFT JOIN products_to_categories p2c ON (p2c.products_id = p.products_id) WHERE p.products_status = '1' AND ( (s.status = 1 AND p.products_id = s.products_id) OR (p2c.categories_id IN (235,201)) ) AND p.products_id = pd.products_id AND pd.language_id = 1 ]
On his blog there are others having same problem and no solution, does someone know how to solve this error?
Thanks
L.
Please see my latest comment: https://www.numinix.com/blog/2010/10.../#comment-5001.
Have you made other customizations to the specials listing? This code does work with ZC 1.5.1. Try using the developer's toolkit to find where this text is used:
Code:select count(distinct *) as total FROM
In case this helps anyone:
for those of you like me that suddenly got the “WARNING: An Error occurred, please refresh the page and try again.” using Zen Cart 1.5.1 – I dug around and for some reason when a new salemaker is being created its addin in 2 commas st the start of the field – which the MySQL cannot work with
so in
Open includes/modules/pages/specials/main_template_vars.php and find:
I changed
$sale_categories_all = substr($sale_categories_all, 1); // remove preceeding comma
too
$sale_categories_all = substr($sale_categories_all, 2); // remove preceeding 2 comma’s
and error went away – now I don’t know why this is happening now – as it was working fine
but for those that just want a solution try it - I don't guarantee that it won't have an effect further down the line :)
Thanks
Sarah