<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thanks Prasad I checked out the
540_to_600rc.php and it was clearly doing a lot more than I had
given it time for. I have just extended max exe time and hopefully
it will now complete properly. <br>
<br>
Perhaps it would be good to send a special "completed" line at the
bottom of the log from the scripts run by the ajax so that the
system will see that the process was interrupted and not report
success in such a case.<br>
<br>
On 06/01/14 17:30, Prasad wrote:<br>
</div>
<blockquote
cite="mid:CAMeS7pm-i9FaEV7SKx2wUF+KBB6Xydh1Gv+wBxqXoXCMaaoj7A@mail.gmail.com"
type="cite">
<div dir="ltr">Richard.
<div><br>
</div>
<div>Did you review the migrated query logs - were there any
failures cited on the screen?</div>
<div><br>
</div>
<div>540_to_600RC.php (~ line: 789) - script adds label column
to vtiger_crmentity and then populates it with existing record
label. This will be required to get the default global search
and reference field auto-complete to work.<br>
</div>
<div><br>
</div>
<div>Please redo the migration fresh and analyze.</div>
</div>
<div class="gmail_extra"><br clear="all">
<div><span
style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect
with us on: </b><a moz-do-not-send="true"
href="http://twitter.com/vtigercrm"
style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a
moz-do-not-send="true"
href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall"
style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a
moz-do-not-send="true" href="https://blogs.vtiger.com/"
style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a
moz-do-not-send="true"
href="http://wiki.vtiger.com/index.php/Main_Page"
style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a
moz-do-not-send="true"
href="https://discussions.vtiger.com"
style="color:rgb(0,0,204)" target="_blank">Forums </a><b>I</b> <a
moz-do-not-send="true" href="https://www.vtiger.com/"
style="color:rgb(0,0,204)" target="_blank">Website</a></span></div>
<br>
<br>
<div class="gmail_quote">On Mon, Jan 6, 2014 at 7:53 AM, Richard
Hills <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
I have just made an attempted upgrade on our in house vtiger
5.4 install (test copy only we will most likely not migrate
until 6.1 is released) to the latest RC using the package
provided (vtigercrm-540-600rc-patch.zip).<br>
<br>
Although I can login and a lot of records have been migrated
and workflows created etc, I find that few of the modules
are accessible apart from contacts, sales orders and a
couple of other modules which we don't use.<br>
<br>
Tickets and organisations are examples of two of the modules
which do not work (blank screen only).<br>
<br>
When checking the error log on the accounts module I found
the following query is causing the issue (and no, its not
because of the or craziness):<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Query Failed:SELECT crmid, setype, label FROM
vtiger_crmentity WHERE crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=?::ADODB error Query
Failed:SELECT crmid, setype, label FROM vtiger_crmentity
WHERE crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=?
OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=? OR crmid=? OR crmid=? OR crmid=? OR crmid=? OR
crmid=?<br>
</blockquote>
<br>
With the error being:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Unknown column 'label' in 'field list'<br>
</blockquote>
<br>
I am somewhat surprised I have not seen anyone else
mentioning this sort of bug on the list so thought I should
ask if I have missed something?<br>
<br>
Thanks in advance for any advice.<span class="HOEnZb"><font
color="#888888"><br>
<br>
<br>
-- <br>
Richard Hills<br>
TechnologyWise Ltd, Tauranga, NZ<br>
<a moz-do-not-send="true" href="mailto:richard@tw.co.nz"
target="_blank">richard@tw.co.nz</a><br>
<a moz-do-not-send="true"
href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a><br>
ph: +64 (0)7 571 1060<br>
fax: +64 (0)7 571 1061<br>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
target="_blank">http://www.vtiger.com/</a><br>
</font></span></blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a class="moz-txt-link-abbreviated" href="http://www.technologywise.co.nz">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
</body>
</html>