Resetting Client ID Number etc.,

[magicalwonders]

Hello,

 

I've been carrying out a bit of testing with my new WHMCS installation. This has involved creating and deleting fictitious customer accounts to make sure everything works O.K.

 

Is there anyway to reset Client ID, Order Numbers and Invoice numbers back to zero in order to commence accepting real clients and orders?

 

The only reset info I could find in the manual refers to Invoice numbers, which suggests that I can't really do this.

 

You should only enter this if you want to change the invoice starting number

The number you enter here must be greater than the last generated invoice # which is 4

 

Am I looking at a completely fresh install of WHMCS to start the numbers from zero?

 

Hope someone can advise.

 

Many thanks,

 

Myles

[othellotech]

trunc the files - the instructions are in the wiki

[sparky]

http://wiki.whmcs.com/Maintenance

[magicalwonders]

Thanks folks,

 

I just found the page using "search". Although I'm not sure which category "Maintenance" actually comes under!

 

Thanks again. Appreciate the help.

 

Myles

[magicalwonders]

O.K. I'm about to take the plunge and reset my database as per following instructions:

 

You can empty all the tables that contain clients data by running the following SQL code on your database:

 

TRUNCATE `tblaccounts` ;

TRUNCATE `tblaffiliates` ;

TRUNCATE `tblaffiliatesaccounts` ;

TRUNCATE `tblcancelrequests` ;

TRUNCATE `tblclients` ;

TRUNCATE `tblcustomfields` ;

TRUNCATE `tbldomains` ;

TRUNCATE `tblemails` ;

TRUNCATE `tblhosting` ;

TRUNCATE `tblhostingaddons` ;

TRUNCATE `tblhostingconfigoptions` ;

TRUNCATE `tblinvoiceitems` ;

TRUNCATE `tblinvoices` ;

TRUNCATE `tblorders` ;

TRUNCATE `tblticketlog` ;

TRUNCATE `tblticketnotes` ;

TRUNCATE `tblticketreplies` ;

TRUNCATE `tbltickets` ;

 

I'm a bit shaky on MySQL stuff though and not 100% confident I know what I'm doing.

 

Is it just a matter of loging into PhpMyAdmin, selecting the correct database, then cutting and pasting above Truncates under the SQL tab.

Run SQL query/queries on database webhost1_whmcs

Then clicking "GO"

 

Hope someone can confirm if this is the correct procedure.

 

Many thanks,

 

Myles

[sparky]

Yep... that it

without the top description line though. Only the TRUNCATE lines

[magicalwonders]

Excellent. Many thanks!

 

Best wishes,

 

Myles