View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Assistance Required: Error While Deleting Leave Types - ProjeQtOr
 

Assistance Required: Error While Deleting Leave Types

More
27 Nov 2024 12:21 - 27 Nov 2024 12:50 #1 by chandrashekhar
Hi,I am trying to delete various leave types from "Leave Type," but an error message appears (please see the attached screenshot).For your reference, also refer to a log file records as below. Your assistance is essential to resolving this issue.

2024-11-27 16:42:35.752 ***** ERROR ***** [V11.4.2] [19] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
2024-11-27 16:42:35.753 ***** ERROR ***** [V11.4.2] [19]    For query : delete from assignment where refType = 'Activity' and refId = 
2024-11-27 16:42:35.753 ***** ERROR ***** [V11.4.2] [19]    Strack trace :
2024-11-27 16:42:35.754 ***** ERROR ***** [V11.4.2] [19]    #0 Sql->query called at [C:\Apache24\htdocs\projeqtor\model\persistence\SqlElement.php:2310]
2024-11-27 16:42:35.754 ***** ERROR ***** [V11.4.2] [19]    #1 SqlElement->purgeSqlElement called at [C:\Apache24\htdocs\projeqtor\model\persistence\SqlElement.php:1168]
2024-11-27 16:42:35.754 ***** ERROR ***** [V11.4.2] [19]    #2 SqlElement->purge called at [C:\Apache24\htdocs\projeqtor\model\LeaveTypeMain.php:589]
2024-11-27 16:42:35.755 ***** ERROR ***** [V11.4.2] [19]    #3 LeaveTypeMain->delete called at [C:\Apache24\htdocs\projeqtor\tool\deleteObject.php:77]

Note: ProjeQtOr Version, we are using is: 11.4.2
Attachments:
Last edit: 27 Nov 2024 12:50 by chandrashekhar. Reason: Added ProjeQtOr version information.

Please Log in or Create an account to join the conversation.

More
27 Nov 2024 14:45 #2 by babynus
Ticket recorded

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: chandrashekhar

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.218 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.