fix oscommerce error

receiving an error in our osCommerce site

The error in the store is:

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

This shows up when you click on the left in "catagories"

Evner: Perl, PHP, Indkøbsvogne

Se mere: oscommerce error search, products manufacturers, manufacturers products, oscommerce error total, fix cgi script error 500 oscommerce, oscommerce error search russia, error 0, error, error php, drailean, catagories, 1054 unknown column select, 1054 php, 1054 unknown, 1054, 1054 unknown column language_id clause, oscommerce click, unknown column php, specials, click oscommerce, error oscommerce php, fix error php, oscommerce php error, fix php error, unknown column clause 1054

Om arbejdsgiveren:
( 54 bedømmelser ) Valparaiso, United States

Projekt ID: #262667

Tildelt til:


hello, please check the PM

$30 USD in 0 dage
(214 bedømmelser)

3 freelancere byder i gennemsnit $33 på dette job


I'm interested in working with you on this project. If you would like to discuss further please pm me. Thank you.

$30 USD på 1 dag
(21 bedømmelser)

Please check PM

$40 USD på 1 dag
(14 bedømmelser)