Error on Search > Select All > Export

[CBREGolf]

I created a custom module and a relationship to Accounts. When I search in the custom module by Account name, I can't export all records. I can select records individually, or 'Select This Page' and the export works fine. If I 'Select All' and export I get a join error in the log and a blank screen with the message "Database failure. Please refer to sugarcrm.log for details."

Does anyone know what could be causing this or where to look for clues? Should I compare the code for a 'select all' export with the code for a 'select this page' export? (and do you know where I can find that code?)

Thanks,

[CBREGolf]

In case it helps, below is the error in the log when set to debug. I think the line in blue below should start with:

AND jt4.deleted=0 where ((jt4.name like 'Great Oaks Golf%'))

but I don't know where to change the code.

10/31/11 16:02:41 [3316][1][INFO] Query: SELECT gcsc_golfcourses.* ,gcsc_golfcourses_cstm.gc_yearopen_c,gcsc_golfcour ses_cstm.gc_address_city_c,gcsc_golfcourses_cstm.g c_address_state_c,gcsc_golfcourses_cstm.gc_address _postalcode_c,gcsc_golfcourses_cstm.gc_address_cou ntry_c,gcsc_golfcourses_cstm.gc_address_c,gcsc_gol fcourses_cstm.gc_website_c,gcsc_golfcourses_cstm.g c_config_c,gcsc_golfcourses_cstm.gc_locationmap_c , TRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,''))) modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , TRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,''))) created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , TRIM(CONCAT(IFNULL(jt2.first_name,''),' ',IFNULL(jt2.last_name,''))) assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod , jt3.name accounts_golfcourses_name, jtl3.account75aaunts_ida account75aaunts_ida , TRIM(CONCAT(IFNULL(jt4.first_name,''),' ',IFNULL(jt4.last_name,''))) modified_user_name , jt4.created_by modified_user_name_owner , 'Users' modified_user_name_mod FROM gcsc_golfcourses LEFT JOIN gcsc_golfcourses_cstm ON gcsc_golfcourses.id = gcsc_golfcourses_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= gcsc_golfcourses.modified_user_id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON
jt1.id= gcsc_golfcourses.created_by AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON
jt2.id= gcsc_golfcourses.assigned_user_id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN accountscsc_golfcourses_c jtl3 ON gcsc_golfcourses.id=jtl3.account311crses_idb AND jtl3.deleted=0
LEFT JOIN accounts jt3 ON jt3.id=jtl3.account75aaunts_ida AND jt3.deleted=0
AND jt3.deleted=0 LEFT JOIN users jt4 ON
jt4.id= gcsc_golfcourses.modified_user_id AND jt4.deleted=0
AND jt4.deleted=0 where ((join_accounts_golfcourses_name.name like 'Great Oaks Golf%')) AND gcsc_golfcourses.deleted=0
10/31/11 16:02:41 [3316][1][INFO] Query Execution Time:0.00049495697021484
10/31/11 16:02:41 [3316][1][FATAL] MySQL error 1054: Unknown column 'join_accounts_golfcourses_name.name' in 'where clause'
10/31/11 16:02:41 [3316][1][DEBUG] Hook called: ::server_round_trip
10/31/11 16:02:41 [3316][1][DEBUG] Calling DBManager::disconnect()