Jump to content

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

pdishman

By pdishman
in Using WHMCS

 Share

Recommended Posts

pdishman Junior Member

pdishman

Posted
Posted

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!

0
Link to comment
Share on other sites
  • 3 weeks later...
pdishman Junior Member

pdishman

Posted
  • Author
Posted

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 😞 

0
Link to comment
Share on other sites
  • 1 month later...
  • 4 weeks later...
Anjan Junior Member

Anjan

Posted
Posted
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..

0
Link to comment
Share on other sites
Anjan Junior Member

Anjan

Posted
Posted
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

0
Link to comment
Share on other sites
  • 11 months later...
  • 2 months later...
solomon121 Junior Member

solomon121

Posted
Posted

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))

 

0
Link to comment
Share on other sites
WHMCS ChrisD Senior Member

WHMCS ChrisD

Posted
Posted

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".

0
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.

×
 Share
Go to topic listing
×
×
  • 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

  I accept