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

Christian Castelli christian.castelli at trackset.com
Mon Aug 3 02:48:44 PDT 2009


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.



More information about the vtigercrm-developers mailing list