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

[foxkitsinc]

I have a navigation graphic on my main page at Fox Kits Wilderness Survival and each image is set to a page in my osCommerce catalog. The center three images go to the "first tier" categories. The surrounding images go to the products in the "kits" category. All links used to work until my server migrated my site. They were all set up the same way; I went to each catalog page and copied the URL through the product_id and pasted it in the html code of my NavGraphic. It all worked great until now. The three center image links still work fine. All of the outer links give a similar error code:

 

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

 

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 = '23'

 

[TEP STOP]

 

If you navigate to one of the three main categories and continue to one of the products from within OSC everything works fine. The only problem is when you try to navigate to one of the products from outside OSC.

 

One thing the migration did was to change the format of my URL's but they have everything set up to redirect - except the images in question on the main page. :blink:

 

I have read many of the posts regarding the mySQL 5.0 upgrade. This is not the problem directly because my server is using 12.x and has been for some time. I am using OSC 2.2.2 - any suggestions would be most appreciated. Please keep the expainations simple as I am not a professional programmer - I am a survival instructor. :rolleyes:

 

Thanks,

BK

[♥geoffreywalton]

My sql hasn't reached version 12

 

Go to catalog/admin/server_info.php and see what version is shown there.

 

(Just in case it is, try http://www.oscommerce.com/ext/update-20060817.txt)

[foxkitsinc]

Sorry, I got that information off of my server data page... another source from my host says it is version 5.0.45.

 

Using the catalog/tools/server_info.php route says it is version 5.0.21

 

The link you gave gave me a 404 error.

 

Thanks.

[wondernet]

The link you gave gave me a 404 error.

 

Take the end bracket off the link and it works fine :rolleyes:

 

http://www.oscommerce.com/ext/update-20060817.txt

 

You need to look for the last section called "MySQL 5.0 Compatibility" .. and I'm about to read it myself ... God, I hate it when it does this!!