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"

Kemahiran: Perl, PHP, Troli Membeli-belah

Lihat lagi: 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

Tentang Majikan:
( 54 ulasan ) Valparaiso, United States

ID Projek: #262667

Dianugerahkan kepada:


hello, please check the PM

$30 USD dalam 0 hari
(214 Ulasan)

3 pekerja bebas membida secara purata $33 untuk pekerjaan ini


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

$30 USD dalam sehari
(21 Ulasan)

Please check PM

$40 USD dalam sehari
(14 Ulasan)