We recently purchased a template to go with Zen Cart 1.2.7, unlike Zen Cart 1.3.7 there are issues when clicking over to some pages...the error reads:
1054 Unknown column 'p.products_id' in 'on clause'
Upgrading to Zen Cart 1.3.7 is not an option so a fix needs to be done...there is a lot of information on how to do it on Zen cart forums such as the following:
Please note that osCommerce and Zen Cart are not the same but do use some of the same functions. The Bug Fix to make osCommerce compatable with MySQL 5 is listed in full here:
[url removed, login to view]
It may help to show you what you need to do to make your version of Zen Cart compatable with MySQL 5. If you can upgrade to the latest vrsion of Zen Cart then do so, and this should also fix the problem.
For the moment this all we need...