WEBSITE WOES, PLEASE HELP/

hey hows it going, i currently have a website and the shopping cart is giving me an error when you click on products, ANYONE HAVE ANY IDEAS????? DONT KNOW IF ANYONE ON THIS SITE KNOWS ABOUT PHP OR ZEN CART BUT WORTH ASKING THANKS.

here is what i was told by another ecommerce solution company......

"
Hi Josh,
I see the error you are talking about. This probably means you have MySQL 5 installed on your server, and your version of Zen Cart (1.2.6d or earlier) does not fully support MySQL 5. This issue has largely been fixed in the version 1.3.x series, and will be improved with each release. If you have to stick with your current version the best solution would be downgrading to MySQL 4.

If this is something you would like us to repair it will cost you around $200 and we could start early next week. We would need the admin login to your hosting account. I will be out of my office on business till Monday morning. In the meantime you can contact me via email. Please let me know how you want to proceed. Thanks for considering Seaway Web Design. I look forward to your reply…



Ben LaValley
Seaway Web Design
51 Phillips Street STE #1
Massena, NY 13662
Phone: 315.764.3400
"


and here is the error it is giving me.

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '39'

PLEASE LET ME KNOW ASAP. THIS IS KILLING MY BUSINESS. LOL, THANKS FOR YOUR TIME.

JOSH

downgrade to mysql4 or upgrade your shopping cart php script.
or just go with a new script that supports mysql 5.
there are tons out there... should be some on your sever if your host is a company, and not just you hosting it on a server.. if your hosting your domain on your own server, just downgrade your mysql.
or change hosting companies... i know my hosts all have 5 or 6 different shopping carts.. also check out
they have tons of free shopping cart scripts that you can install yourself...
hope that helps lol

vegas, thanks for the info, however, I don't know how to do that shit, as far as the upgrade/downgrade change this change that, I don't have a clue, I need someone to do it for me, if u can do it lemme know, I would love to make it worth ur while. if not, thanks for the info

talk to baha dude.. he is good with php.
i could do it, but i never have any time for anything...
let me see what i can do.

i got it handled guys thanks.

good thing to, i was about to order everything from suicide doors.... lol. jk. glad to hear its all back up and running.

on another topic, do you have a shop in victorville?

naw man i just live in victorville, the shop was in lancaster up until about a month ago, now im actually in an office only with one bay full of parts, just filling web and phone orders at this time, not actually doing any work, just contracting my fabrication jobs out to IF customs and CTP concepts.