
Originally Posted by
webwahm
Hi, thrilled I found this mod by chance as it solves a problem I've been mulling over for days!
OK I'm no techi, but I've installed a couple of things on ZC already and managed to get them working.
I've looked through the entire thread, and tried the suggestions relating to tables not existing and descriptions, but I still get this error in the store. I've checked that I merged the files twice.
Looking at the error it might be to do with the Bestseller box? And the error appears where a sidebox would go. Sorry to sound stupid but this is the first time I've done anything involving the 'install sql patches' (seemed to work though, said it was successful).
1146 Table 'jasweene_zc2.products_description' doesn't exist
in:
[select distinct p.products_id, pd.products_name, p.products_ordered from zen_products p LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id), products_description pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10]
Anyone spot any glaringly obvious errors I've made to cause this?
Thanks in advance
Adele
Bookmarks