Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Invalid Controls: T...
 
Notifications
Clear all

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

5 Posts
2 Users
0 Reactions
1,219 Views
(@mvrka4)
Posts: 8
Active Member
Topic starter
 
[#9708]

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:xampphtdocsbbhal24modelpersistenceSqlElement.php:3082]
2025-01-21 00:22:34.714 ** ERROR ** [V11.4.2] [1]    #1 SqlElement->getSqlElementsFromCriteria called at [C:xampphtdocsbbhal24modelBillMain.php:459]
2025-01-21 00:22:34.714 ** ERROR ** [V11.4.2] [1]    #2 BillMain->save called at [C:xampphtdocsbbhal24toolsaveObject.php:124]

unfortuately, I dont know that this means.

 


 
Posted : 21 Jan 2025 9H31
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

Try and upgrade to V11.4.4


 
Posted : 21 Jan 2025 18H15
(@mvrka4)
Posts: 8
Active Member
Topic starter
 

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:xampphtdocsbbhal24modelpersistenceSqlElement.php:3101]
2025-01-27 01:01:23.313 ** ERROR ** [V11.4.4] [1]    #1 SqlElement->getSqlElementsFromCriteria called at [C:xampphtdocsbbhal24modelBillMain.php:459]
2025-01-27 01:01:23.313 ** ERROR ** [V11.4.4] [1]    #2 BillMain->save called at [C:xampphtdocsbbhal24toolsaveObject.php:124]
   

 


 
Posted : 27 Jan 2025 10H06
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

OK,
Issue confirmed (on PostgreSql is seems)
Will be fixed on next patch.
Fix is already available through subscription service.

 


 
Posted : 07 Feb 2025 22H43
(@mvrka4)
Posts: 8
Active Member
Topic starter
 

Awesome. Thank you for your help.


 
Posted : 08 Feb 2025 4H31
Share:

Scroll to Top