david18 - Profile

Support November 18th, 2021 @ 3:57 pm

"Has Changed" for Salary works well, thank you. A small issue in Approval Jobs (probably my environment). I did remove version 1.0. On viewing an 'Approval Job' from the Approval Jobs List is get a database error reported - please check suitecrm.log. Looks like a DATETIME problem, but only a suggestion.

suitecrm.log

Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Retrieve UT_AppRules : SELECT ut_apprules.* FROM ut_apprules WHERE ut_apprules.id = '2fdcefd0-39ad-c232-41af-619675ef4699' AND ut_apprules.deleted=0 Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Limit Query:SELECT ut_apprules.* FROM ut_apprules WHERE ut_apprules.id = '2fdcefd0-39ad-c232-41af-619675ef4699' AND ut_apprules.deleted=0 Start: 0 count: 1 Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query:SELECT ut_apprules.* FROM ut_apprules WHERE ut_apprules.id = '2fdcefd0-39ad-c232-41af-619675ef4699' AND ut_apprules.deleted=0 LIMIT 0,1 Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query Execution Time:0.00037407875061035 Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] SugarBean[UT_AppRules].load_relationships, Loading relationship (ut_appprocess_ut_apprulesut_appprocess_ida). Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query:SELECT ut_appprocess_ut_apprulesut_appprocess_ida id FROM ut_appprocess_ut_apprules_c WHERE ut_appprocess_ut_apprules_c.ut_appprocess_ut_apprulesut_apprules_idb = '2fdcefd0-39ad-c232-41af-619675ef4699' AND ut_appprocess_ut_apprules_c.deleted=0 Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query Execution Time:0.00035405158996582 Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] rebuilding cache for UT_AppProcess Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='UT_AppProcess' AND deleted = 0 Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query Execution Time:0.00025296211242676 Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query:SELECT id ,ut_appprocess.name as ut_appprocess_ut_apprules_name , ut_appprocess.assigned_user_id owner FROM ut_appprocess WHERE deleted=0 AND id='6079d839-1d07-1d46-d077-619675349aee' Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query Execution Time:0.00019598007202148 Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Hook called: UT_AppRules::after_retrieve Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query:SELECT * FROM ut_apphistory WHERE deleted = '0' AND approval_time IS NOT NULL AND approval_time <> '' AND approval_process_id = '6079d839-1d07-1d46-d077-619675349aee' AND approval_rule_id = '2fdcefd0-39ad-c232-41af-619675ef4699' AND approval_record_id = 'd3c25cef-7183-f59f-0aad-61967553d76b' ORDER BY approval_time ASC Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Mysqli_query failed, error was: MySQL error 1525: Incorrect DATETIME value: '', query was: Thu Nov 18 15:50:13 2021 [121071][1][FATAL] Mysqli_query failed. Thu Nov 18 15:50:13 2021 [121071][1][INFO] Query Execution Time:0.00017881393432617 Thu Nov 18 15:50:13 2021 [121071][1][FATAL] Query Failed: SELECT * FROM ut_apphistory WHERE deleted = '0' AND approval_time IS NOT NULL AND approval_time <> '' AND approval_process_id = '6079d839-1d07-1d46-d077-619675349aee' AND approval_rule_id = '2fdcefd0-39ad-c232-41af-619675ef4699' AND approval_record_id = 'd3c25cef-7183-f59f-0aad-61967553d76b' ORDER BY approval_time ASC: MySQL error 1525: Incorrect DATETIME value: '' Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Hook called: ::server_round_trip Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Calling MySQLi::disconnect() Thu Nov 18 15:50:13 2021 [121071][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:409 Thu Nov 18 15:50:13 2021 [121071][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu Nov 18 15:50:13 2021 [121071][1][DEBUG] Hook called: UT_AppHistory::handle_exception

View Comment

Approve a field change

Support November 18th, 2021 @ 1:48 pm

That is remarkable! I will download V1.1 and test the "Has Changed" functionality. Forgive me if you do not get an immediate response - I will be out of the office until early December. Many thanks for this excellent support.

David

View Comment

Approve a field change

Support November 17th, 2021 @ 2:27 pm

Thank you for the prompt reply. Perhaps another way of doing this would be to create a SuiteCRM Workflow Action to trigger the Approval Process. Current Workflow Actions are to EMail, Create and Amend record. The Condition filter would be 'Salary' 'Equal To' 'Any Change' (though have not tried this out!)

regards,

David

View Comment

No Projects displayed in Planner

Support September 20th, 2021 @ 8:37 am

Any help available? If this addon no longer works please let me know.

View Comment

Not Working

Support July 29th, 2021 @ 8:21 am

Thanks for your response. 1. I did have an overlap - now removed. 2. Version 7.11.18 Sugar Version 6.5.25 (Build 344) 3.No browser errors 4. Can you email me at david @ reasyst.com and I can setup an account for you 5. Yes, I did see the filter option but Project Task List does not have a filter, unless I am mistaken...

regards,

David

View Comment

Not Working

Support July 20th, 2021 @ 1:42 pm

Was this resolved? If so, how? Just installed Kanban View, done quick repair, JS Groupin repair and used a brand new browser. I have created a basic Project Tasks / Status Kanban and it looks as above. No right mouse click menu, no colour and no drag and drop. Tried in Developer and non Developer mode.

Also, can you filter by Project name? i.e. I only want Tasks from a particular Project.

View Comment