VTiger Blog – News, Common Errors & Helpful Tips

How to Hide “Contact Image” Field in vTiger?

August 29, 2013
Article
By default the “Contact Image” field on the Contact screen is active, and unfortunately you can not hide or deactivate it using the Field “Layout Editor“. Most business don’t collect contact images and this field/section just takes up valuable screen space. In order to remove it, you will have connect to the MySQL Database and run the query which will hide the field. Make sure you have a backup before you run any queries on the database. UPDATE `vtiger_field` SET `presence`=’1′ WHERE `fieldlabel` =’Contact Image’ AND `tabid`=’4′ AND `fieldname`=’imagename’ AND `fieldid`=’108′;

How to Change Default “Related To” From Organizations to Contacts?

August 28, 2013
Article
Out of the box vTiger does not support setting the default “Related To” dropdown values. The “Related To” dropdown is used in many modules such as “Trouble Tickets”, “Opportunities”, “Projects”, “Service Contracts”, etc… In order to change the default “Related To” value from Organizations to Contacts, you will have to adjust the database. Note, if you are not familiar with MySQL and the database structure, you are better off having someone else do it. We would be glad to help – Contact us. The table that needs to be modified is ‘vtiger_fieldmodulerel‘. Open the table and you will see the first 2 rows are: You need to change the “relmodule” value to switch “Accounts” with “Contacts” and “Contacts” with “Accounts“. Whenever you start a new Opportunity/Potential the default “Related To” value will be the the first one for the “module”. The end result should be: Again, if you need help

The record you are trying to view has been deleted

August 28, 2013
Article
The vTiger error “The record you are trying to view has been deleted” is presented when the the record you are trying to access does not exist. It does not necessary mean that the record has been deleted, the reason for that is, if you were modifying the code or the database you might have changed the function which loads the appropriate recordid or when the record is not created properly but the system still thinks it was and opens the record using the ‘new id’ which does not exist. It’s almost impossible to determine why it happens without looking at the code. If you would like us to look at it – feel free to contact us.

How to Change Field Labels in vTiger?

August 28, 2013
Article
Unfortunately vTiger does not have an option to change the field labels using the user interface. However, there are few ways to do it. Let’s say we want to modify the field label for Account field “Rating”. The first and the easiest method is to modify the vTiger language file and replace the existing field labels with new ones. Go to “/vtigercrm/modules/Accounts/language/“ Open “en_us.lang.php” with your favorite text editor Find the word “Rating” and replace it with the new label. Save the file and refresh the Contact screen – the new label should show up. The second method requires knowledge of MySQL database structure, so if you are not familiar with tables and field, you are better of going with method one or three. Connect to your vTiger database Find table ‘vtiger_field‘ Run the query ‘select * from vtiger_field where fieldlabel=’Rating’;‘ Edit the row and change the fieldlabel value to

Why does the Orange Icon with Exclamation Point Show up in Listview?

August 28, 2013
Article
The Orange icon with exclamation point inside indicates that the record has been modified by the user who is not the record owner(Assigned To). If you find this Icon Annoying you can easily remove it by replacing the file “important1.gif” in “vtigercrm/themes/images/” with a one pixel .gif image.

How to Change Document Maximum Upload Size in vTiger?

August 28, 2013
Article
Out of the box vTiger has a limit of 3MB for the file upload when creating and uploading an external document to vTiger. In order to increase the file limit, you have to set it in vTiger Configuration Editor as well as in you servers’ php.ini file. vTiger Configuration Editor: Mouse over the “gear” icon on the right upper corner Click “CRM Settings” Under “Other Settings” section, hit “Configuration Editor” Find “Max. Upload Size (Max XMB)” and set it to 30MB(you can set it to higher number if needed). Save the Configuration Editor by clicking “Save”. Server Configuration – php.ini. If you are on shared hosting, most likely you will not have access to php.ini – you should contact your hosting provider to adjust the values. However, if you do have access, follow the instructions below: Open php.ini with your favorite text editor Find “post_max_size = XXMB” and change it

Migration Incompleted. Please contact your system administrator.

