222933 Oscommerce site mysql5 error

Hi there,

mysql has been updated and caused some problems to my oscommerce website, [url removed, login to view]

I am getting an error when I try to click on a product:

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


The oscommerce script is heavily modified, so a simple replace can not be done. Apparently there are patches and fixes avaialble.

Thanks very much.


Kemahiran: Semua Boleh, MySQL, PHP

Lihat lagi: site.au, error fixes, mysql error, michelle c, php mysql error unknown column, 1054 unknown column select, 1054 php, 1054 unknown, 1054, apparently, site mysql, oscommerce tep stop error, 1054 unknown column language_id clause, oscommerce click, unknown column php, php tep stop, tep stop oscommerce, mysql replace script, mysql join, click oscommerce, error oscommerce php, mysql select replace, oscommerce tep stop, oscommerce php error, unknown column clause 1054

Tentang Majikan:
( 36 ulasan ) Brisbane, Australia

ID Projek: #1969168

Dianugerahkan kepada:


Can get it done in a few minutes.. Regards Hari

$15 USD dalam 0 hari
(314 Ulasan)