Today’s mission was to update vtiger 7.3 to 7.4, as 7.3 lacks support for newer php versions.
vtiger provides patch/update-files:
https://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%207.3.0
Grab the patch-file and extract the zip file in your vtiger root directory and replace all existing files (that is, where also vtigerservice.php is present).
Now unzip the newly created vtiger7.zip file as well and also replace all files.
Now login to your vtiger as admin user and hit following url:
https://vtiger-server/crm/index.php?module=Migration&view=Index&mode=step1
Then click Next:
Even though it reports update to vtiger 6 is done, we have now 7.4 installed:
HINT: Don’t use /migrate/ link as often recommended. This link only triggers modules/Migrate/Extract.php, but we did that manually on the console directly.
HINT 2:
After login, i saw the following errors:
'line' => 20,
'function' => 'process',
),
)
Error filling in user array: Query Failed:SELECT id, user_name,first_name,last_name,userlabel from vtiger_users WHERE status=? and (user_name != ‚admin‘ OR is_owner=1) order by user_name ASC::ADODB error Error filling in user array: Query Failed:SELECT id, user_name,first_name,last_name,userlabel from vtiger_users WHERE status=? and (user_name != ‚admin‘ OR is_owner=1) order by user_name ASC::->Unknown column ‚userlabel‘ in ‚field list‘
Additionally i had to create another column in the vtiger_users table, as the udate-script was not able to adjust my table, due to ROW size too large error:
mysql -u root -p …
login, then select your vtiger crm database (use …).
then state:
ALTER TABLE vtiger_users ROW_FORMAT=Dynamic;
ALTER TABLE vtiger_users ADD userlabel VARCHAR(255);