Cron job for Campaign Manager

Need Help
#1

Hello,
I have a cron job issue that I can’t get to work.
I need a cron job to run the Campaign Manager plugin.

I am executing the task via Cron Job in Cpanel.
Here is one of several tests I tried:

/usr/local/bin/php /home/[myWebSite]/public_html/artisan campaign:run 2>&1

The email received:


In Connection.php line 760:

 Database file at path [storage/database.sqlite] does not exist. Ensure this  
  is an absolute path to the database. (SQL: PRAGMA foreign_keys = ON;)       

In SQLiteConnector.php line 34:
 Database file at path [storage/database.sqlite] does not exist. Ensure this  
  is an absolute path to the database.

If anyone has a solution, it would be greatly appreciated.

thank’s

#2

Hi @Cyan

It looks like your command line environment is configured to use SQLite. Check that the .env configuration is being loaded correctly.

1 Like
#3

Hi @daft

Thank you for the tip. Indeed, the issue was resolved by modifying the .env file. I changed the following:
DB_DATABASE=/storage/database.sqlite
To an absolute path:
DB_DATABASE=/home/[Name]/public_html/storage/database.sqlite

The cron job:
/usr/local/bin/php /home/[Name]/public_html/artisan campaign:run > /dev/null 2>&1

And everything is now working perfectly! Thank you!