Command Info

Name: affiliate:sync-all

Description: Sync websites from domains to mysql and create/update affiliate links with correct website associations

Status: completed

Start Time: 2026-06-30 12:55:45

End Time: 2026-06-30 12:55:46

Total Time: 1 second

Dispatched Jobs Count: 0

Successful Jobs Count: 0

Failed Jobs Count: 0

Output

12:55:45 Lock acquired for command: affiliate:sync-all
12:55:45 Starting complete affiliate system synchronization...
12:55:45 Step 1: Syncing websites from domains to mysql...
12:55:45 Error syncing websites: SQLSTATE[HY000] [1044] Access denied for user 'kokos'@'%' to database 'domains' (Connection: domains, Host: 127.0.0.1, Port: 3306, Database: domains, SQL: select count(*) as aggregate from `websites`)
12:55:45 Step 2: Cleaning up orphan affiliate links...
12:55:45 Found 468 affiliate links in mysql database
12:55:45 Loading domains affiliate links data...
12:55:45 Error cleaning up orphan links: SQLSTATE[HY000] [1044] Access denied for user 'kokos'@'%' to database 'domains' (Connection: domains, Host: 127.0.0.1, Port: 3306, Database: domains, SQL: select `al`.`id`, `al`.`website_id`, `w`.`hostname` as `correct_hostname` from `affiliate_links` as `al` left join `websites` as `w` on `al`.`website_id` = `w`.`id`)
12:55:45 Step 3: Syncing affiliate links with correct website associations...
12:55:45 Error syncing affiliate links: SQLSTATE[HY000] [1044] Access denied for user 'kokos'@'%' to database 'domains' (Connection: domains, Host: 127.0.0.1, Port: 3306, Database: domains, SQL: select `id` from `affiliate_links`)
12:55:45 Complete synchronization finished!
12:55:45 Complete synchronization finished!
12:55:45 Lock released for affiliate:sync-all