<div dir="ltr">Angelo and Alan,<div><br></div><div>Could you please comment on my last email. Please let me insist. I would like to know if you agree with my observations and how you run the db migration from command line.</div><div><br></div><div>Thanks in advance!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Sep 28, 2024 at 7:03 AM Rubén A. Estrada Orozco <<a href="mailto:rulotec1@gmail.com">rulotec1@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">According to my colleague who did the migration, it didn't all go smoothly. He installed vt 8.2, replaced the database, changed vtigerversion.php and the vtiger_version table to set the current version at 7.5, and then ran the migration from the browser (not the command line). <div><br></div><div>The function <b>Migration/models/Module::</b><span style="font-weight:bold">getAllowedMigrationVersions</span><span style="font-weight:bold">(</span><b><span></span></b><span><b>) </b>should be updated to include the migration scripts from 8.0 to 8.1, 8.1 to 8.2 and 8.2 to 8.3.</span></div><div><span><br></span></div><div><span>See: <a href="https://code.vtiger.com/vtiger/vtigercrm/-/blob/master/modules/Migration/models/Module.php" target="_blank">https://code.vtiger.com/vtiger/vtigercrm/-/blob/master/modules/Migration/models/Module.php</a></span></div><div><span><br></span></div><div><span>The function looks like this:</span></div><div><span><br></span></div><div><span><pre lang="php"><span> </span><span>public</span><span> </span><span><span>function</span><span> </span><span>getAllowedMigrationVersions</span><span>(</span><span></span><span>)</span></span><span>{</span>
<span> </span><span>$versions</span><span> = </span><span>array</span><span>(</span>
<span> </span><span>array</span><span>(</span><span>'540'</span><span> => </span><span>'5.4.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'600RC'</span><span> => </span><span>'6.0.0 RC'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'600'</span><span> => </span><span>'6.0.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'610'</span><span> => </span><span>'6.1.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'620'</span><span> => </span><span>'6.2.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'630'</span><span> => </span><span>'6.3.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'640'</span><span> => </span><span>'6.4.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'650'</span><span> => </span><span>'6.5.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'660'</span><span> => </span><span>'6.6.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'700'</span><span> => </span><span>'7.0.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'701'</span><span> => </span><span>'7.0.1'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'710'</span><span> => </span><span>'7.1.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'711'</span><span> => </span><span>'7.1.1'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'720'</span><span> => </span><span>'7.2.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'73'</span><span> => </span><span>'7.3'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'730'</span><span> => </span><span>'7.3.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'740'</span><span> => </span><span>'7.4.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'750'</span><span> => </span><span>'7.5.0'</span><span>),</span>
<span> </span><span>array</span><span>(</span><span>'800'</span><span> => </span><span>'8.0.0'</span><span>),</span>
<span> );</span>
<span> </span><span>return</span><span> </span><span>$versions</span><span>;</span>
<span> }</span>
</pre><pre lang="php"><br></pre><pre lang="php">Alan and Angelo, I imagine you didn't get the error because you run it from the command line. May I ask how exactly you do it?</pre><pre lang="php">But it seems that anyone doing the migration using the "traditional" way, wouldn't get his database migrated, just the php files.</pre><pre lang="php"><br></pre></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 25, 2024 at 6:08 AM Rubén A. Estrada Orozco <<a href="mailto:rulotec1@gmail.com" target="_blank">rulotec1@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Ok, I'll run the migration scripts using php 8.2 and see how it goes. <div><br></div><div>Thanks Alan and Angelo!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 25, 2024 at 5:39 AM Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">+1. This is pretty much how I do it too.<br>
<br>
Al<br>
<br>
On 25/09/2024 12:04, Angelo Paglialonga wrote:<br>
> Hi Ruben it works updating db with migration scripts, i do it one at the <br>
> time using die on error set to on for $adb, about the files i prefer <br>
> cloning a brand new vt 8.2 instance and than copying: storage temp <br>
> user_privileges and so on , I hope it helps!<br>
> *<br>
> <br>
> Dott. Angelo Paglialonga*<br>
> Consulenza vTiger CRM ad alto ROI.<br>
> Telefono: 338.6077866<br>
> Sito web*: *<a href="http://angelopaglialonga.com" rel="noreferrer" target="_blank">angelopaglialonga.com</a> <<a href="https://treeway.it/angelo//" rel="noreferrer" target="_blank">https://treeway.it/angelo//</a> <br>
> shorturl.php?id=6457a0339d9398.33634588><br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div>
</blockquote></div>
</blockquote></div>