Đã hoàn thành

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 nhiều hơn: mysql 5.1, 1054 unknown column select, 1054 unknown, 1054, apparently, 1054 unknown column language_id clause, mysql join, unknown column clause 1054, count mysql, mysql left, mysql 1054 unknown column, error mysql, unknown column products_id clause, unknown column products_id, unknown column, unknown clause, tep stop mysql, tep stop error, select select mysql, mysql service, mysql select, error unknown column products_id clause, error unknown column products_id clause, mysql unknown column 1054, mysql left join 1054 unknown column clause

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

ID dự án: #1908008

Được trao cho:


Can do it quickly, please see my portfolio here [url removed, login to view]

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