Delete Custom Relate Fields

English Language - Forum
1

Hello.

I am working with suiteCRM for a while and I am facing an issue which I can’t figure out how to tackle it.

When I try to export the Projects list I am getting this error: Database failure. Please refer to suitecrm.log for details.

It seems that he problem i caused by a custom field of type Relate I created. When I try to delete this through the Studio though, i am getting this error:

An error has occurred
Unable to load widget for ‘Project’ : ‘’

Any idea of why this is happening and how I can solve it?

Thanks,
George

2

Check if you have those data in the database.

Also, you can check your DB config in config.php file. Maybe you defined something wrong.

1 Like
3

Thank you very much for the reply. I didn’t manage to find something that could help. This is the output in my suitecrm.log file:

project.*,
                users.user_name as assigned_user_name , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) cyi_pi_c , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin2.first_name,''),' ',IFNULL(relJoin2.last_name,'')))) cyi_pi_new_c , project_cstm., relJoin3.name project_manager_c , project_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin4.first_name,''),' ',IFNULL(relJoin4.last_name,'')))) project_manager_new_c , project_cstm.opportunity_id_c, relJoin5.name proposal_new_c  FROM project  LEFT JOIN project_cstm ON project.id = project_cstm.id_c  LEFT JOIN users relJoin1 ON project_cstm. = relJoin1.id AND relJoin1.deleted=0  LEFT JOIN users relJoin2 ON project_cstm. = relJoin2.id AND relJoin2.deleted=0  LEFT JOIN jjwg_address_cache relJoin3 ON project_cstm. = relJoin3.id AND relJoin3.deleted=0  LEFT JOIN users relJoin4 ON project_cstm.user_id_c = relJoin4.id AND relJoin4.deleted=0  LEFT JOIN opportunities relJoin5 ON project_cstm.opportunity_id_c = relJoin5.id AND relJoin5.deleted=0  LEFT JOIN users
                   	ON project.assigned_user_id=users.id where (project.id in ('dca5005c-743d-4c79-4ed3-65e59655ab6f','4749f932-c9f4-b2d3-aa1e-65c6149fdf0a')) AND  project.deleted=0  Query Failed: SELECT
				project.*,
                users.user_name as assigned_user_name , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) cyi_pi_c , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin2.first_name,''),' ',IFNULL(relJoin2.last_name,'')))) cyi_pi_new_c , project_cstm., relJoin3.name project_manager_c , project_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin4.first_name,''),' ',IFNULL(relJoin4.last_name,'')))) project_manager_new_c , project_cstm.opportunity_id_c, relJoin5.name proposal_new_c  FROM project  LEFT JOIN project_cstm ON project.id = project_cstm.id_c  LEFT JOIN users relJoin1 ON project_cstm. = relJoin1.id AND relJoin1.deleted=0  LEFT JOIN users relJoin2 ON project_cstm. = relJoin2.id AND relJoin2.deleted=0  LEFT JOIN jjwg_address_cache relJoin3 ON project_cstm. = relJoin3.id AND relJoin3.deleted=0  LEFT JOIN users relJoin4 ON project_cstm.user_id_c = relJoin4.id AND relJoin4.deleted=0  LEFT JOIN opportunities relJoin5 ON project_cstm.opportunity_id_c = relJoin5.id AND relJoin5.deleted=0  LEFT JOIN users
                   	ON project.assigned_user_id=users.id where (project.id in ('dca5005c-743d-4c79-4ed3-65e59655ab6f','4749f932-c9f4-b2d3-aa1e-65c6149fdf0a')) AND  project.deleted=0 : MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_n...' at line 3
