Hi Christian Castelli,<br><br>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.<br>
<br><div><span class="gmail_quote">On 8/3/09, <b class="gmail_sendername">Christian Castelli</b> <<a href="mailto:christian.castelli@trackset.com">christian.castelli@trackset.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi dear vTigers,<br> I'm managing the upgrade process from 5.0.4 to 5.1.0 release:<br> <br> 1) I've received these SQL errors at the end of DB updating:<br> <br> FAILURE alter table vtiger_customview drop foreign key<br>
fk_1_vtiger_customview<br> FAILURE alter table vtiger_senotesrel drop foreign key<br> fk_2_vtiger_senotesrel<br> FAILURE ALTER TABLE vtiger_salesorder ADD COLUMN salesorder_no<br> varchar(100) not null<br> FAILURE ALTER TABLE vtiger_purchaseorder ADD COLUMN<br>
purchaseorder_no varchar(100) not null<br> FAILURE ALTER TABLE vtiger_quotes ADD COLUMN quote_no varchar(100)<br> not null<br> FAILURE ALTER TABLE vtiger_group2grouprel DROP FOREIGN KEY<br> fk_2_vtiger_group2grouprel<br>
FAILURE ALTER TABLE vtiger_datashare_grp2grp DROP FOREIGN KEY<br> fk_3_vtiger_datashare_grp2grp<br> <br> I never modified foreign key constaints in the past (relative to DROP<br> FOREIGN KEY errors) so will these errors be a problem? The other errors<br>
fail 'cause there are already that fields.<br> <br> <br> --<br> Christian Castelli<br> Software Developer<br> <a href="mailto:christian.castelli@trackset.com">christian.castelli@trackset.com</a><br> <br> Italian Office<br>
Via Sant'Ilario Sud,109<br> 56021 Cascina (PI) - Italia<br> TEL +39 050 86 65 387<br> FAX +39 050 80 70 136<br> <a href="http://www.trackset.com">www.trackset.com</a> <<a href="http://www.trackset.com">http://www.trackset.com</a>><br>
<br> Questo messaggio č destinato alle sole persone indicate e puņ contenere<br> informazioni riservate.<br> Se ricevuto per errore, si prega di avvisare immediatamente il mittente<br> e cancellare l'originale. Ogni altro uso del messaggio č vietato.<br>
_______________________________________________<br> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br> </blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Asha<br>
vtiger Team