Jump to content

Order Accept Encountered Problems Error - Can not make pending orders active


pdishman

Recommended Posts

Order Accept Encountered Problems
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 (MERCHANT-HOST-HU.nBandeGjUT0otp6pb9tn8g==, c1690cdc7eae71b8d5c945e05998a28ffb512d7df9c238011b7c0f79ca32e48e7581484a957828a8be50f18da0f8fccac5d35bf7581c2993a5ba03a592abb3cfd28318b04437022e653f3a2b55ffeb19d874f0dc5ecdcba4114083dfe23ba736, , 12, 0, , , , , single_sign_on, 2018-09-09 03:44:46, 2018-09-09 03:44:46))

I received a new order and when i tried to accept it, the system gave me the above error.  It actually creates the order in WHM, but WHMCS errors out.  I tried deleting the order on both sides and recreating the order manually with no luck, i received the same error msg.

I appreciate any help you can give me!

Link to comment
Share on other sites

  • 3 weeks later...

Well, I ended up selecting the order and then setting it as active from within the order and saving and that seemed to do the trick... or it resolved itself, not 100% sure! 😄

Hope that helps you.

I posted this comment in the community, plus sent a ticket to support with no response... so, sadly whmcs support is not responsive 😞 

Link to comment
Share on other sites

  • 1 month later...
  • 4 weeks later...
On 9/9/2018 at 7:42 PM, pdishman said:

Order Accept Encountered Problems
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 (MERCHANT-HOST-HU.nBandeGjUT0otp6pb9tn8g==, c1690cdc7eae71b8d5c945e05998a28ffb512d7df9c238011b7c0f79ca32e48e7581484a957828a8be50f18da0f8fccac5d35bf7581c2993a5ba03a592abb3cfd28318b04437022e653f3a2b55ffeb19d874f0dc5ecdcba4114083dfe23ba736, , 12, 0, , , , , single_sign_on, 2018-09-09 03:44:46, 2018-09-09 03:44:46))

I received a new order and when i tried to accept it, the system gave me the above error.  It actually creates the order in WHM, but WHMCS errors out.  I tried deleting the order on both sides and recreating the order manually with no luck, i received the same error msg.

I appreciate any help you can give me!

Hi did you find the solution? I have the same issue..

Link to comment
Share on other sites

4 minutes ago, radwebhosting said:

Changes to  (interactive_timout, wait_timeout) would be made in configuration file for database server. This will most likely not really fix the cause of your issue.

You should determine why the query did not insert an appropriate value for the field. 

Sir I have no idea why it's happening. But it was running fine before. I have no idea how to fix this. If you can do it's a request to you to pls help me, as I have no much knowledge in whmcs and .php

Link to comment
Share on other sites

  • 11 months later...
  • 2 months later...

Facing same error, please help 

Quote

Order Accept Encountered Problems 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 (WEB-SOLUT.xTOzV9COIoOEMe3QOZ8xIA==, 7964848aa7080b2f0c293ae6ee0601eb535e4b3b73534b98de38e475bd6f1f707035bb2fb3b2244e2362c883e63195f24e873b6f1451cf6849b5f72e40c99d6554eaf8e89d8cc55513899ef5769e9ec09f7db5b160704a5d21798755a546b9d2, , 1254, 0, , , , , single_sign_on, 2020-02-28 20:26:01, 2020-02-28 20:26:01))

 

Link to comment
Share on other sites

Hello @solomon121

 
 
 
 
4 hours ago, solomon121 said:

Facing same error, please help 

This error indicates that WHMCS has not received a successful response from the module before the MySQL server has "Gone away".   The module may successfully complete provisioning an account however, WHMCS will be unable to apply this and will leave the product in a "Pending" state.  

To rectify this, it's likely that the MySQL "wait_timeout" and "interactive_timeout" configuration variables set far too low. You can check this by running the following query:

SHOW SESSION VARIABLES LIKE "%timeout%"

If you see that the "wait_timeout" or "interactive_timeout" values are very low  such as 30 then these will need to be increased by the System Administrator. The default value and a good recommendation is to set these to "28800".

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated