[Vtigercrm-developers] Another migration script query...

[Alan Lord]

On 03/03/16 15:16, Alan Lord wrote:
> On 03/03/16 15:05, Alan Lord wrote:
> On the original vtiger system (5.2.1) in a ticket comment I see
> something like this:
>
>> We'll keep you updated about this webcast.
>> Know someone else that'd be interested?'
>> Author : Alan Riley Lord on 2015-12-01 08:03:41
>
> I have changed the "Author" name but what is displayed *is* the name of
> the Contact.
>
> In the migrated system in that ticket the author name has been replaced
> by the name of the vtiger Administrator!!!
>
> I have a customer where support is their main business and loosing this
> information would be catastrophic - we have about 12,000 comments on
> Tickets.
>
> Can one of the devs tell me where the problem is here?

So the migration script is broken (again).

The Contact ID doesn't belong in vtiger_crmentity at all... It belongs 
in the vtiger_modcomments table in the "customer" column...

This is not in any of the migration scripts...

I will file a bug

Al