View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Invalid Controls: This invoice should not be empty (enter some lines) - ProjeQtOr
 

Invalid Controls: This invoice should not be empty (enter some lines)

More
21 Jan 2025 07:31 - 21 Jan 2025 07:39 #1 by mvrka4
Happy New Year to everyone. I am starting off the new year with new issues.

I am trying to create new client invoices. And while I was able to create invoices before. Attached image 01
When I try to add a new invoice, regardless of project or invoice type. I get a red box error which says
"Invalid Controls: This invoice should not be empty (enter some lines)"

I attempted to recreate invoices I was previously able to make. Using all the same (switches, for lack of better name), Project, invoice type, etc.... just changing the name.
Still get the same error.

How it worked before:
Add all the information I could, Project, name, payment deadline etc. then I would have to hit the save icon BEFORE I could add any invoice lines.
Once it was recorded, I could go back and add the invoice lines. And everything worked dandy.

Now, doesn't matter which previously made invoice I attempt to recreate, or which new one. I hit the save icon and I get the error about invalid controls.
Regardless of invoice type, or project type.

I went back and looked at the client invoice types, project types (was set to manual invoicing). Tried other projects, with different invoicing types, time & materials, capped T&M,
still get the error.

I can invoice providers....

I guess my question is.....is there a switch I might be missing that would cause this behavior? I may be missing something....

Thanks for you help.

Found this too:
2025-01-21 00:22:34.713 ***** ERROR ***** [V11.4.2] [1] 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 MariaDB server version for the right syntax to use near 'and workcommandbilled.idWorkcommand=workcommand.id)' at line 1
2025-01-21 00:22:34.713 ***** ERROR ***** [V11.4.2] [1]    For query : select * from workcommand where  exists (select 'x' from workcommandbilled where idBill= and workcommandbilled.idWorkcommand=workcommand.id)
2025-01-21 00:22:34.713 ***** ERROR ***** [V11.4.2] [1]    Strack trace :
2025-01-21 00:22:34.713 ***** ERROR ***** [V11.4.2] [1]    #0 Sql->query called at [C:\xampp\htdocs\bb\hal24\model\persistence\SqlElement.php:3082]
2025-01-21 00:22:34.714 ***** ERROR ***** [V11.4.2] [1]    #1 SqlElement->getSqlElementsFromCriteria called at [C:\xampp\htdocs\bb\hal24\model\BillMain.php:459]
2025-01-21 00:22:34.714 ***** ERROR ***** [V11.4.2] [1]    #2 BillMain->save called at [C:\xampp\htdocs\bb\hal24\tool\saveObject.php:124]

unfortuately, I dont know that this means.




 
Attachments:
Last edit: 21 Jan 2025 07:39 by mvrka4.

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

More
21 Jan 2025 16:15 #2 by babynus
Try and upgrade to V11.4.4

Babynus
Administrator of ProjeQtOr web site

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

More
27 Jan 2025 08:06 #3 by mvrka4
Downloaded a fresh copy from download link.
Copied all files. Did not warn about an upgrade in progress.
Logged in fine. Tried to make a new invoice as I described in a previous post.
No luck. Here is what the log file says now:
2025-01-27 01:01:23.311 ***** ERROR ***** [V11.4.4] [1] 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 MariaDB server version for the right syntax to use near 'and workcommandbilled.idWorkcommand=workcommand.id)' at line 1
2025-01-27 01:01:23.312 ***** ERROR ***** [V11.4.4] [1]    For query : select * from workcommand where  exists (select 'x' from workcommandbilled where idBill= and workcommandbilled.idWorkcommand=workcommand.id)
2025-01-27 01:01:23.313 ***** ERROR ***** [V11.4.4] [1]    Strack trace :
2025-01-27 01:01:23.313 ***** ERROR ***** [V11.4.4] [1]    #0 Sql->query called at [C:\xampp\htdocs\bb\hal24\model\persistence\SqlElement.php:3101]
2025-01-27 01:01:23.313 ***** ERROR ***** [V11.4.4] [1]    #1 SqlElement->getSqlElementsFromCriteria called at [C:\xampp\htdocs\bb\hal24\model\BillMain.php:459]
2025-01-27 01:01:23.313 ***** ERROR ***** [V11.4.4] [1]    #2 BillMain->save called at [C:\xampp\htdocs\bb\hal24\tool\saveObject.php:124]
   
 

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

More
07 Feb 2025 20:43 #4 by babynus
OK,
Issue confirmed (on PostgreSql is seems)
Will be fixed on next patch.
Fix is already available through subscription service.

 

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

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

More
08 Feb 2025 02:31 #5 by mvrka4
Awesome. Thank you for your help.

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

Moderators: babynusprotion
Time to create page: 0.035 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.