<div dir="ltr">Alan,<div><br></div><div>Did you use the latest patches to migration 5.4.0 to 6.1.0?<br></div><div>Earlier patch from 5.4.0 to 6.0.0 - was losing the post-migration version update so was leading to duplicate migration.</div><div><br></div><div>If you are on 6.0.0 and had migrated from 5.4.0 then checking the version in vtiger_version table is important.<br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">DB reporting 5.4.0 - even when it is in 6.1.0</blockquote><div><br></div><div>Please let us know the migration from which it was migrated now.</div><div><ul><li>Fresh from 5.4.0 to 6.1.0<br></li><li>Earlier from 5.4.0 to 6.0.0 and now from 6.0.0 to 6.1.0</li></ul></div><div>Regards,</div><div>Prasad</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect with us on: </b><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/vtiger6/index.php/Main_Page" style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I</b> <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></span></div></div>
<br><div class="gmail_quote">On Mon, Oct 20, 2014 at 12:59 PM, Alan Lord <span dir="ltr"><<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 19/10/14 11:21, Zebra Hosting wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
With several systems that have been migrated from 6.0 to 6.1 (sometimes<br>
with already some beta code updates) I have issues where the admin is<br>
unable to add new users.<br>
I have added the latest SVN on top but that did not made a difference.<br>
<br>
Anyone an idea where this issue could come from and how/where to solve?<br>
</blockquote>
<br>
I did a fairly big migration (> 0.5million rows) this weekend from 5.4.0 to 6.1.0. We'd done a few test migrations before to check it all worked.<br>
<br>
This weekend the migration from 5.4.0 to 6.0.0 seemed to run OK, but, as always, I did some checks before moving on...<br>
<br>
Although no errors were reported to the browser, the display just showed what it had done so far, reported it was all good, and gave me the button to go to the next step. However it turned out that the migration process that runs modules/Migration/schema/540_<u></u>600RC.php had simply stopped around line 1574 just before the line:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Migration_Index_View::<u></u>ExecuteQuery('UPDATE vtiger_currencies SET currency_name = ? and currency_code = ?',<br>
</blockquote>
array('Hong Kong, Dollars', 'LvHong Kong, Dollars', 'HKD'));<br>
<br>
(php.ini was set for max_execution_time = 6000; (10 hours! - the script only takes about 20 minutes if that.)<br>
<br>
So I then copied the remaining code from that file (another 1000 lines or so that hadn't been run!) into a temporary one and modified it a little so I could run it from the command line - it ran to completion without error so I have no idea why it stopped halfway.<br>
<br>
Anyway - once this had completed, I then moved on to the 2nd part, migrating from 6.0.0 to 6.1.0. The first problem was that the first migration hadn't updated the entries in the vtiger_version table which, I think, triggered the 600 to 6.1.0 migration to re-run the 540_600 script!!! This caused a few minor issues with creation of duplicate blocks for some *calendar settings* fields but was fixable once I realised what had happened.<br>
<br>
The 600 to 610 script seemed to run correctly but the database still reported:<br>
<br>
old_version 5.4.0,<br>
current_version 5.4.0<br>
<br>
even though it is now 6.1.0.<br>
<br>
The user screen area gets totally locked-out if the calendar settings fields (now some default options for each user) are not set up correctly.<br>
<br>
Perhaps this would be an area for you to look at?<br>
<br>
vtiger devs: the migration scripts do not seem to be very robust and still need a bit more attention I think.<br>
<br>
Cheers<br>
<br>
Al<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>