Error when exporting.

**jgrimaldos** · 2011-08-19, 11:19 PM

Hi, I'm getting this error when trying to export Cases.

Database failure. Please refer to sugarcrm.log for details.

Digging around I found this in sugarcrm.log

Fri Aug 19 17:27:36 2011 [16898][1][FATAL] SQL Error : Invalid column name 'user_id_c'.

Digging even deeper, I found this query to be the suspect:

SELECT cases.* ,cases_cstm.account_id_c,cases_cstm.argumenta_c,ca ses_cstm.calificacion_c,cases_cstm.calificado_c,ca ses_cstm.causa_principal_c,cases_cstm.cierra_ciclo s_c,cases_cstm.compromete_c,cases_cstm.compromisos _c,cases_cstm.conocimiento_c,cases_cstm.contact_id _c,cases_cstm.contact_id1_c,cases_cstm.cortesia_c, cases_cstm.cumplio_compromiso_c,cases_cstm.despide _c,cases_cstm.detalle_causa_c,cases_cstm.domina_in formacion_c,cases_cstm.escucha_c,cases_cstm.estado _casos_c,cases_cstm.fecha_compromiso_c,cases_cstm. garantia_c,cases_cstm.incentiva_c,cases_cstm.indic a_procedimiento_c,cases_cstm.informa_transferencia _c,cases_cstm.linea_de_interes_c,cases_cstm.lineaa p_c,cases_cstm.maneja_requerimiento_c,cases_cstm.n egocio_c,cases_cstm.no_tutea_c,cases_cstm.parent_i d,cases_cstm.parent_type,cases_cstm.pedido_c,cases _cstm.pqr_c,cases_cstm.productividad_llamada_c,cas es_cstm.prospect_id_c,cases_cstm.realimentacion_ev aluacion_c,cases_cstm.requierimiento_solucionado_c ,cases_cstm.respeto_c,cases_cstm.respuesta_c,cases _cstm.saluda_c,cases_cstm.tipifica_c,cases_cstm.ti po_proceso_c,cases_cstm.tipocaso_c,cases_cstm.usa_ tiempos_c , LTRIM(RTRIM(ISNULL(jt0.first_name,'') + ' ' + ISNULL(jt0.last_name,''))) modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , LTRIM(RTRIM(ISNULL(jt1.first_name,'') + ' ' + ISNULL(jt1.last_name,''))) created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , LTRIM(RTRIM(ISNULL(jt2.first_name,'') + ' ' + ISNULL(jt2.last_name,''))) assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod , accounts.name account_name , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, jt4.name codigocliente_c , LTRIM(RTRIM(ISNULL(jt5.first_name,'') + ' ' + ISNULL(jt5.last_name,''))) contacto_c , LTRIM(RTRIM(ISNULL(jt6.first_name,'') + ' ' + ISNULL(jt6.last_name,''))) responsable_c , LTRIM(RTRIM(ISNULL(jt7.first_name,'') + ' ' + ISNULL(jt7.last_name,''))) rlel_c , LTRIM(RTRIM(ISNULL(jt8.first_name,'') + ' ' + ISNULL(jt8.last_name,''))) modified_user_name , jt8.created_by modified_user_name_owner , 'Users' modified_user_name_mod FROM cases LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c LEFT JOIN users jt0 ON jt0.id= cases.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= cases.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= cases.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN accounts accounts ON accounts.id= cases.account_id AND accounts.deleted=0 AND accounts.deleted=0 LEFT JOIN accounts jt4 ON cases_cstm.account_id_c = jt4.id AND jt4.deleted=0 LEFT JOIN contacts jt5 ON cases_cstm.contact_id1_c = jt5.id AND jt5.deleted=0 LEFT JOIN users jt6 ON cases_cstm.user_id_c = jt6.id AND jt6.deleted=0 LEFT JOIN prospects jt7 ON cases_cstm.prospect_id_c = jt7.id AND jt7.deleted=0 LEFT JOIN users jt8 ON jt8.id= cases.modified_user_id AND jt8.deleted=0 AND jt8.deleted=0 where (cases.id in ('6b1f5567-237d-d4f1-abd3-4e4ee19a3795','ed6d812f-bcb5-1559-3a20-4e4ee1c39a16','12d4e7c0-1189-4ae3-e64b-4e4ee12f6d25','450cc6b4-2be4-bfe8-d1f1-4e4ee193c0b4','8f85295b-9cc5-7f16-a03e-4e4ee0069811','a001b024-bdee-29bc-86c3-4e4edc27512e','662f0f38-50ef-aaf9-8cbf-4e4edbd22916','9c7e190f-6fab-4d5c-20ea-4e4eda699628','b31ddbd4-a555-8427-abf1-4e4edac999c7','4cb809d3-0d04-a2a0-9ad3-4e4eda019bd1','65fcbdb9-6143-cc7c-d45d-4e4ed98ea329','a56933f3-67b3-aaa5-eb41-4e4ed921d9c3','a06695f6-f732-8a99-d3f4-4e4ed822ea00','d0082a8f-d7d2-4ead-e22e-4e4ed6fb3662','64e03c74-9deb-1b48-ab26-4e4ed3e49fd9','14073d98-9517-6e18-2ce3-4e4ed1cdfe64','1234876e-0420-e980-358b-4e4ece909ba4','7e470840-0e3b-0f0c-fd08-4e4eceb513f3','68c81148-16e6-1d24-cd02-4e4ecdc2aaa3','e70a3c8d-a11e-569c-67d3-4e4eccac00be','13b8931d-366d-26e7-2ccb-4e4eebf20515','22116a0d-23a0-81f9-9b82-4e4ee31e234b','c2e744a3-5373-514a-9d03-4e4ee3f9499f')) AND cases.deleted=0"

Weird thing is that there never was an user_id_c custom field! there's not a single reference on the entire sugar folder.

Any help is kindly appreciated.