Em Andamento

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


Ver mais: to p, products manufacturers, manufacturers products, manufacturers catalog, mysql 4, community m, c bug, 1054 unknown column select, official, 1054 unknown, mysql osc, 1054, fix bugs site, click upgrade, specials, mysql join, bugs fix, click solution, oscommerce products catalog, osc products, unknown column clause 1054, due, site manufacturers, post mysql, count mysql

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

ID do Projeto: #144055

Premiar a:


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

$30 USD em 1 dia
(39 Avaliações)

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


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

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