Hey all,
About a year ago, I set up a zencart online store. Everything worked fine for about 5 months, until my webhost, webmasters.com, upgraded their MySQL server without notice. Suddenly, all listed products, though still linked to, retruned this error when accessed:

1054 Unknown column 'p.products_id' in 'on clause'

I tried everything in my power to fix the issue, but soon gave up. My company decided to sell locally, and worry about zencart later. Well, now it';s later, and we;d like to get into the world of ecommerce. The error is, of coruse, still there and still unfixable, so I deicded to install another copy of zencart, but it's been a hellishly painful week trying to get it to work, and it's still thoroughhly unsatisfying. Not to mention the 400+ products thata re on the old site which will have to be relisted at the expense ofconsiderable time and effort. In other words, I'd very much like to get the old store back up and running. If ANYONE here can help me in that respect, will be extremely grateful. And, if you're into fish tanks, I'm sure we could work out a deal. I have moderate php skills and no MySQL skills whatsoever.

Thanks in advance,
Mike