How to remove the sample data from vTiger?

If you have installed vTiger with the sample data and then want to delete that data, you can use the following SQL query:

update vtiger_crmentity set deleted = 1

The easiest way to execute the query is through the phpMyAdmin tool. Go to your cPanel and click on phpMyAdmin in the Databases box.

Once in phpMyAdmin, select the vTiger's database from the drop-down menu at left. The page will refresh and the database's tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the above SQL query and click on the GO button to submit the query. 

This SQL query will set a deleted flag for all existing module records in vTiger. You can revert back any record by setting deleted = 0.

You need help with an application? hostlantern is specialized in hosting and supporting more than 200 scripts. Sign up for our web hosting services and let us help you with your application, 24/7!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

“fail” error when adding dashlets in SugarCRM

If you add chart dashlets to your SugarCRM home page, but they are empty and you get a pop up...

How to set up separate outgoing email accounts in SugarCRM

With the latest version of SugarCRM you can allow your users to set their own Outgoing Email...

How to set up the HiveMail Email Gateway to use the PIPE method with cPanel

Configuring the PIPE Email Gateway method is probably the hardest part of a HiveMail setup, so in...

How to set an e-mail account for the EGroupware application?

In order to send/receive mails through EGroupware, the mail settings for the user should be...

How to change the administrator password in Omeka?

In order to change the password for your Omeka application you need to login to your cPanel ->...