[vTiger 6] How to change default fields on popup ListView

When I need to select some item of a vTiger module from other, a popup window is opened. A list of items appears with a columns by default but we can't choose them from GUI. We need to change the code. 

The following example changes the columns for Products module. We are going to add two new columns to the view, the Serial Number and the Category of the product:

[vTiger 6] Multiple instances on one installation

I have an installation with one apache&mySql server and multiple vTiger instances with separate databases.

You will have to separate vTigers like this:

http://hostname/vtiger_1;

http://hostname/vtiger_2;

http://hostname/vtiger_3;

1. Install the whole bundle (Apache, MySQL and vTiger) normally.

2. In apache/conf dir edit httpd.conf. Remove vtigercrm dir on these 3 lines:

• DocumentRoot "C:/Program Files (x86)/vtigercrm600/apache/htdocs"
• Directory "C:/Program Files (x86)/vtigercrm600/apache/htdocs"
• ScriptAlias /cgi-bin/ "C:/Program Files (x86)/vtigercrm600/apache/htdocs"

[MySQL] - Regular Expressions - How to check a decimal number

To check if the field value is a decimal number, you can use the following expresion

REGEXP '^[[:digit:]]+\\.{0,1}[[:digit:]]*$'

Example: 
select '3.222' REGEXP '^[[:digit:]]+\\.{0,1}[[:digit:]]*$' as prueba;

Helicóptero antiincendios recogiendo agua en el canal de Villabúrbula

Agusta Koala en plena operación.