[Vtigercrm-developers] 5.4.0 -> 6.0 RC Migration

[Prasad]

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> 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
> www.technologywise.co.nz
> ph: +64 (0)7 571 1060
> fax: +64 (0)7 571 1061
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140106/207d84e0/attachment.html>