Error accepting new orders - SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null

[xtianfab]

Hello,

I am currently having issues accepting orders. When an order is placed it creates the account on the cPanel/WHM side but WHMCS gives me errors.

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null (SQL: insert into `tbloauthserver_clients` (`identifier`, `secret`, `user_id`, `service_id`, `rsa_key_pair_id`, `name`, `description`, `logo_uri`, `redirect_uri`, `grant_types`, `updated_at`, `created_at`) values (QANTRIS.wdXau181HNodbmfxFkr3xQ==, 791d5c65b55c40f081873960857e578d6e6392ec2a9338c62ce52c123c0b37039710812eb8930b16e7bbc26612bd9acb0695132f7f0f5093b065218822a750a212cbfd8e10a3c8d07f5db01f95c6e084408e7eb235d1202fb3e0acbf6530918a, ?, 27, 0, , , , , single_sign_on, 2021-06-01 14:55:08, 2021-06-01 14:55:08))

 

Could someone help me solve this problem?

Regards

[YuriP]

Same problem for me. This currently preventing my WHMCS to suspend the accounts via cron:

         Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint
         violation: 1048 Column 'user_id' cannot be null (SQL: insert into      
         `tbloauthserver_clients` (`identifier`, `secret`, `user_id`, `service_id`,
         `rsa_key_pair_id`, `name`, `description`, `logo_uri`, `redirect_uri`,  
         `grant_types`, `updated_at`, `created_at`) values                      
         ([hidden],                    
         [hidden], ?, 7512, 0, , , , ,  single_sign_on ,
         2024-05-13 09:02:37, 2024-05-13 09:02:37)) in                          
         /home/[hidden]/public_html/vendor/illuminate/database/Connection.php:671

* [hidden] was me hiding some possible sensitive information.

Please, someone can help me?