SQL Error Export / Mass Update

[roblaus]

I do have a custom made module (module builder) with pretty basic features. Whenever I try to export or update the entire list (selected by the criteria "page" which is a relation) I get the following error message:

SELECT do01_links.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' do01_pages_do01_links_name , ' ' do01_pages44d01_pages_ida , ' ' do01_categories_do01_links_name , ' ' do01_categf362egories_ida , jt5.user_name modified_user_name , jt5.created_by modified_user_name_owner , 'Users' modified_user_name_mod FROM do01_links LEFT JOIN users jt0 ON jt0.id= do01_links.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= do01_links.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= do01_links.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt5 ON jt5.id= do01_links.modified_user_id AND jt5.deleted=0 AND jt5.deleted=0 where ((do01_links.link like 'http://%' ) AND ( do01_links.approved in ('1','2','3') ) AND ( jt3.name like 'mypage%')) AND do01_links.deleted=0::MySQL error 1054: Unknown column 'jt3.name' in 'where clause'

The same query works if I chose just one page to update/export rather than the entire list.

Any help is greatly appreciated because I need exactly this feature (exporting / updating the entire list)

Thx in advance

[crmbalah]

HI
This query has jt3.name, but this query hasn’t any specification about f3. So check the join as well jt3.name like 'mypage%' change this condition

[roblaus]

I guess I saw this. The question is WHY?

[roblaus]

bump and some more (not to be too short)