August 28, 2013
Article
The vTiger error “Migration Incompleted. Please contact your system administrator.” is usually caused by vTiger not being able to connect to the MySQL database. Possible causes: MySQL Server is not available/down MySQL Server host has changed MySQL Username/Password is not correct/has changed MySQL Database name has changed In order to adjust the MySQL credentials, first you have to verify them with your host provider and adjust them in config.inc.php. Go to your vTigerCRM directory Open “config.inc.php” with your favorite text editor Go to line 47 – verify that the $dbconfig[‘db_server’] has the correct MySQL Host Name Go to line 48 – verify that the $dbconfig[‘db_port’] has the correct MySQL Port Go to line 49 – verify that the $dbconfig[‘db_username’] has the correct MySQL Username Go to line 50 – verify that the $dbconfig[‘db_password’] has the correct MySQL Password Go to line 51 – verify that the $dbconfig[‘db_name’] has the correct MySQL Database Name Hope that helps!

Sorry! Attempt to access restricted file.

August 28, 2013
Article
The most likely cause for the vTiger error “Sorry! Attempt to access restricted file.” is the $root_directory value in the ‘config.inc.php’ is incorrect or misspelled. In order to correct it follow the steps below: Go to your vTigerCRM directory Open “config.inc.php” with your favorite text editor Go to line 86 and adjust $root_directory value to correct vTiger directory. Note, that the directory must end with /. It should look something like this – $root_directory = ‘/var/www/vtigercrm/’; Hope that helps!

How to Organize Navigation Bar in vTiger?

August 26, 2013
Article
vTigerCRM has a nice feature which allows users to arrange the navigation bar menu items. It’s helpful when you have many modules enabled, but not all of them are used on a daily basis. To add or remove menu items from the vTiger navigation bar follow the instructions below: Mouse over the “gear” icon on the right upper corner Click “CRM Settings” Under “Studio” section, hit “vTiger Menu Editor” “Selected Modules” are the modules which will show up on the main navigation bar. Use the arrows to add,remove and order the modules.

How To Disable Modules In vTiger?

August 26, 2013
Article
Out of the box vTiger comes with a lot of enabled modules. In most cases you will not be using all the modules and those can take up a valuable space on your screen. You can either use the “vTiger Menu Editor” and remove them from the navigation bar, or if you are certain that you do not need them – just follow the instructions below and disable the unnecessary vTiger modules. Note, the modules can be re-enabled at any time. Mouse over the “gear” icon on the right upper corner Click “CRM Settings” Under “Studio” section, hit “Module Manager” Mouse over the check-box – it will say “Disable Module” Click on the check-box and it will change to red X.

How To Change The Order Of Related Lists In vTigerCRM

August 26, 2013
Article
In order to quickly and efficiently see the information that you need, you can rearrange the vTiger Related Lists to fit your needs. To do so: Mouse over the “gear” icon on the right upper corner Click “CRM Settings” Under “Studio” section, hit “Module Manager” Click on the wrench(far right side) next to the module you want to order the Related Lists. Click “Layout Editor” Click on “Arrange Related List” button Once list is open, you can easily move them up or down. By default vTiger comes with many enabled modules which take up a lot of space on the screen and has no value to you – see how you can disable modules in vTiger and optimize your screen space.

vTiger Profile/Permissions does not save the “Modules To Be Shown” properly?

August 7, 2013
vTiger Saving Profile Permissions
Article
You might come across an issue related to saving “Profile Privileges” for each module. It’s a known issue, however it’s not a vTiger bug – it’s a server limitation. If you are a server admin and have access to php.ini, you should check the value of “max_input_vars” and increase it to 1500-2000. By default it’s set to 1000 which is not enough to save vTiger Profile Permissions. If you are not the server admin or are you using shared hosting, you should contact your vTiger hosting provider and ask them to do the same. Hope that helps!

Mail could not be sent to the admin user. Please check the admin emailid/Server settings

