Jump to content
slim

Negative Order numbers? -822230234 (ID: 2295)

Recommended Posts

Since upgrading to 8 and 8.0.1 I have noticed orders I create in the admin area end up with negative order numbers.. 

Example: -822230234 (ID: 2295)

Any reason?

Share this post


Link to post
Share on other sites

Thanks - Applied. seems ok so far.

Do I need to worry about the negative order numbers in my system?

Share this post


Link to post
Share on other sites
On 10/6/2020 at 8:32 AM, slim said:

Do I need to worry about the negative order numbers in my system?

It will probably not cause any problems, at least not with the current WHMCS version.

I would still correct the order number to avoid possible problems with new WHMCS versions using following SQL query:

update tblorders set ordernum = replace(ordernum,'-','')

This query removes all "-" sign.

The order number has no other reference in the database. Since the ID of the row does not change, you don't have to fear any problems with the above mentioned SQL query.

Share this post


Link to post
Share on other sites

Hi there,

We have not observed detrimental effects from negative order numbers as a result of this case.

All references to orders are done using the Order ID within the system, with the Order Number being more of a display value.

Share this post


Link to post
Share on other sites

John, can you advise if running the above mysql is beneficial/ safe?

Share this post


Link to post
Share on other sites
15 hours ago, slim said:

can you advise if running the above mysql is beneficial/ safe?

it will be safe as it's just removing hyphens from that column... I found one in my tblorders table and I ran the query...

PrLhNcD.png ----> CSKtBA8.png

beneficial? as string says, the field is just for show.

Share this post


Link to post
Share on other sites

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.


  • Similar Content

    • By WHMCS John
      An issue has been identified in the 8.0.0 and 8.0.1 releases - published on 28th September 2020, that can result in an Oops error when placing an order.
      This occurs when the randomly generated order number is greater than 2,147,483,647
      TypeError: Argument 2 passed to WHMCS\Order\Order::add() must be of the type int, string given, called in /path/to/whmcs/includes/orderfunctions.php on line 0 and defined in /path/to/whcmcs/vendor/whmcs/whmcs-foundation/lib/Order/Order.php:0  
  • 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