atcomsystems.ca/forum Forums Computers & Programming Computers, Software, Accessories Remove module from vTiger

Here's another tidbit I'm posting simply so it can be found later! We were struggling to remove a couple custom modules from vTiger that we presumed were preventing an upgrade. They were called 'Vtiger Premium' and 'Duplicate Extension Check' which are referred to internally in vTiger as 'VTEStore' and 'DuplicateCheckMerge' respectively. After merging info from a couple other posts we came up with the following:

Create a php file in the vTiger home directory named RemoveModule.php, insert the following (change VTEStore to DuplicateCheckMerge or whatever other module you want to delete and run again):

Now browse to vtiger.IP.address/vtigercrm/RemoveModule.php and you should see the following info scroll across an otherwise blank screen:

In our case we also had to modify the SQL database and remove references to the 2 modules in table vtiger_settings_field.

Here's another vTiger finding that cost me a couple days of productivity! After upgrading Vtiger a few times (probably started in version 6 a number of years ago) I was able to get up to version 7.1RC and apply the first 2 hotfixes. However, as soon as I applied the 3rd hotfix named "vtigercrm7.1.0-hotfix3.zip" we suddenly could no longer view any customer records. The data was still there because certainly summaries still showed the correct numbers, and all the Vtiger user logins still worked.

After much trial & error I finally tracked the bug down to this failed SQL request:
SELECT vtiger_account.accountname, vtiger_accountbillads.bill_city, vtiger_account.website, vtiger_account.phone, vtiger_crmentity.smownerid, vtiger_account.accountid, vtiger_accounts_user_field.starred FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_account.accountid = vtiger_crmentity.crmid INNER JOIN vtiger_accountbillads ON vtiger_account.accountid = vtiger_accountbillads.accountaddressid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vtiger_accounts_user_field ON vtiger_account.accountid = vtiger_accounts_user_field. WHERE vtiger_crmentity.deleted=0 AND vtiger_account.accountid > 0 ORDER BY vtiger_crmentity.modifiedtime DESC LIMIT 0,21

This issue was that vtiger_accounts_user_field. should have been vtiger_accounts_user_field.recordid

Turns out the offending code was in /var/www/html/vtigercrm/vtlib/Vtiger/Functions.php where:
needed to be turned into

Viola! All good now...



Also, for MariaDB debugging:

Database Debugging


Nano the file include/database/PearDatabase.php
Look for the line $adb->connect(); (it's right near the end of the file)

You have 2 options:

1 - add this line:
$adb->setDebug(true);
This line will output EVERY Query sent to the database.

2 - add this line:
$adb->setDieOnError(true);
This line will only output a detailed error report if an SQL query generates an error.

Take the line out when you're done debugging - it could cause unexpected behavior.