Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Support / AdsManager Support / How reset all testing orders and payments?

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

How reset all testing orders and payments?

More
11 years 1 month ago #14733 by Purostile
Hello,
The beta test of my site draws to an end. :)
  1. How do I delete all test orders, their related payments, invoices, customers, stats, etc. stored in AdsManager, Invoicing, PaidSystem and VirtualMoney?
  2. How do I reset their numbering, so each component can numbering the next real orders, payment, clients starting from number 1?
Best regards
More
11 years 1 month ago #14747 by loic
Hello,

To reset all table you need to empty them by using the TRUNCATE sql command.

Like that for the ads table -> TRUNCATE #__adsmanager_ads
Don't forget to replace the #_ by the prefix of your database.

I strongly advice you to do a backup of the tables before deleting there contents. Also, take a look at the datas on all the table because some of them must not be emptied.

Best regards.
The following user(s) said Thank You: Purostile
More
11 years 1 month ago #14748 by Purostile
Replied by Purostile on topic How reset all testing orders and payments?
Thank you.
  1. This should empty only the orders data or also the configuration data? I don't want lose all my configurations!
  2. Your suggestion works only for AdsManager or also for Invoicing, PaidSystem and VirtualMoney? If yes, how I identify those tables?
  3. This make a reset of all the numerations?
Best regards.
More
11 years 1 month ago #14787 by loic
Hello,

Okay, I will try to list the tables :
AdsManager:
#__adsmanager_ads
#__adsmanager_favorite
#__adsmanager_pending_ads
#__adsmanager_pending_mails

#__adsmanager_categories (Do not empty this table if you wish to keep your categories)
#__adsmanager_field2position (Do not empty this table if you wish to keep your fields in their given positions)
#__adsmanager_fields (Do not empty this table if you wish to keep your custom fields)

Invoicing:
#__invoicing_invoices
#__invoicing_invoice_items
#__invoicing_quotes
#__invoicing_quote_items

Paidsystem:
#__paidsystem_ads

Virtualmoney:
#__virtualmoney_credits
#__virtualmoney_exchanges
#__virtualmoney_orders
#__virtualmoney_transactions

The auto increment fields will be set to 1, if you still have some datas you wish to remove, tell me and I will tell you which tables you need to empty.

Best regards.
The following user(s) said Thank You: Purostile
More
11 years 1 month ago #14797 by Purostile
Replied by Purostile on topic How reset all testing orders and payments?
Okay, I'll contact you when I'll do all those operations. Thank you.

Best regards
Time to create page: 0.049 seconds
Powered by Kunena Forum