Sedang Disiapkan

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'


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


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


Detailed MySQL documentation on 'Join':

[url removed, login to view]

Kemahiran: Troli Membeli-belah

Lihat lebih lanjut: unknown search engines, products manufacturers, manufacturers products, html 5 dev, fix html error, fine products, oscommerce quick find, dev mysql com, value4u, fix mysql query, fix query, quick server, 1054 unknown column select, company documentation, 1054 unknown, 1054, oscommerce tep stop error, 1054 unknown column language_id clause, tep stop oscommerce, mysql quick, specials, need readymade, detailed query, hosting fix, quick count

Tentang Majikan:
( 29 ulasan ) issaquah, United States

ID Projek: #284709