Đang Thực Hiện

161819 MySql 5 Ecommerce Errors

Apparently there is a known issue with MySQl 5 and it has broken our site. The error is as follows:

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_retail_prices 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 = '4'


This error didn't crop up until our service provider upgraded to MYSQL 5.

Kỹ năng: Bất kì công việc gì, MySQL

Xem thêm: 1054 unknown column select, 1054 unknown, 1054, apparently, mysql join, unknown column clause 1054, count mysql, mysql left, mysql 1054 unknown column, error mysql, unknown column, unknown clause, tep stop mysql, tep stop error, mysql service, mysql select, mysql unknown column 1054, 1054 tep stop, unknown column clause join, mysql count 1054, 1054 clause, join unknown column mysql, mysql left join 1054, error 1054 mysql, mysql clause 1054

Về Bên Thuê:
( 48 nhận xét ) Kent, United States

Mã Dự Án: #1908008

Đã trao cho:


Can do it quickly, please see my portfolio here www.redskiesdesign.com/portfolio/

$5 USD trong 0 ngày
(0 Đánh Giá)