Problems After MySQL Upgrade

[Geoff Bryant]

I have a problem after today's MySQL upgrade and I'm just wondering if some of you could visit my site and just confirm what I'm seeing?

The site (www.cfgphoto.com) is a typcal gallery system. You click on a small thumbnail image to bring up a larger view. At first all appeared to be working well. Bringing up a category page (click on any in the list at the bottom of the home page), returned a page of thumbnials, but instead of bringing up a larger, fully captioned version of the image, clicking on a thumbnail takes you back to the home page. Also, the search function and other php related functions do not work.

Please note that some of the category pages will take you to a subcategory page that is also composed of thumbnails. You will need to click on the thumbnails there to bring up a detailled view.

Thanks.

[leenkz]

You are correct, no full size image, click on thumb sends back to index!!

[Geoff Bryant]

Thanks. I opened a ticket 5 hours ago and still no reply or problem fixed. I'm getting more than a little peeved.

[Geoff Bryant]

With a bit of research I was able to solve the problem.

[Marino]

Hello,
Good day !!!
I have a problem with osCommerce post upgrade MYSQL 5:

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

select count(*) 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 = '3' and p2c.categories_id = '22'

[TEP STOP]

My products no working, are not show
Please I need help to solution this problem
How do I do?
Thank you
Marino

[YvetteKuhns]

With a bit of research I was able to solve the problem.

I just visited your site and I get a database error on the contact us page.

[dmacminn]

If you're using older applications that are designed to work with MySQL V4, you will probably need to upgrade the version or update the application code (either of these strategies can be used to fix the OSCommerce problem, but the upgrade is the recommended route) so they work correctly with MySQL V5.

[IanS]

If you're using older applications that are designed to work with MySQL5, you will probably need to upgrade the version or update the application code (either of these strategies can be used to fix the OSCommerce problem, but the upgrade is the recommended route).I think Dwight meant MySql V4 not 5. If you're using old applications designed for V4 then you'll need to upgrade to versions for V5.

[YvetteKuhns]

I think he meant that if the software has a version that is supposed to be compatible for MySQL5, you have to run that (updated) version. Some people see that a CMS says it is compatible, but they don't read the details. Version 1 is compatible with MySQL4 and Version 2 is compatible with MySQL5.

Since we are having a problem running the latest version of Zen Cart on another web host, it is on my mind. They claim to have upgraded the server, but now they must move to the actual upgraded server tonight. And they better. I installed it August 9th and they are still making excuses instead of moving from MySQL4 to MySQL5. The shopping cart ALMOST worked. ;)

[dmacminn]

Pretty much everything is on MySQL Version 5 at this point (except for for 0.008% of clients who had a site moved to the MySQL41 (SQL V4.1 staging server) temporarily while they get an app which doesn't like MySQL5 working ...

[Marino]

Many Thanks Boys !