Hello, I work in France and I am an administrator(director) on SuiteCRM Version 7.4.3. By wanting to modify fields in “note”(“mark”), I made an error of manipulation and I cannot make any more of export.
Here is the error message:“database failure. please refer to suiteCRM, error log file for details.”
Thank you
adélaïde
If you can open the files suitecrm.log located at the root of CRM installation and check the last lines for any FATAL errors that will help. If you can paste the response here we might get an idea.
1 Like
Hello,
To follow upon your demand(request), please find below the last lines for the fatal errors.
Thank you, cordially
Mon Oct 9 11:36:59 2017 [31826][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘e095e88f-d5d3-4702-5d23-59db3ab7c4f4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:40:28 2017 [3303][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:40:33 2017 [610][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:41:17 2017 [31645][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:41:21 2017 [31648][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:41:27 2017 [31826][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:41:48 2017 [3303][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:43:04 2017 [3243][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘5655de7a-05b0-73e7-a447-59db4450befe’ OR notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:43:05 2017 [3243][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘5655de7a-05b0-73e7-a447-59db4450befe’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:43:45 2017 [3277][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:43:56 2017 [3339][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:44:08 2017 [32620][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 11:44:09 2017 [32620][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘4c9f0dfe-a4b2-c9eb-19b9-59c3619935b4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 12:08:55 2017 [31644][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘e095e88f-d5d3-4702-5d23-59db3ab7c4f4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 12:10:25 2017 [3277][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘e095e88f-d5d3-4702-5d23-59db3ab7c4f4’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 12:12:35 2017 [31826][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘154b5fd1-004d-cc53-001d-59db4b31f45e’ OR notes.parent_id=‘e095e88f-d5d3-4702-5d23-59db3ab7c4f4’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 12:12:35 2017 [3243][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘154b5fd1-004d-cc53-001d-59db4b31f45e’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 12:17:29 2017 [3569][1][FATAL] Erreur d’exportationNotes:
.SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘df02b2d5-fc06-9fba-2af3-4b5db7fa6382’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name Query Failed: SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘df02b2d5-fc06-9fba-2af3-4b5db7fa6382’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘field list’
Mon Oct 9 12:18:00 2017 [3569][1][FATAL] Erreur d’exportationNotes:
.SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘14bd254d-1a28-b847-35d1-4b6fde0eb393’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name Query Failed: SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘14bd254d-1a28-b847-35d1-4b6fde0eb393’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘field list’
Mon Oct 9 12:21:17 2017 [31644][1][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 14:23:35 2017 [3556][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘eac5bba2-d4ee-ed7d-fe01-5836edf915a3’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 14:23:46 2017 [3593][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘eac5bba2-d4ee-ed7d-fe01-5836edf915a3’ AND notes.filename IS NOT NULL) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 15:10:19 2017 [3652][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘b735afcc-cffb-6651-89ed-59db75f851b2’ OR notes.parent_id=‘eac5bba2-d4ee-ed7d-fe01-5836edf915a3’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 15:10:20 2017 [3652][314e0b61-3ba4-3eaf-b606-4ba478e6e187][FATAL] Query Failed: SELECT notes.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod , jt2.user_name created_by_name , jt2.created_by created_by_name_owner , ‘Users’ created_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , contacts.assigned_user_id contact_name_owner , ‘Contacts’ contact_name_mod, jt4.name compte1_c FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN users jt0 ON notes.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON notes.modified_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON notes.created_by=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN accounts jt4 ON notes_cstm.account_id_c = jt4.id AND jt4.deleted=0 where (notes.parent_id=‘b735afcc-cffb-6651-89ed-59db75f851b2’) AND notes.deleted=0: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘on clause’
Mon Oct 9 16:27:21 2017 [4197][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Erreur d’exportationNotes:
.SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘b3b74e1a-ac01-e9f7-7acc-58a7233689aa’,‘3ec30a3f-ae82-0cdc-a8eb-58a720a3b477’,‘4a5c2e19-5cac-6339-9cb9-58a71f269a59’,‘ce7ec53f-8168-7878-56d5-58a71d20f501’,‘384b0274-d250-c51b-ba60-58a71df52ca8’,‘57ab92e8-9346-d6d6-caa9-58a71cef7b2c’,‘37d2ef35-f06e-12d5-a1a2-58a71ceec78e’,‘62d137e5-e558-c3e9-acbc-58a71b381882’,‘bd86e342-c410-d894-f57d-58a71bafce61’,‘14e15ba6-cb4e-95a3-8dc4-58a71af00b37’,‘211a15c1-faa8-28d0-dfe0-58a7166c73db’,‘dd532696-76ab-a713-4c86-58a713f6d1d5’,‘63f1a4c7-4a00-bcf2-ec5f-58a7121f8617’,‘7e1cf76e-d5db-742c-3ffe-58a7116e9fc8’,‘2cfda459-f9f1-0b23-1451-57430d24b8c8’,‘15467556-3fe0-0ae8-49c5-5601eb7e7596’,‘e005facb-6212-4784-09cb-55fb54ca0c51’,‘87fad972-4463-04ab-f43d-55ee278ce04d’,‘ba6199d4-2aad-cf88-3fce-55e8e1d23a80’,‘60557aaa-009c-355e-de10-55a6f67d4e96’,‘66c781c4-e8a8-a6d3-e2c0-55a6f65692c1’,‘9e83e9b4-c222-e548-68dc-55a05fb50406’,‘a53b82bf-a302-089e-290b-55a05fd488e5’,‘1e1c4340-2faf-da9c-749f-55a05f401de6’,‘428fd1cd-70cf-0ff1-656a-55a05f6ac77e’,‘492486fd-044d-1758-da5f-55a05f424c4e’,‘df3dac1e-4f4c-5baa-30d4-55a05f9fd1ce’,‘e5c07fde-698e-392c-df22-55a05f1e3213’,‘261778b4-2d11-6520-7108-559f14d979f3’,‘d3d634f9-3476-78c0-3e1d-559f0f1f42ec’,‘3f57092a-3205-e86f-c27f-559dbbac35c8’,‘940ccdb0-9179-a62b-ce19-559c6a66cd01’,‘a93b1bc5-eb5c-bf2f-6841-559724ec814e’,‘e14502f1-371e-298c-bdf3-553836527095’,‘cd8e422f-342f-c95b-9a71-5435d72b741f’,‘159ee1fa-1afa-3e30-2926-541390695898’,‘b1b1a746-38b5-2700-449e-5410eddd5e6f’,‘97af722b-715f-011c-ea9f-537403bbfde5’,‘cab6a0ba-73e5-2e1a-a589-5374031e421d’,‘9ef18c56-2e23-7546-7987-5351c3237e02’,‘60be8ed1-9e03-0352-450c-5351c3a620bb’,‘1fb155dc-abd0-2516-e4f4-534c7d2b777e’,‘b6c71789-d1b3-3958-641a-533cab6e9a47’,‘c1d7154e-a01e-2fca-447f-53225b5578d0’,‘6dac09be-6cb4-9aa5-7a83-531fb8720de0’,‘5a2f83b1-8876-53cb-87e4-52954bfea00a’,‘5b61c29c-6e43-1423-9330-52954bb852f5’,‘844e6318-5970-5341-80ce-528380f3236b’,‘7b0f3375-b687-943b-affe-5283645a0e86’,‘6725b1a0-2f47-6bfc-292c-52836359752c’,‘cb09da32-d910-096c-240c-528362714d18’,‘1293007a-5f1e-f8c5-65c9-5283600fb881’,‘35427379-92c1-fc1f-4ada-52835f97f66f’,‘3099c9d9-260f-96c9-61b7-52835eab5ed1’,‘acca4b67-d3e6-8ba8-78ab-52835c488c2a’,‘90830638-e42b-3cd9-4a59-52835b696322’,‘b2506edb-7307-2dc2-dbc6-52835a5f12e5’,‘a11718f9-f007-38fb-d2bd-52835810ba83’,‘24605dbb-28d5-471d-434e-528357e05ba3’,‘a38b243f-e631-c4ed-0d93-528355cc6fad’,‘6e9ea25a-9549-f7b7-1943-5283532d1a53’,‘710b0a43-4883-c5cc-df6c-52835368af64’,‘190cca3d-b6d2-04c3-7aae-528351a69196’,‘56398ea0-1bc7-8df4-1a5c-52835182d36c’,‘b8909a0a-8e2e-332b-4eb8-528351a04fc0’,‘e5330cbe-fd89-a0e3-1c65-528348c5c783’,‘ae513b8b-68de-bdfc-765e-528347866111’,‘6ae3ef37-b4f9-e091-b6e3-52834454eee0’,‘48fa224e-202e-e9f6-cc96-528340ad04c4’,‘71e881b8-e5a8-a8a4-09ca-52833f421259’,‘5b240933-683d-4899-a662-52833fe935d5’,‘6d415ff5-a794-47b6-c703-524d26300e7d’,‘3545f57b-47ce-06bc-7497-5240dd31aba9’,‘dfac5a5a-d5b9-9177-11ac-5233ae288aaa’,‘465a9b99-32b4-4b30-a7eb-51f62f255b7f’,‘ba0f6118-56c5-30d1-ed0d-51f62fe503b3’,‘a321f79b-cdca-db4e-e165-51f62f72e519’,‘9edd209d-63b6-3f2c-3e84-51f62ed0f9b6’,‘751f14a7-480c-31d4-b984-51f62e527349’,‘6a094767-7ae3-9e11-c551-51f62e5c72a1’,‘28b93ce7-dbb7-1544-e502-51f62e02fa9b’,‘3f2309c3-8fd6-3c22-4e81-51f62d712111’,‘496a6af6-f5d0-cc63-5510-51f62d4ace87’,‘601ad87e-e997-231f-3853-51f62d93c2c4’,‘20059d2c-5f95-3605-6448-51f62d2ea87d’,‘b682036b-f448-739d-99bb-51f62db77b26’,‘b1719da9-3a49-21e3-8525-51f62c120683’,‘c256f39e-f23d-838e-ef6f-51f62cbad589’,‘87ff7d55-576c-d4e7-1f75-51f62bec6e55’,‘44adc1b4-bb55-324a-a0e2-51f62ba62144’,‘cdddc708-09c4-5308-9e55-51f629742d46’,‘94740882-bcd1-b0e5-39c9-51f6290131e1’,‘8c7be7a6-fae3-e69e-b12b-51f6295b1141’,‘980dc982-0776-2461-8ee6-51f628d19b5a’,‘b87aefae-1cf9-d546-7d85-51f62828fd6b’,‘7f662fef-02f6-e306-5207-51f628105485’,‘efd48f76-e23f-f21b-1ff5-51f627050293’,‘a9ad9a56-c2b1-58b2-9e0f-51f627367595’,‘d653d346-565d-d5f7-0aa1-51f627673df5’,‘d0ff134a-b938-da66-5d3f-51f626758b62’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name Query Failed: SELECT notes., contacts.first_name, contacts.last_name, users.user_name as assigned_user_name , notes_cstm.account_id_c, relJoin1.name compte1_c FROM notes LEFT JOIN contacts ON notes.contact_id=contacts.id LEFT JOIN users ON notes.assigned_user_id=users.id LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN accounts relJoin1 ON notes_cstm.account_id_c = relJoin1.id AND relJoin1.deleted=0 where notes.id in (‘b3b74e1a-ac01-e9f7-7acc-58a7233689aa’,‘3ec30a3f-ae82-0cdc-a8eb-58a720a3b477’,‘4a5c2e19-5cac-6339-9cb9-58a71f269a59’,‘ce7ec53f-8168-7878-56d5-58a71d20f501’,‘384b0274-d250-c51b-ba60-58a71df52ca8’,‘57ab92e8-9346-d6d6-caa9-58a71cef7b2c’,‘37d2ef35-f06e-12d5-a1a2-58a71ceec78e’,‘62d137e5-e558-c3e9-acbc-58a71b381882’,‘bd86e342-c410-d894-f57d-58a71bafce61’,‘14e15ba6-cb4e-95a3-8dc4-58a71af00b37’,‘211a15c1-faa8-28d0-dfe0-58a7166c73db’,‘dd532696-76ab-a713-4c86-58a713f6d1d5’,‘63f1a4c7-4a00-bcf2-ec5f-58a7121f8617’,‘7e1cf76e-d5db-742c-3ffe-58a7116e9fc8’,‘2cfda459-f9f1-0b23-1451-57430d24b8c8’,‘15467556-3fe0-0ae8-49c5-5601eb7e7596’,‘e005facb-6212-4784-09cb-55fb54ca0c51’,‘87fad972-4463-04ab-f43d-55ee278ce04d’,‘ba6199d4-2aad-cf88-3fce-55e8e1d23a80’,‘60557aaa-009c-355e-de10-55a6f67d4e96’,‘66c781c4-e8a8-a6d3-e2c0-55a6f65692c1’,‘9e83e9b4-c222-e548-68dc-55a05fb50406’,‘a53b82bf-a302-089e-290b-55a05fd488e5’,‘1e1c4340-2faf-da9c-749f-55a05f401de6’,‘428fd1cd-70cf-0ff1-656a-55a05f6ac77e’,‘492486fd-044d-1758-da5f-55a05f424c4e’,‘df3dac1e-4f4c-5baa-30d4-55a05f9fd1ce’,‘e5c07fde-698e-392c-df22-55a05f1e3213’,‘261778b4-2d11-6520-7108-559f14d979f3’,‘d3d634f9-3476-78c0-3e1d-559f0f1f42ec’,‘3f57092a-3205-e86f-c27f-559dbbac35c8’,‘940ccdb0-9179-a62b-ce19-559c6a66cd01’,‘a93b1bc5-eb5c-bf2f-6841-559724ec814e’,‘e14502f1-371e-298c-bdf3-553836527095’,‘cd8e422f-342f-c95b-9a71-5435d72b741f’,‘159ee1fa-1afa-3e30-2926-541390695898’,‘b1b1a746-38b5-2700-449e-5410eddd5e6f’,‘97af722b-715f-011c-ea9f-537403bbfde5’,‘cab6a0ba-73e5-2e1a-a589-5374031e421d’,‘9ef18c56-2e23-7546-7987-5351c3237e02’,‘60be8ed1-9e03-0352-450c-5351c3a620bb’,‘1fb155dc-abd0-2516-e4f4-534c7d2b777e’,‘b6c71789-d1b3-3958-641a-533cab6e9a47’,‘c1d7154e-a01e-2fca-447f-53225b5578d0’,‘6dac09be-6cb4-9aa5-7a83-531fb8720de0’,‘5a2f83b1-8876-53cb-87e4-52954bfea00a’,‘5b61c29c-6e43-1423-9330-52954bb852f5’,‘844e6318-5970-5341-80ce-528380f3236b’,‘7b0f3375-b687-943b-affe-5283645a0e86’,‘6725b1a0-2f47-6bfc-292c-52836359752c’,‘cb09da32-d910-096c-240c-528362714d18’,‘1293007a-5f1e-f8c5-65c9-5283600fb881’,‘35427379-92c1-fc1f-4ada-52835f97f66f’,‘3099c9d9-260f-96c9-61b7-52835eab5ed1’,‘acca4b67-d3e6-8ba8-78ab-52835c488c2a’,‘90830638-e42b-3cd9-4a59-52835b696322’,‘b2506edb-7307-2dc2-dbc6-52835a5f12e5’,‘a11718f9-f007-38fb-d2bd-52835810ba83’,‘24605dbb-28d5-471d-434e-528357e05ba3’,‘a38b243f-e631-c4ed-0d93-528355cc6fad’,‘6e9ea25a-9549-f7b7-1943-5283532d1a53’,‘710b0a43-4883-c5cc-df6c-52835368af64’,‘190cca3d-b6d2-04c3-7aae-528351a69196’,‘56398ea0-1bc7-8df4-1a5c-52835182d36c’,‘b8909a0a-8e2e-332b-4eb8-528351a04fc0’,‘e5330cbe-fd89-a0e3-1c65-528348c5c783’,‘ae513b8b-68de-bdfc-765e-528347866111’,‘6ae3ef37-b4f9-e091-b6e3-52834454eee0’,‘48fa224e-202e-e9f6-cc96-528340ad04c4’,‘71e881b8-e5a8-a8a4-09ca-52833f421259’,‘5b240933-683d-4899-a662-52833fe935d5’,‘6d415ff5-a794-47b6-c703-524d26300e7d’,‘3545f57b-47ce-06bc-7497-5240dd31aba9’,‘dfac5a5a-d5b9-9177-11ac-5233ae288aaa’,‘465a9b99-32b4-4b30-a7eb-51f62f255b7f’,‘ba0f6118-56c5-30d1-ed0d-51f62fe503b3’,‘a321f79b-cdca-db4e-e165-51f62f72e519’,‘9edd209d-63b6-3f2c-3e84-51f62ed0f9b6’,‘751f14a7-480c-31d4-b984-51f62e527349’,‘6a094767-7ae3-9e11-c551-51f62e5c72a1’,‘28b93ce7-dbb7-1544-e502-51f62e02fa9b’,‘3f2309c3-8fd6-3c22-4e81-51f62d712111’,‘496a6af6-f5d0-cc63-5510-51f62d4ace87’,‘601ad87e-e997-231f-3853-51f62d93c2c4’,‘20059d2c-5f95-3605-6448-51f62d2ea87d’,‘b682036b-f448-739d-99bb-51f62db77b26’,‘b1719da9-3a49-21e3-8525-51f62c120683’,‘c256f39e-f23d-838e-ef6f-51f62cbad589’,‘87ff7d55-576c-d4e7-1f75-51f62bec6e55’,‘44adc1b4-bb55-324a-a0e2-51f62ba62144’,‘cdddc708-09c4-5308-9e55-51f629742d46’,‘94740882-bcd1-b0e5-39c9-51f6290131e1’,‘8c7be7a6-fae3-e69e-b12b-51f6295b1141’,‘980dc982-0776-2461-8ee6-51f628d19b5a’,‘b87aefae-1cf9-d546-7d85-51f62828fd6b’,‘7f662fef-02f6-e306-5207-51f628105485’,‘efd48f76-e23f-f21b-1ff5-51f627050293’,‘a9ad9a56-c2b1-58b2-9e0f-51f627367595’,‘d653d346-565d-d5f7-0aa1-51f627673df5’,‘d0ff134a-b938-da66-5d3f-51f626758b62’) AND notes.deleted=0 AND (contacts.deleted IS NULL OR contacts.deleted=0) ORDER BY notes.name: MySQL error 1054: Unknown column ‘notes_cstm.account_id_c’ in ‘field list’
Mon Oct 9 16:31:18 2017 [4139][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:31:31 2017 [4259][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:38:09 2017 [4259][1][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:39:47 2017 [4891][21e27c0a-2562-21a8-0e2e-4b125de8c700][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:45:13 2017 [4565][1][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:46:01 2017 [4084][1][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Mon Oct 9 16:47:21 2017 [4891][1][FATAL] Failed to load original or custom subpanel data for kbdocuments in modules/KBDocuments/metadata/subpanels/default.php
Hi,
the error is "Unknown column ’ notes_cstm.account_id_c’ in ‘on clause’ ". Have you try to Rebuild relationship ?! seems that the CRM had lose the custom relation between Accounts and Notes.
1 Like
Hhmm I don’t think that’s the Relationship.
notes_cstm are the extensions you make to the notes table, normally these are additional (custom) fields.
It seems there’s a field there called account_id_c (this “_c” suffix is also typical of custom fields) that is not found.
After the Quick Repair and Rebuild, you need to scroll down to the bottom to see if there is a button there to “sync vardefs with database”, or something like that. If it’s there, press it. If not, try cleaning up any unnecessary custom fields from the Notes module.
Hi pgr,
account_id_c is the field create in the table when you create a “relate” field by studio (related to account). You can see that is a related field also by the query, there is a join with accounts table.
After an upgrade i had resolve manualy some errors like these but is not so simple. Is necessary to recreate manually all the files for the relations inside custom folder.
2 Likes