Sedang Disiapkan

219391 OSC - Fix error

Hey,

I believe an mysql update has created an error for one of our queries,

We are getting this error message:

1054 - Unknown column 's.cat_id' in 'on clause'

select count(*) as total from products p, featured s, products_description pd left join fcat f on [url removed, login to view] = s.cat_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id

I have attached the file.

Kemahiran: Semua Boleh, MySQL, PHP

Lihat lebih lanjut: this error, message error, php fix error, fix error, php mysql error unknown column, 1054 unknown column select, 1054 php, 1054 unknown, mysql osc, 1054, 1054 unknown column language_id clause, unknown column php, mysql join, fix error php, osc products, unknown column clause 1054, count mysql, mysql update column, mysql 1054 unknown column, error mysql, update queries mysql, unknown column products_id clause, unknown column products_id, unknown column, unknown clause

Tentang Majikan:
( 137 ulasan )

ID Projek: #1965624