[Vtigercrm-developers] Questions about migration 5.04 -> 5.1.0

Asha asha at vtiger.com
Thu Aug 6 01:00:35 PDT 2009


Hi Christian Castelli,

Failure of these foreign key constraints should not affect the normal
operations of vtiger. Data consistency may become an issue for you going
forward. But I think you can still continue using vtiger without any serious
issues.

On 8/3/09, Christian Castelli <christian.castelli at trackset.com> wrote:
>
> Hi dear vTigers,
> I'm managing the upgrade process from 5.0.4 to 5.1.0 release:
>
> 1) I've received these SQL errors at the end of DB updating:
>
> FAILURE      alter table vtiger_customview drop foreign key
> fk_1_vtiger_customview
> FAILURE      alter table vtiger_senotesrel drop foreign key
> fk_2_vtiger_senotesrel
> FAILURE      ALTER TABLE vtiger_salesorder ADD COLUMN salesorder_no
> varchar(100) not null
> FAILURE      ALTER TABLE vtiger_purchaseorder ADD COLUMN
> purchaseorder_no varchar(100) not null
> FAILURE      ALTER TABLE vtiger_quotes ADD COLUMN quote_no varchar(100)
> not null
> FAILURE      ALTER TABLE vtiger_group2grouprel DROP FOREIGN KEY
> fk_2_vtiger_group2grouprel
> FAILURE      ALTER TABLE vtiger_datashare_grp2grp DROP FOREIGN KEY
> fk_3_vtiger_datashare_grp2grp
>
> I never modified foreign key constaints in the past (relative to DROP
> FOREIGN KEY errors) so will these errors be a problem? The other errors
> fail 'cause there are already that fields.
>
>
> --
> Christian Castelli
> Software Developer
> christian.castelli at trackset.com
>
> Italian Office
> Via Sant'Ilario Sud,109
> 56021 Cascina (PI) - Italia
> TEL +39 050 86 65 387
> FAX +39 050 80 70 136
> www.trackset.com <http://www.trackset.com>
>
> Questo messaggio è destinato alle sole persone indicate e può contenere
> informazioni riservate.
> Se ricevuto per errore, si prega di avvisare immediatamente il mittente
> e cancellare l'originale. Ogni altro uso del messaggio è vietato.
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090806/80aa9e5f/attachment-0003.html 


More information about the vtigercrm-developers mailing list