ModuleBuilder module export All Records error

[Killa]

Hi

I created a module using module builder but when I select "All Records" and export I receive a SQL error.

Error exporting STBB_Attending:
. SELECT stbb_attending.* , 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 , jt3.name stbb_attending_campaigns_name, jtl3.stbb_atten9b59mpaigns_ida stbb_atten9b59mpaigns_ida , CONCAT(IFNULL(jt4.first_name,''),' ',IFNULL(jt4.last_name,'')) stbb_attending_contacts_name, jtl4.stbb_attendd79ontacts_ida stbb_attendd79ontacts_ida , jt5.user_name modified_user_name , jt5.created_by modified_user_name_owner , 'Users' modified_user_name_mod FROM stbb_attending LEFT JOIN users jt0 ON jt0.id= stbb_attending.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= stbb_attending.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= stbb_attending.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN stbb_attendng_campaigns_c jtl3 ON stbb_attending.id=jtl3.stbb_attenc8e0tending_idb AND jtl3.deleted=0 LEFT JOIN campaigns jt3 ON jt3.id=jtl3.stbb_atten9b59mpaigns_ida AND jt3.deleted=0 AND jt3.deleted=0 LEFT JOIN stbb_attending_contacts_c jtl4 ON stbb_attending.id=jtl4.stbb_atten1f33tending_idb AND jtl4.deleted=0 LEFT JOIN contacts jt4 ON jt4.id=jtl4.stbb_attendd79ontacts_ida AND jt4.deleted=0 AND jt4.deleted=0 LEFT JOIN users jt5 ON jt5.id= stbb_attending.modified_user_id AND jt5.deleted=0 AND jt5.deleted=0 where ((join_stbb_attending_campaigns_name.name like 'Website Launch Competition%')) AND stbb_attending.deleted=0 Query Failed: SELECT stbb_attending.* , 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 , jt3.name stbb_attending_campaigns_name, jtl3.stbb_atten9b59mpaigns_ida stbb_atten9b59mpaigns_ida , CONCAT(IFNULL(jt4.first_name,''),' ',IFNULL(jt4.last_name,'')) stbb_attending_contacts_name, jtl4.stbb_attendd79ontacts_ida stbb_attendd79ontacts_ida , jt5.user_name modified_user_name , jt5.created_by modified_user_name_owner , 'Users' modified_user_name_mod FROM stbb_attending LEFT JOIN users jt0 ON jt0.id= stbb_attending.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= stbb_attending.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= stbb_attending.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN stbb_attendng_campaigns_c jtl3 ON stbb_attending.id=jtl3.stbb_attenc8e0tending_idb AND jtl3.deleted=0 LEFT JOIN campaigns jt3 ON jt3.id=jtl3.stbb_atten9b59mpaigns_ida AND jt3.deleted=0 AND jt3.deleted=0 LEFT JOIN stbb_attending_contacts_c jtl4 ON stbb_attending.id=jtl4.stbb_atten1f33tending_idb AND jtl4.deleted=0 LEFT JOIN contacts jt4 ON jt4.id=jtl4.stbb_attendd79ontacts_ida AND jt4.deleted=0 AND jt4.deleted=0 LEFT JOIN users jt5 ON jt5.id= stbb_attending.modified_user_id AND jt5.deleted=0 AND jt5.deleted=0 where ((join_stbb_attending_campaigns_name.name like 'Website Launch Competition%')) AND stbb_attending.deleted=0::MySQL error 1054: Unknown column 'join_stbb_attending_campaigns_name.name' in 'where clause'

The attending module is a many-to-many relationship between campaigns and contacts. The join_stbb_attending_campaigns_name does not seem to be used anywhere except in the where clause. Ive tried http://www.sugarcrm.com/crm/support/...8-498cc027b9f7 but that did not seem to fix the problem.

Im using SugarCRM CE Version 5.5.1 (Build 1202)

[salesagility]

goto admin>repair>quick repair and rebuild

[Killa]

Hi

Thanks for the help but it didn't work, one of the first things I tried.

Fixed it by adding this to my modules main class

function create_export_query($order_by, $where){
$where = str_replace('join_stbb_attending_campaigns_name', 'jt3', $where);
return $this->create_new_list_query($order_by, $where, array(), $params, 0, '', false, null, true);
}