after importing cpanel/whm accounts i cannot change the signup date

[shoulders]

after importing accounts from cpanel/whm i am unable to change the signup date. they currently all set as 00/00/0000

 

i have been opening the clients profile, moved to the 'Products/Services' Tab and then click view order link. i then get this error message

 

Order not found... Exiting...

 

I have not run the CRON job at all yet, will this be causing issues.

 

How can i fix this?

 

thanks

 

shoulders

[Sitepearl]

I seem to recall this issue when I imported a few rogue accounts... but I don't quite remember what it was (it was years ago). Have you tried contacting WHMCS support?

[shoulders]

not yet, i only just found the support link.

 

i corrected the error by editing the database, if some one need the code i can post ehr (i got it of another user from here),

 

but it still does the no order thing. perhaps when they renew this will dissapear.

 

thanks for the suggestion

[RFEHosting]

not yet, i only just found the support link.

 

i corrected the error by editing the database, if some one need the code i can post ehr (i got it of another user from here),

 

but it still does the no order thing. perhaps when they renew this will dissapear.

 

 

 

thanks for the suggestion

 

Hey i am having the same issue, did you get this resolved?

[WHMCS JamesX]

I'd assume that you're getting a no order error because there's no associated order. The product/service wasn't created via an order.

[RFEHosting]

This error is coming up for adding a new order.. So why would there be that error when adding?

And i do have products/services setup.

[RFEHosting]

This just started happening out of the blue.

[MemoryX2]

I had this issue as well.

 

You can log into your cPanel account and go to Php myadmin.

 

Edit your WHMCS database. You want to edit the table: tblclients. Choose whatever id is the problem, and then just edit it. There is a row for sign up date. Put the date in, save then whmcs will tell you the client signup date.

 

I would back up the database first just in case you do something wrong. This certainly works though I had to do it for a few clients.

[RFEHosting]

I am not trying to change any sign up dates. i just need to add an order.

[shoulders]

i can dig out the code that i used to set my the date. if i remeber right i just changed the sign up date to when i imported the data. someone post here if you want me to dig the code out.

 

i am not sure what you mean by order. attaching a picture might help.

[DavidBee]

I am not trying to change any sign up dates. i just need to add an order.

 

I would suggest creating a new thread mate for better help. The OP is looking to change the signup dates. You are simply just looking to add a new order.