Errors when creating a recurring invoice or new client.

litechforce

[Tue Apr 15 12:57:32.073292 2025] [php:error] [pid 138817] [client 192.168.4.5:58748] PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect date value: '' for column `itflow`.`domains`.`domain_expire` at row 1 in /var/www/portal.litechforce.com/post/user/client.php:93\nStack trace:\n#0 /var/www/portal.litechforce.com/post/user/client.php(93): mysqli_query()\n#1 /var/www/portal.litechforce.com/post.php(49): require_once('...')\n#2 {main}\n thrown in /var/www/portal.litechforce.com/post/user/client.php on line 93, referer: https://portal.litechforce.com/clients.php

[Tue Apr 15 12:59:03.662803 2025] [php:warn] [pid 138750] [client 192.168.4.5:58792] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoices.php?client_id=15

[Tue Apr 15 12:59:03.666555 2025] [php:warn] [pid 138750] [client 192.168.4.5:58792] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoices.php?client_id=15

[Tue Apr 15 12:59:42.251262 2025] [php:warn] [pid 138742] [client 192.168.4.5:58809] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 12:59:42.252669 2025] [php:warn] [pid 138742] [client 192.168.4.5:58809] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 12:59:53.489770 2025] [php:warn] [pid 138751] [client 192.168.4.5:58812] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/post/user/invoice.php on line 1517, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 12:59:53.554622 2025] [php:warn] [pid 138751] [client 192.168.4.5:58812] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 12:59:53.555889 2025] [php:warn] [pid 138751] [client 192.168.4.5:58812] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 13:00:16.308124 2025] [php:warn] [pid 138745] [client 192.168.4.5:58817] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoices.php

[Tue Apr 15 13:00:16.309510 2025] [php:warn] [pid 138745] [client 192.168.4.5:58817] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoices.php

[Tue Apr 15 13:00:32.020909 2025] [php:warn] [pid 138744] [client 192.168.4.5:58824] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 13:00:32.023079 2025] [php:warn] [pid 138744] [client 192.168.4.5:58824] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 13:00:46.425292 2025] [php:warn] [pid 138743] [client 192.168.4.5:58836] PHP Warning: Undefined variable $config_recurring_invoice_auto_send_invoice in /var/www/portal.litechforce.com/recurring_invoice.php on line 128, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

[Tue Apr 15 13:00:46.426405 2025] [php:warn] [pid 138743] [client 192.168.4.5:58836] PHP Warning: Undefined variable $recurring_note in /var/www/portal.litechforce.com/modals/recurring_invoice_note_modal.php on line 14, referer: https://portal.litechforce.com/recurring_invoice.php?recurring_invoice_id=5

wrongecho

Hello, are you able to reproduce this on the demo?

If not, it's probably not bug but a problem with your installation. What does your debug page say? What app/database version are you on?

litechforce

wrongecho

What are the errors you get when creating the recurring invoice? The only fatal error there is about the client domain name expiry (which you still shouldn't be getting, but trying to narrow things down).

I'm interested if this is a wider issue with dates in general, can you create recurring tickets?