fix a OSC bug due to mysql 5.1

After upgrade from mysql 4.1 to 5.1, the bug comes:

if click catalog, it will say:

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

The solution is already post at OSCOMMERCE official site:

[url removed, login to view],3171

Please fix the bug for $30 thanks


Veja mais: www manufacturers com, to p, products manufacturers, manufacturers products, manufacturers catalog, www mysql com, mysql 5.1, mysql 4, fix the bug, community m, c# bug, c bug, 1054 unknown column select, official, 1054 unknown, mysql osc, 1054, 1054 unknown column language_id clause, fix bugs site, click upgrade, specials, mysql join, Bugs Fix, oscommerce catalog site com, click solution

Acerca do Empregador:
( 46 comentários ) Philadelphia, China

ID do Projeto: #144055

Concedido a:


Hi, I can fix it for $30 and can start right now. THanks, lester.

$30 USD em 1 dia
(39 Comentários)

2 freelancers estão ofertando em média $30 para esse trabalho


we can do it now. Can you view PMB for details. AHT Group.

$30 USD in 0 dias
(534 Comentários)