103 Posts
shubhaanshu
7 years ago
Topic

Search Join field is showing error "

1054

Unknown column 't0.child_id' in 'on clause'

trying to use this field with custom content types:

project, children, weight


I have 3 tables :

1. Project (id, project_name)

2. Children (id, project_id, name, age)

3. Weight (id, child_id, weight)

I am trying to create a "list and search" based on "Weight" content type in which:

Created a Filter by "project" (select simple with storage Project --> id)

to achieve this I created a search join field "weight_join" in "Weight" Search type

(screenshot 1)

Please give me any clue to resolve it...

Best Regards

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
1
Level 1

 As written in field description "The table on the right side of each Join line (parameter), is assumed to be already known/defined by the query."

Please copy the whole query you are getting (with debug mode on) before and after you add join field so we can see why it is not working

103 Posts
shubhaanshu
7 years ago
0
Level 2

Thanks for your guidance Klas!

Now I started with

id #__content as the Join(1) at the right input boxes

then my other fields....

And it is working perfectly...

Thanks for your kind support and sorry for my silly questions/problems.

Get a VIP membership