Zencart experts only please! l have installed zencart version 1.27 for a client, and we are getting an error mesage whenever we click on a category or product: 1054 Unknown column 'p.products_id' in 'on clause' l have read on the support forums that it is something to do with the hosts using mysql5 instead of 4. Please is someone able to provide a fix for this error, without upgrading to the latest version of ZC? (l do not want to upgrade as l have spent alot of time on the site) l would also like a copy of all the files altered so that l can apply them in the future to other carts where l have this problem. Looking forward to hearing from you! pps. payment is via escrow, and will be paid in full on completion of the job. pps. please only bid on this job if you are sure you can complete it. If you search the zencart support forums for '1054' there is a bit of information there about this error and some different things that can be tried. l am not a programmer and don't know anything about it, so am looking for some expert help!