August 7, 2013
Mail could not be sent to the admin user. Please check the admin emailid/Server settings
Article
There are a lot of things that can go wrong when setting up the vTiger Outgoing Email Server – it can be as simple as mistype or as complected as firewall blocking the connection or missing PHP extension. Hopefully the steps below will point you to the right direction while troubleshooting the error you are getting. If you are using GMail as your Outgoing Server – follow the guide “Setting up vTiger Outgoing Email Server With GMail“ Make sure that the username/password and the Server Name is correct. Check your email settings or contact your email provider to verify the email server. Verify that your email server does not require SSL connection or any specific port – if it does, add the ssl:// tag or the port using the “GMail as an Outgoing Email Server in vTiger” example. If you are using ssl:// tag – make sure SSL PHP Extension

Setting up vTiger Outgoing Email Server With GMail

August 7, 2013
Setup GMail Outgoing Server in vTiger
Article
Setting up vTiger Outgoing Email Server is easy – if you know how to the details required. Most of the Outgoing Email servers do not require SSL connection or any specific port, however GMail does. In order to setup GMail as an Outgoing Email Server for vTiger – you have to specify the PORT and that it’s authenticating using secure certificate. Here’s the syntax: Server Name: ssl://smtp.gmail.com:465 Username: Your@email.com Password: Your Email Password Requires Authentication: Yes From Email: Your@email.com Note, that it does work the same for GMail and Google Apps Accounts. If you are getting a message “Mail could not be sent to the admin user. Please check the admin emailid/Server settings” – use the troubleshooting steps in this article.  

Activate or Deactivate Comments Section/Block in VTigerCRM

August 6, 2013
Article
Some people find the comments section in vTiger rather annoying, because if you are not using it – it just takes up your valuable screen space. By Default there is no way to disable or enable the comment section on any module. In order to remove or add the comment block you will have to use a custom script which will either activate or deactivate the “ModComments” section.  Let’s say if you would want to remove comments section from Leads views, you would: Download Deactivate Comments for Leads Extract the zip file Place “Leads – Deactivate Comments.php” in your vTiger directory Execute the script – which is to open the file in your browser. If your vTiger URL is ‘http://www.vtiger.com/myvtiger’ then you should open ‘http://www.vtiger.com/myvtiger/Leads – Deactivate Comments.php’ and that will remove the comments section for Leads.   List of scripts to Activate/Deactivate Comments in vTiger: Activate Comments for Contacts Deactivate Comments for

How to set default value for vTiger field?

July 26, 2013
Article
vTiger 5.4 introduced an option to select the default value for most of the fields. To do so, do: Mouse over the “gear” icon on the right upper corner Click “CRM Settings” Under “Studio” section, hit “Module Manager” Click on the wrench(far right side) next to the module you want to add custom field. Click “Layout Editor” Find the field you want to set default value for, click on “Note with a Pen” next to the field. Select the Default value, hit save. Now every time you create a record, it will default to the value selected. If you are on vTiger 5.3 or lower you will not be able to set default values using this method.

Invoice/Quote/Sales Order Default to Service instead of Product.

July 18, 2013
Article
By default when you start Invoice, Quote or Sales Order the item defaults to products. This is not convenient for businesses who are oriented towards services, however there’s a quick tip how to change the first line item to services. We strongly recommend to backup vTiger files and database before doing any changes to code/database. Navigate to “vtigercrm/Smarty/templates/Inventory/ProductDetails.tpl” Go to line 172, the line should be: <img id=”searchIcon1″ title=”Products” src=”{‘products.gif‘|@vtiger_imageurl:$THEME}” style=”cursor: pointer;” align=”absmiddle” onclick=”productPickList(this,’{$MODULE}’,1)” /> Change it to: <img id=”searchIcon1″ title=”Services” src=”{‘services.gif‘|@vtiger_imageurl:$THEME}” style=”cursor: pointer;” align=”absmiddle” onclick=”servicePickList(this,’{$MODULE}’,1)” /> Save files and you are set.

Add “Last Modified By” Field

