[Vtigercrm-developers] 5.4.0 -> 6.0 RC Migration

[Richard Hills]

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.

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.

On 06/01/14 17:30, Prasad wrote:
> Richard.
>
> Did you review the migrated query logs - were there any failures cited 
> on the screen?
>
> 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.
>
> Please redo the migration fresh and analyze.
>
> *Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* 
> Facebook 
> <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I* 
> Blog <https://blogs.vtiger.com/>* I* Wiki 
> <http://wiki.vtiger.com/index.php/Main_Page> *I *Forums 
> <https://discussions.vtiger.com>*I* Website <https://www.vtiger.com/>
>
>
> On Mon, Jan 6, 2014 at 7:53 AM, Richard Hills <richard at tw.co.nz 
> <mailto:richard at tw.co.nz>> wrote:
>
>     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).
>
>     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.
>
>     Tickets and organisations are examples of two of the modules which
>     do not work (blank screen only).
>
>     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):
>
>         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=?
>
>
>     With the error being:
>
>         Unknown column 'label' in 'field list'
>
>
>     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?
>
>     Thanks in advance for any advice.
>
>
>     -- 
>     Richard Hills
>     TechnologyWise Ltd, Tauranga, NZ
>     richard at tw.co.nz <mailto:richard at tw.co.nz>
>     www.technologywise.co.nz <http://www.technologywise.co.nz>
>     ph: +64 (0)7 571 1060
>     fax: +64 (0)7 571 1061
>
>     _______________________________________________
>     http://www.vtiger.com/
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140107/e510a29c/attachment.html>