I gang

oscommerce quick fix

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

[TEP STOP]

from hosting company

After the recent MySQL server upgrade you might be getting the following errors in some of the forums installed on our servers,

"#1054 - Unknown column 'xxxx' in 'on clause'"

This is the error on MySQL 5, but it's working fine in MySQL 4.1

Fixes:

You need to redefine the Join query in the script or could use some readymade fixing by searching in Search Engines.

Example:

Detailed MySQL documentation on 'Join':

[url removed, login to view]

Færdigheder: Indkøbsvogne

Se mere: unknown search engines, products manufacturers, manufacturers products, html dev, fix html error, fine products, oscommerce quick find, value4u, fix mysql query, fix query, quick server, 1054 unknown column select, 1054 unknown, 1054, oscommerce tep stop error, tep stop oscommerce, mysql quick, specials, need readymade, detailed query, hosting fix, quick count, oscommerce tep stop, forums html, mysql query example

Om arbejdsgiveren:
( 29 bedømmelser ) issaquah, United States

Projekt-ID: #284709