Error - Help

[Guest]

Clicking on anything under the categories box on my store gives the following error message. Anyone have any clues? I'm a real rookie at this, so be gentle.

 

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

 

 

Thanks,

Mark

[flashtor]

hello, i have the same problem

it's because upgrading MySQL version to the newest.

 

when clicking the sub category, the error message

 

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

 

[TEP STOP]

 

anyone can help ?

[GraphicsGuy]

it's because upgrading MySQL version to the newest.

 

If you are sure that is what brought on your problem and the new version is mySQL5, then applying at least that part of the patch that was released in November should solve it. The step by step upgrade instructions indicate what each part of the upgrade addresses. With only one or two identified exceptions, the patches are not codependent so you can apply just what you need or want. But remember:

[nocloo]

If you are sure that is what brought on your problem and the new version is mySQL5, then applying at least that part of the patch that was released in November should solve it. The step by step upgrade instructions indicate what each part of the upgrade addresses. With only one or two identified exceptions, the patches are not codependent so you can apply just what you need or want. But remember:

 

Hi,

 

I got the same error .. Can you please point out where the patch is ? I cannot find it under contributions.

 

Thanks,

-nocloo

[GraphicsGuy]

Hi,

 

I got the same error .. Can you please point out where the patch is ? I cannot find it under contributions.

 

Thanks,

-nocloo

 

The upgrade instructions are included in the complete setup package found here. Download and unzip it and open the file named "update-20051113.html".

 

The forum thread discussing the update is found here.

 

hth

[nocloo]

The upgrade instructions are included in the complete setup package found here. Download and unzip it and open the file named "update-20051113.html".

 

The forum thread discussing the update is found here.

 

hth

 

THANK YOU !!! The error is gone now :)