MySql Error on adding a category from admin area

Go To StackoverFlow.com

-1

MYSQL ERROR

Error: Unknown column 'T1.Field_ID' in 'on clause'

Query:

SELECT `T2`.`ID`, `T2`.`Key`, `T2`.`Type` 
FROM `fl_listing_relations` AS `T1` 
RIGHT JOIN `fl_listing_fields` AS `T2` ON `T1`.`Field_ID` = `T2`.`ID` 
WHERE `T1`.`Category_ID` = '42' ORDER BY `T1`.`Position`

Function: getAll Class: rlDb

2012-04-04 23:25
by user1314051
Add error number in your question, it will really help us to know your proble - Ankit Sharma 2012-04-05 06:58


0

I guess the field Field_ID in table fl_listing_relations doesn't exist.

2012-04-05 05:18
by Mosty Mostacho


0

Check fl_listing_relations table carefully, Field_ID may be missing

2012-04-05 05:40
by sujal
Ads