Invoice reminders not sent

Yes, I posted the config further up and we checked the output.

Here are the crontab entries:
4-59/5 * * * * cd /home/beechesit/domains/accounts.beeches.it && /usr/bin/php -d register_argc_argv=On artisan schedule:run >> /dev/null 2>&1
3-59/5 * * * * cd /home/beechesit/domains/accounts.beeches.it && /usr/bin/php -d register_argc_argv=On artisan queue:work --stop-when-empty

I suspect this is the root cause:
[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘accounts.jobs’ doesn’t exist at /home/beechesit/domains/accounts.beeches.it/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)

If the queue is set to sync then I don’t believe the jobs table is needed.

@david do you have any suggestions?

Does it matter if this is in my .env file:

INTERNAL_QUEUE_ENABLED=false

I set that following the advice from here Free Source Available Invoicing, Expenses & Time-Tracking | Invoice Ninja to get the supervisor working.

Ooh, I found this in /var/log/invoiceninja-worker.log (in the server root, not the site root)

In Connection.php line 829:
                                                                               
  SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: s  
  elect table_name as `name`, (data_length + index_length) as `size`, table_c  
  omment as `comment`, engine as `engine`, table_collation as `collation` fro  
  m information_schema.tables where table_schema = 'accounts' and table_type   
  in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)                   
                                                                               

In Connector.php line 65:
                                                    
  SQLSTATE[HY000] [2002] No such file or directory  
                                                    

  2024-06-27 08:25:16 App\Listeners\Contact\UpdateContactLastLogin ... RUNNING
  2024-06-27 08:25:16 App\Listeners\Contact\UpdateContactLastLogin  111.87ms DONE
  2024-06-27 08:25:16 App\Listeners\Misc\InvitationViewedListener .... RUNNING
  2024-06-27 08:25:16 App\Listeners\Misc\InvitationViewedListener  108.26ms DONE
  2024-06-27 08:25:21 App\Listeners\Invoice\InvoiceViewedActivity .... RUNNING
  2024-06-27 08:25:22 App\Listeners\Invoice\InvoiceViewedActivity .... 1s DONE

invoiceninja-worker.log.txt (5.0 MB)
Here’s the whole worker log in case it’s useful. Didn’t know it was there.

Perhaps a more relevant error message is this penultimate one from laravel.log

[2024-07-09 13:40:27] production.ERROR: Call to undefined method Illuminate\Console\View\Components\Task::runTimeForHumans() {"userId":1,"exception":"[object] (Error(code: 0): Call to undefined method Illuminate\\Console\\View\\Components\\Task::runTimeForHumans() at /home/beechesit/domains/accounts.beeches.it/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php:45)

The whole file is attached above.