vTiger 6.5 - 7.0.1 migration - Dashboard error
When migrating from version 6.5 to version 7.0.1, any widgets a User had setup on their dashboard no longer show up.
The issue is caused when the vtiger_module_dashboard_widgets table is updated with the new column dashboardtabid which joins to the new table vtiger_dashboard_tabs. The value entered in all records in vtiger_module_dashboard_widgets is 1 - which is the default Tab for the Admin account not the User the widget is associated with
Instead it should change to the correct value to identify the entry in vtiger_dashboard_tabs related to the same userid