Ephex Posted August 5, 2018 Share Posted August 5, 2018 Basically, when we accept an order and begin the module creation, we get this error highlighted below. It creates the WHM account, and the cpanel account, but does not successfully create the module. 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 (EPHEX.Scnc/Ac/oCLLlGQtqQYCXA==, dc756ca3807ed6a3810d7e51c64d641f592d649e675c4d802764bd69c4d4f65d61b73724572ab75f8d198162365c87933564319f3f778775a25093242c1a8f9d88809e86c251417b1e3db46a4f914e6a5e1a2d00a2b3dc2b4d25af215d3deefd, , 1, 0, , , , , single_sign_on, 2018-08-05 18:26:56, 2018-08-05 18:26:56)) 0 Quote Link to comment Share on other sites More sharing options...
Hostinglandia Posted September 26, 2018 Share Posted September 26, 2018 I have the same problem. Did you find a solution? 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted September 26, 2018 Share Posted September 26, 2018 The value of user_id column is NULL. You can clearly see it from the query right after the very long secret value. user_id clearly can't be NULL and must be defined. 0 Quote Link to comment Share on other sites More sharing options...
Hostinglandia Posted September 26, 2018 Share Posted September 26, 2018 That is correct. but does not explain why it fails . And most interesting is that fails with php 7.0 but does not fail with php 5.6 I downgrade to php 5.6, but this is just a workaround , not a solution. Very strange anyway. I Open a ticket with whmcs, and as allways no response. may be the worst support ever. It is amazing is the same company than cpanel (that has the best support I have ever seen.) 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted September 26, 2018 Share Posted September 26, 2018 We can't say what is going on since the file that is causing the issue is obfuscated. Probably for some reason a particular syntax gives null on PHP 7. PHP 5.6 is more "gentle" and permissive. 0 Quote Link to comment Share on other sites More sharing options...
Anjan Posted December 23, 2018 Share Posted December 23, 2018 On 9/27/2018 at 1:31 AM, Hostinglandia said: That is correct. but does not explain why it fails . And most interesting is that fails with php 7.0 but does not fail with php 5.6 I downgrade to php 5.6, but this is just a workaround , not a solution. Very strange anyway. I Open a ticket with whmcs, and as allways no response. may be the worst support ever. It is amazing is the same company than cpanel (that has the best support I have ever seen.) Hi did you find the solution? I have the same issue.. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.