slim Posted October 5, 2020 Share Posted October 5, 2020 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? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 5, 2020 WHMCS Support Manager Share Posted October 5, 2020 Hi @slim, Please apply this hotfix to resolve the issue with negative order numbers: 0 Quote Link to comment Share on other sites More sharing options...
slim Posted October 6, 2020 Author Share Posted October 6, 2020 Thanks - Applied. seems ok so far. Do I need to worry about the negative order numbers in my system? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 8, 2020 WHMCS Support Manager Share Posted October 8, 2020 Hi all, I'm pleased to advise this has been addressed in v8.0.2. 0 Quote Link to comment Share on other sites More sharing options...
slim Posted October 8, 2020 Author Share Posted October 8, 2020 Can you at least address my question? 0 Quote Link to comment Share on other sites More sharing options...
slim Posted October 14, 2020 Author Share Posted October 14, 2020 ?????? 0 Quote Link to comment Share on other sites More sharing options...
string Posted October 15, 2020 Share Posted October 15, 2020 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. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 15, 2020 WHMCS Support Manager Share Posted October 15, 2020 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. 0 Quote Link to comment Share on other sites More sharing options...
slim Posted October 15, 2020 Author Share Posted October 15, 2020 John, can you advise if running the above mysql is beneficial/ safe? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 16, 2020 Share Posted October 16, 2020 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... ----> beneficial? as string says, the field is just for show. 1 Quote Link to comment Share on other sites More sharing options...
slim Posted October 19, 2020 Author Share Posted October 19, 2020 Thanks- Done 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.