Frequently Faced Migration Issues
October 9th, 2009 by puneeth
It has been few months since vtigerCRM5.1.0 release and expect
quite a good number of people have migrated to the latest version.
During this period, we have come across the issues frequently faced
by the community members.
Issue: In Accounts modules ‘More Information’ tab displayed nothing except for a blank page ?
Reason: This occurs because of installation of some custom module (Project module) in vtigercrm504.
Fix: Disable the custom module (Project module) from the Module Manager of vtigercrm510.
Issue: After Migration list view does not appear ?
Reason: This occurs because the tables vtiger_tab and vtiger_users in this setup are not of type InnoDB, but of type MyISAM.
Fix: Refer this forum post http://forums.vtiger.com/viewtopic.php?t=24965&highlight=
Issue: Settings page menu is coming multiple times
Reason: Migration fails silently without renaming the required files and directories and people just run the migration one more time.
More Details: http://forums.vtiger.com/viewtopic.php?t=26419&postdays=0&postorder=asc&start=0
Some other queries related to migration can be viewed here:
How to migrate on windows between two vtigercrm exe installation:
http://forums.vtiger.com/viewtopic.php?t=25979&highlight=
How to migrate from linux (5.0.x) to windows (5.1.0.):
http://forums.vtiger.com/viewtopic.php?t=26263&highlight=
We request the community members also to update with the issues related to migration if any.
Regards,
Puneeth.
vtiger Team.




We migrated already a couple hundred systems without any substantial problems. I can recommend to everyone to do the following:
- make a backup of your Database AND your file system before you start any migration
- read the description of the migrate procedures, start only if you are sure that you have understand everything and follow the procedure steps one by one
- if you see an error during migration, stop and fix it before you go any further
- if you migrate from a version earlier than v5.0.4 do not migrate to v5.1. directly. (That means: from v5.0.2 migrate to v5.0.3, when finished and everyything works as expected migrate from v.5.0.3 to v5.0.4 and check again your system.) I know this is much more work but the migration procedues of the earlier versions are buggy and generate data base errors sometimes. These errors must get fixed before you continue to migrate to the next version.
Hi guys:
Thanks a lot for this post.
Can you please give us more explanations about the issue with Settings page coming multiple times and failing of migration?
I am still experiencing this problem and still it does not work. It finishes some of the SQL queries and then there is no Next button to move on. Then when trying to open again it gives the option to migrate. Can it be because of the size of database?
I am a bit confused so your help is very much appreciated.
Thanks,
f.
Hi Faton,
You can see the Settings page twice, if you have performed the migration more than once if it had failed for the first time.
The migration failure could be because of two reasons
1. If the database size large and if you are trying to use the database back up option provided in the migration wizard. You can over come this by manually taking a database back up before performing the migration.
2. Your migration could be timing out due to the database size. Kindly increase the PHP timeout in “php.ini” file.
Thanks,
Puneeth.
vtiger Team
Hi Balduin,
Thanks for your inputs.
Regards,
Puneeth.
vtiger Team.
Hi Puneeth:
Thanks a lot for your prompt reply.
Yes, the database size is large and sometimes it gets slow (around 250000 records in CRMentity table).
I am doing the first step — manual backup of database before. But I did not try the second. Will try it now and let you know.
Thanks a lot,
faton
how can I customize the Account Number
Hi Walter,
Please refer the following URL for information on Customizing Module Sequence :
http://wiki.vtiger.com/index.php/vtiger510:Feature_Module_Sequence_Numbering
Regards,
Puneeth.
vtiger Team.
Hi Puneeth:
Getting back to the migration problem, I tried it again applying your instructions but still it could not complete and it was not showing next button after sql queries.
Made a backup of database and changed the max_execution_time in php.ini. I actually added also the set_time_limit(0); and set mysql.connect_timeout = -1. After I restarted the server and started migration but the problem still persists.
Could this be because of the size of the database? Is there any other way to overcome this problem?
Thanks a lot in advance for your help.
regards,
f.
Is there a way to export all your leads with a command?
Thanks
Jesse