vt 7.4 schema migration script not being executed in migration and error in query [urgent: this leaves vtiger unusable]
modules/Migration/schema/730_to_740.php
doesn't seem to be executed in migration from vt 7.3
Since the row userlabel
in table vtiger_users is not created, you get the following query 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::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'
Furthermore, the update query generated here has an error:
$sql = "UPDATE vtiger_users SET $fieldName = TRIM(CONCAT(".implode(' ', $entityFieldNames)."))";
the first argument in the implode function should be this: ', '
and not this ' '
It seems this script was not even tested once, this would have popped out immediately.