VTiger CRM 5.4 to vTiger CRM 6.0 Upgrade/Migration Tool
Long waited vTiger CRM 5.40 Upgrade/Migration Tool to vTiger CRM 6.0 has been released. Since there’s no stable or RC version of vTiger CRM 6.0 – this migration/upgrade tool only works with the beta version. According to vTiger CRM developers, this should not be used for production and is only for testing purposes, however if you want to move quickly and can not wait for RC/Stable version – you should be able to upgrade your vTiger CRM 5.40 to vTiger CRM 6.0.
We’ve done few migrations already and it seems to be working as expected. The migration/upgrade process is quick and easy to perform, however if you don’t feel comfortable doing it – feel free to contact us and we’ll help you out.
- First and the most important step is – backups.You have to take a backup of you existing vTiger CRM database and the file structure. The way the migration/upgrade works is that it will overwrite the existing files as well as update the database, so again the backups are crucial and there’s no way to revert back from vTiger CRM 6.0 to vTiger CRM 5.4.
- The second step is download the vTiger CRM 6.0 Upgrade/Migration too. It can be downloaded from here
- Place the downloaded file into your vtigercrm directory and extract it.
- Once the extracted, open up your browser and go to http://www.yourvtiger.com/vtigercrm/migrate/index.php. (replace yourvtiger.com/vtigercrm/ with your vTiger crm host/directory).
- You should have already taken the backups, so go a head and check “I have taken the backup of the database” as well as “I have taken the backup of source code“.
- Enter your existing vTiger CRM admin password.
- Hit “Start Migration“
- It should then open a “Migration Wizard” which will replace the files and run the necessary queries to update the database. Assuming everything went well – you will be able to click “Next“.
- The final page will open up confirming successful migration, then hit “Finish” you will be redirected to your shinny new vTiger CRM 6!
There are possibility that you will run into few issues when doing the upgrade/migration to vTiger CRM 6.0. One of the possible errors are:
- “INVALID CREDENTIALS”
Make sure that you entered the existing vTiger CRM 5.4 credentials. You are not creating a new user here.
- “ERROR EXTRACTING MIGRATION ZIP FILE”
The error is not very descriptive, but what that means is that you have to set  your vtigercrm folder to be writable by the web. To do so, you would set proper permissions(chmod 755-777) and the user(chown apache/www-data).
- “ERROR READING MIGRATION ZIP FILE”
Assuming you’ve proper permission – you should not run into this error, however if you do – make sure that the vtiger6.zip file in your vtigercrm/ directory can be extracted/access by webuser.
If you would like the professionals do the upgrade/migration for you – please give us a call or shoot as an email at support@VTExperts.com and we will be glad to get you up and running on vTiger CRM 6.0 in no time!
50 Comments
on point 4 you wrote an path. What is the oath when i use localhost?
You would then use http://localhost/, if there’s a port you would add port as well “http://localhost:8888”
As for vTiger directory, it would be in your Program Files/vtigercrm…/apache/htdocs/ I believe.
on point 4 i am using localhost at location http://localhost:81/vtigercrm-5.4.0/apache/htdocs/vtigerCRM/migrate and i am getting a Not Found error. What is the correct location for the migrate folder?
It should be ‘yourlinktovtiger’ + ‘/migrate/’
Say if you access your vTiger via http://localhost:81/ then you should go to http://localhost:81/migrate/ to perform the upgrade.
Hope that helps.
I tried everything they say on this website :
http://www.vtigerexperts.com/vtiger-crm-5-4-vtiger-crm-6-0-upgrade-migration-tool/
but still I get same error :
ERROR EXTRACTING MIGRATION ZIP FILE!
I’m trying to update from 5.4 to 6.0
I checked ownerships and permissions many times and nothing helps.
What should I do now ?
after clicking the check boxes , we get a blank white page, have you seen this issue
Did you confirm the pre requisites?
Try enabling errors in index.php(which is in migration folder)
http://www.vtigerexperts.com/what-to-do-if-you-get-a-blank-white-page-in-vtiger/
thank you for your quick reply, i believe that we do meet the requirements. I followed the suggestion about adding the code to the index.php file in the /migrate folder, but did not see any errors, just the blank white page. I have listed the conf information from php admin below. We recently re installed 5.4 and restored the DB. The 5.4 version is functioning properly.
Server: Localhost via UNIX socket
Server version: 5.5.31-0ubuntu0.12.10.1
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)
Apache/2.2.22 (Ubuntu)
MySQL client version: 5.5.31
PHP extension: mysqli Documentation
phpMyAdmin
Version information: 3.4.11.1deb1
tried but keep getting this error
Fatal error: Call to undefined method ModComments_Module_Model::updateVtigerVersion() in/home/jaulumbi/public_html/chui/modules/Migration/views/Index.php on line 118
Please advise
Jonathan – we’ll need some more information to help you out. What is the OS? Was standard vtiger database modified?
Hello,
I got the same error message than Jonathan.
Fatal error: Call to undefined method ModComments_Module_Model::updateVtigerVersion() in /volume1/web/vtigercrm/modules/Migration/views/Index.php on line 118
I am on a Synology which actually is powered by Linux (armv7l GNU/Linux synology_armadaxp_ds214+)
Ideas?
Thanks.
What’s the PHP version on synology? I know they just released an update which comes with PHP 5.5.
Our Synology is currently running with PHP version 5.5.11
That’s most likely of the PHP version. Only the PHP 5.3 is supported.
hi i follow your instruction when i click on migrate button it will give me a blank screen what should i have to do for this error. thanks
Log out of your existing vTiger 5.4 build and try again. Also try enabling errors and see what the error is. Other way to see the error is look at the URL.
Hope that helps.
Upgrade was successful. however after upgrade the login page appears but when entering login credentials, a blank white page comes up even after trying with all browsers.
\
Can you try enabling errors in index.php or php.ini ? Once the display_errors is on that should tell you why you are getting the blank screen.
thanks i successfully migrate from vtiger 5.4.0 to 6.0 thanks for such a good tutorial.
I am not able to do the migration from 5.4 to 6. when i provide the credentials and hit the start migration button I am getting the blank page. Please help me how I can migrate from 5.4 to 6.0.
Thanks in advance
Hari – It’s really difficult to tell why, but most likely server environment or php version. I sent you a follow up via email.
hi
i just try to use the Migration tool the second time after canceling the first run.
I have the Problem that it doesn’t finish… without any error.
After starting the Migration the Migration wizard Comes up and says “please wait… Migration in Progress” and the progressbar runs,
but after about 1,5hours i canceled the first try, resetted everything and tried again, but the same issue.
can anybody give me a hint?
i come from 5.2.1, just migrated sucessfull to 5.4 if this helps…
Thanks,
Dennis
I have same issue both with migrating 5.4-6.0 and with blank installation of v.6. Reverter to 5.4 – glad I made backups
You should always make backups, we purposely indicated that the backups are the MOST important step. As far as the blank screen – enable errors in php.ini and run the migration again, that will tell you what’s wrong.
Hi Hari,
my experinece is that you’ll get the blank page when the php-zip-extension is not installed.
Try to find out the name of the package (e.g. php5-zip in openSUSE),
install it and restart the webserver. Then try again.
Update here went seamlessly apart from that problem.
But vTiger is not working properly afterwards.
Best regards
Matthias.
Hi,
migration was successfully but after login i get an error message after call “Organizations”, “Leads” or “Contacts” in the menu.
Fatal error: Call to a member function getId() on a non-object in /is/htdocs/wp10725802_AP6SP9SHMX/www/vtigercrm/modules/Leads/models/ListView.php on line 34
I use vtigercrm on german hoster Hosteurope. PHP is version 5.3
migration as per steps not able to view page also not able to understand that how to migrate page open only put 64bit os in windows
After the migration I get blank screen when I try to add or edit a user as the administrator. I have verified that all directories/files are owned by apache. I also turned on display_errors but did not receive any additional information. I’ve seen this mentioned a few places but have not seen a response.
Thanks
We had few requests that came up with that, it’s environment related – we didn’t go into details but we were able to successfully upgrade on our infrastructure. We could look at your specific case – feel free to contact us
Hi,
Thank you for this article.I have followed the steps above as instructed .However immediately after filling in my admin username and password, I get a blank page.What could be causing this?
Any reply from you will be highly appreciated.
Look at the link/url when you see the blank page – the link will contain the error messsage
Hello, Thank you for the tutorial. It got me to the point where things seemed to be working. There is a problem however, that I thought someone here might be able to help with.
In my situation the migration seems to start but then runs for hours / days without getting past the ‘Migration in Progress’ graphic on /index.php?module=Migration&view=Index&mode=step1 .
After quite some time I seem to be able to see the migrated installation (in another browser window) but I have no idea if everything completed properly. Any suggestions?
Thanks
It’s really difficult to tell, if I were you I would redo the migration using the other browser so you can see the end result, again you can’t really tell if the migration was successful because there are so many tables in the database.
Hi vte, Yes… I have tried Firefox, Chrome and IE… they all seem to act the same way. he page shows that the migration is running but it never completes. Strangely I do not see the progress screen that you show in picture 2 (above) so cannot tell how far along the migration is. I’ve tried turning debug on but it’s not showing me anything useful.
If it’s a huge database it will take a while to upgrade, you could see if it’s running or not by doing the ‘show full processlist;’ on the mysql server to see if the upgrade queries are running, if they are that means the migration is still in progress, if they are not – there’s an issue.
Feel free to contact us if you need help with the migration – we can do that for you.
I am having problems in viewing the tickets and oppurtunities when i click any of the organisation. There seems to be some problem after upgrade.
Amit – we are not aware of this issue, we’ll contact you and see if we can get that resolved.
Sir, I have mailed the details to you and added snapshots too. Also is there any developer book for version 6 so that I can go through it and try to solve myself before disturbing you guys.
I have found out the reason behind errors in troubletickets and potential table. there is a column contact_id in both of these tables that does not exist in v5.4 so as that column is not there it throws an error. I tried to create a column named contact_id in both but still could not solve that issue as it also needs to have proper values inserted. SO in short the migration tools need to be updated or corrected. regards amit
Hello, Thank you for the tutorial. It helped me alot . There is a problem however, that I thought someone here might be able to help with.
In my situation the migration seems to start but then runs for hours / days without getting past the ‘Migration in Progress’ graphic on /index.php?module=Migration&view=Index&mode=step1 .How much time it will take to complete the migration. The screen hung up on Migration Inprogress graphic.
Any suggestions?
Thanks
How big is a database? where are you hosted? what browser are you using? Thanks
Hi,
Do you know if the migration tool to v6 is stable now?
My upgraded version has some malfunctions, as eg in organizations window, showing some weird fields in the default (all) view.
Most important of all it does NOT show the organization name. I can customize new views that works…
Br
Elise
I don’t believe the migration script has been upgraded yet, however we are not aware of the issues that you described – we would be happy to take a look and help you out with that. We’ll contact you by the email.
hello does it work on 5.1 -> 6.0 ?
regards
It does work, however you have to go through a lot more steps to get 5.1 > 5.4 and only then 5.4 > 6.0
hello. firstly i have little english sorry.
i had blank/white screen error when i click “start migration” button. i tried to set 777 chmod all files. still white.
i tried to open display_error. but i cant see any error . my php versiyon is 5.3 . And i found solution in this site. problem is zip extrnsion. but i cant find php-zip extension for centos. And i extracted vtiger6.zip manually.and go to /index.php?module=Migration&view=Index&mode=step1
problem was solved
MIGRATIN SUCCESFUL
Thanks for taking the time and sharing the solution.
Hello,
We try to migrate Vtiger 5.4 to 6.0 but we have a big mistake.
We try several times ( 10) but it’s the same result the database is the same, no alter, no update, no create.
We don’t undestand.
We make the upgrade on :
Wamp server – php 5.3 – Mysql 5.5.24 engine Innodb
all the tables are in Innodb.
If you ahve an idea it will be a big pleasure
Thanks a lot
Denis
Hello!
when i start the mirgateion i get this error
Warning: mysql_pconnect() [function.mysql-pconnect]: Unknown MySQL server host ‘localhost’ (11001) in C:\Program Files (x86)\vtigercrm-5.4.0\apache\htdocs\vtigerCRM\libraries\adodb\drivers\adodb-mysql.inc.php on line 373
Has someone any help for me?!
Thanks
Regards Andi
Hello all,
My boss asked me to migrate the old vtiger 5.1 to latest one (6.4). I succeded in migrating from 5.1 to 5.4.
But i’m facing, the infinite Migration inpprogress window.
So i started from a fresh vtiger 5.4, with vtiger demo database, and started to migrate it. 6 hours later, it’s still in progress.
I tryed with firefox and IE, that’s the same.
i use debian squeeze, SQL is 1.5.73, php is 5.3.3.
mysql> show full processlist;
+—-+——+———–+————–+———+——-+——-+———————–+
| Id | User | Host | db | Command | Time | State | Info |
+—-+——+———–+————–+———+——-+——-+———————–+
| 42 | root | localhost | vtigercrm540 | Sleep | 20693 | | NULL |
| 43 | root | localhost | vtigercrm540 | Sleep | 20693 | | NULL |
| 44 | root | localhost | vtigercrm540 | Sleep | 20380 | | NULL |
| 45 | root | localhost | vtigercrm540 | Sleep | 20693 | | NULL |
| 46 | root | localhost | vtigercrm540 | Sleep | 20667 | | NULL |
| 47 | root | localhost | vtigercrm540 | Sleep | 20651 | | NULL |
| 49 | root | localhost | vtigercrm540 | Sleep | 20397 | | NULL |
| 50 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+—-+——+———–+————–+———+——-+——-+———————–+
8 rows in set (0.00 sec)
I’m not the only in this case, but why are those process sleeping ?