July 18, 2013
Article
By default the “Last Modified By” field is hidden in vTiger, however all the functionality and the actual field is there. In order to unhide it you will have modify the database. We strongly recommend to backup vTiger files and database before doing any changes to code/database. You will need to run the query below: UPDATE vtiger_field SET presence=’0′, displaytype=’1′ WHERE fieldlabel=’Last Modified By’ AND columnname=’modifiedby’ AND tablename=’vtiger_crmentity’; Note, this query will enable Last Modified By field for ALL the modules, if you wan’t to enable it for just one module you will have to add “AND tabid=’Tab ID goes here’”; You will have to lookup tabid for the specific module in vtiger_tab.

Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb.inc.php on line 893, 1919, 1991

July 18, 2013
Article
The errors below most likely are caused by the PHP5.3, you might get something like below if you upgrade to PHP5.3 Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb.inc.php on line 893 Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb.inc.php on line 1919 Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb.inc.php on line 1991 Two things you can try: Add ini_set(‘display_errors’,0); error_reporting(0); to index.php in vtigercrm root directory. This will suppress the errors. Go to the lines 893, 1919, 1991 and replace “=&” with “=” (removed &). It should fix the errors. Note, only do #2 if #1 does not work.

Deprecated: Function session_unregister() is deprecated in /modules/Users/Authenticate.php on line 70, 71, 72

July 18, 2013
Article
The errors below most likely are caused by the PHP5.3, you might get something like below if you upgrade to PHP5.3 Deprecated: Function session_unregister() is deprecated in /modules/Users/Authenticate.php on line 70 Deprecated: Function session_unregister() is deprecated in /modules/Users/Authenticate.php on line 71 Deprecated: Function session_unregister() is deprecated in /modules/Users/Authenticate.php on line 72 In order to fix it, you will need to replace lines 70,71,72 from: session_unregister(‘login_password’); session_unregister(‘login_error’); session_unregister(‘login_user_name’); To: unset($_SESSION[‘login_password’]); unset($_SESSION[‘login_error’]); unset($_SESSION[‘login_user_name’]);

Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb-xmlschema.inc.php on line 373, 385

July 18, 2013
Article
The errors below most likely are caused by the PHP5.3, you might get something like below if you upgrade to PHP5.3 Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb-xmlschema.inc.php on line 373 Deprecated: Assigning the return value of new by reference is deprecated in /adodb/adodb-xmlschema.inc.php on line 385 Add ini_set(‘display_errors’,0); error_reporting(0); to index.php in vtigercrm root directory. This will suppress the errors. Go to the lines 373, 385 and replace “=&” with “=” (removed &). It should fix the errors.

Module name is missing. Please check the module name

July 18, 2013
Article
You have installed vTiger 5.x and once you login you get a message “Module name is missing. Please check the module name.” If it’s a fresh install, most likely the $root_directory variable in config.inc.php is not set properly. In order to set it, do: Go to folder vtigercrm/ Open config.inc.php file Find $root_directory variable and make sure, your vTiger CRM path is correct. Once verified, try again, if it still doesn’t work do: Add “/” at the end of the path, for example: /home/content/98/html/demo/ Try again, if it still doesn’t work try: Add “/” at the beginning of the path (if it does not exist)

vTiger Open Source 6.0 Beta Released

July 14, 2013
Article
Finally vTigerCRM 6 Beta have been released. It’s not fully functional yet, there are some modules missing as well as some new modules that did not exist in vTigerCRM 5.4 such as Google Calendar & Contact Sync. Since it’s just Beta version, you can not upgrade from 5.4 yet and it’s only for testing and bug reporting purposes. The RC/Stable is scheduled to be released September or October, however the schedule might change. Vtiger 6.0 Beta: Installation Files | Installation Manual | Developer Manual

vTiger 5.4.0 Security Patch Released

March 26, 2013
Article
vTiger team has released a security patch which will help prevent the Local File Inclusion, Local File Deletion, SQL Injection, PHP Code Injection, Cross site scripting, Arbitrary File Upload, Authentication Bypass vulnerabilities(SOAP API’s). You can download the patch from SourceForge or Office vTiger Link. Make sure you always backup  your files and the database.  To apply the security patch, simply overwrite the files in /vtigercrm/ directory. Feel free to contact us if you need help apply the patch.