Mon Mar  4 15:44:33 2024 [140301][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:44:33 2024 [140301][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Mar  4 15:45:05 2024 [139557][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:45:05 2024 [139557][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:45:12 2024 [139406][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:45:12 2024 [139406][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:45:38 2024 [139406][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:45:38 2024 [139406][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:45:53 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] error loading relationship quotes
Mon Mar  4 15:45:53 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] error loading relationship quotes
Mon Mar  4 15:46:13 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:46:13 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:48:28 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:48:28 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:52:06 2024 [140207][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:52:06 2024 [140207][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:52:13 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:52:13 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:52:20 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:52:20 2024 [140179][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 15:53:04 2024 [140211][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 15:53:04 2024 [140211][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 16:03:07 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Mysqli_query failed.
Mon Mar  4 16:03:07 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Error exporting Project: <BR>.SELECT
				project.*,
                users.user_name as assigned_user_name , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) cyi_pi_c , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin2.first_name,''),' ',IFNULL(relJoin2.last_name,'')))) cyi_pi_new_c , project_cstm., relJoin3.name project_manager_c , project_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin4.first_name,''),' ',IFNULL(relJoin4.last_name,'')))) project_manager_new_c , project_cstm.opportunity_id_c, relJoin5.name proposal_new_c  FROM project  LEFT JOIN project_cstm ON project.id = project_cstm.id_c  LEFT JOIN users relJoin1 ON project_cstm. = relJoin1.id AND relJoin1.deleted=0  LEFT JOIN users relJoin2 ON project_cstm. = relJoin2.id AND relJoin2.deleted=0  LEFT JOIN jjwg_address_cache relJoin3 ON project_cstm. = relJoin3.id AND relJoin3.deleted=0  LEFT JOIN users relJoin4 ON project_cstm.user_id_c = relJoin4.id AND relJoin4.deleted=0  LEFT JOIN opportunities relJoin5 ON project_cstm.opportunity_id_c = relJoin5.id AND relJoin5.deleted=0  LEFT JOIN users
                   	ON project.assigned_user_id=users.id where (project.id in ('87cb592e-1061-8342-d88f-65e5d49d106a')) AND  project.deleted=0  Query Failed: SELECT
				project.*,
                users.user_name as assigned_user_name , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) cyi_pi_c , project_cstm., LTRIM(RTRIM(CONCAT(IFNULL(relJoin2.first_name,''),' ',IFNULL(relJoin2.last_name,'')))) cyi_pi_new_c , project_cstm., relJoin3.name project_manager_c , project_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin4.first_name,''),' ',IFNULL(relJoin4.last_name,'')))) project_manager_new_c , project_cstm.opportunity_id_c, relJoin5.name proposal_new_c  FROM project  LEFT JOIN project_cstm ON project.id = project_cstm.id_c  LEFT JOIN users relJoin1 ON project_cstm. = relJoin1.id AND relJoin1.deleted=0  LEFT JOIN users relJoin2 ON project_cstm. = relJoin2.id AND relJoin2.deleted=0  LEFT JOIN jjwg_address_cache relJoin3 ON project_cstm. = relJoin3.id AND relJoin3.deleted=0  LEFT JOIN users relJoin4 ON project_cstm.user_id_c = relJoin4.id AND relJoin4.deleted=0  LEFT JOIN opportunities relJoin5 ON project_cstm.opportunity_id_c = relJoin5.id AND relJoin5.deleted=0  LEFT JOIN users
                   	ON project.assigned_user_id=users.id where (project.id in ('87cb592e-1061-8342-d88f-65e5d49d106a')) AND  project.deleted=0 : MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_n...' at line 3
Mon Mar  4 16:03:07 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 16:03:07 2024 [140302][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Mar  4 16:04:27 2024 [140207][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 16:04:27 2024 [140207][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Mon Mar  4 22:30:39 2024 [140302][3dcf0e38-26d2-2f4e-30d6-65251f5a498b][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Mon Mar  4 22:30:39 2024 [140302][3dcf0e38-26d2-2f4e-30d6-65251f5a498b][FATAL] Exception in Controller: Error retrieving record. This record may be deleted or you may not be authorized to view it.
Tue Mar  5 00:02:28 2024 [141821][-none-][FATAL] SECURITY: User authentication for c.stylianou@cyi.ac.cy failed
Tue Mar  5 00:02:28 2024 [141821][-none-][FATAL] FAILED LOGIN:attempts[1], ip[192.168.200.132], username[c.stylianou@cyi.ac.cy]
Wed Mar  6 12:07:24 2024 [146659][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Wed Mar  6 12:07:24 2024 [146659][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
Wed Mar  6 12:41:31 2024 [146659][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:397
Wed Mar  6 12:41:31 2024 [146659][30b7fd8a-8c03-4863-eec5-641d66b7c384][FATAL] Exception in Controller: Unable to load widget for 'Project' : ''
4

Please share your exact versions of

  • SuiteCRM
  • PHP
  • MySQL

These errors were frequent a few months ago, it had to do with specific versions, I believe.

1 Like
5

I managed to find these:

sugar_version: 6.5.25
suitecrm_version: 7.13.2

6

You should have this:

suitecrm_7_13_x

1 Like
7

my version is 7.13.2, isn’t it? I found that in the config.php