CoreBOSBB
Update cbupd-0000443: dropForeignKeys (end with error) - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Update cbupd-0000443: dropForeignKeys (end with error) (/showthread.php?tid=2413)



Update cbupd-0000443: dropForeignKeys (end with error) - LorenzoGreco - 08-25-2022

Hi All for your information

Update cbupd-0000443: dropForeignKeys::dropForeignKeys
Drop Foreign Keys
F
ALTER TABLE vtiger_account DROP FOREIGN KEY fk_1_vtiger_account
F
ALTER TABLE vtiger_accountbillads DROP FOREIGN KEY fk_1_vtiger_accountbillads
F
ALTER TABLE vtiger_accountscf DROP FOREIGN KEY fk_1_vtiger_accountscf
F
ALTER TABLE vtiger_accountshipads DROP FOREIGN KEY fk_1_vtiger_accountshipads
F
ALTER TABLE vtiger_activity DROP FOREIGN KEY fk_1_vtiger_activity
F
ALTER TABLE vtiger_assets DROP FOREIGN KEY fk_1_vtiger_assets
F
ALTER TABLE vtiger_campaignscf DROP FOREIGN KEY fk_1_vtiger_campaignscf
F
ALTER TABLE vtiger_contactaddress DROP FOREIGN KEY fk_1_vtiger_contactaddress
F
ALTER TABLE vtiger_contactdetails DROP FOREIGN KEY fk_1_vtiger_contactdetails
F
ALTER TABLE vtiger_contactscf DROP FOREIGN KEY fk_1_vtiger_contactscf
F
ALTER TABLE vtiger_contactsubdetails DROP FOREIGN KEY fk_1_vtiger_contactsubdetails
F
ALTER TABLE vtiger_faq DROP FOREIGN KEY fk_1_vtiger_faq
F
ALTER TABLE vtiger_faqcf DROP FOREIGN KEY fk_1_vtiger_faqcf
F
ALTER TABLE vtiger_invoice DROP FOREIGN KEY fk_2_vtiger_invoice
F
ALTER TABLE vtiger_invoicebillads DROP FOREIGN KEY fk_1_vtiger_invoicebillads
F
ALTER TABLE vtiger_invoicecf DROP FOREIGN KEY fk_1_vtiger_invoicecf
F
ALTER TABLE vtiger_invoiceshipads DROP FOREIGN KEY fk_1_vtiger_invoiceshipads
F
ALTER TABLE vtiger_invoicestatushistory DROP FOREIGN KEY fk_1_vtiger_invoicestatushistory
F
ALTER TABLE vtiger_leadaddress DROP FOREIGN KEY fk_1_vtiger_leadaddress
F
ALTER TABLE vtiger_leaddetails DROP FOREIGN KEY fk_1_vtiger_leaddetails
F
ALTER TABLE vtiger_leadscf DROP FOREIGN KEY fk_1_vtiger_leadscf
F
ALTER TABLE vtiger_leadsubdetails DROP FOREIGN KEY fk_1_vtiger_leadsubdetails
F
ALTER TABLE vtiger_notes DROP FOREIGN KEY fk_1_vtiger_notes
F
ALTER TABLE vtiger_parenttabrel DROP FOREIGN KEY fk_1_vtiger_parenttabrel
F
ALTER TABLE vtiger_parenttabrel DROP FOREIGN KEY fk_2_vtiger_parenttabrel
F
ALTER TABLE vtiger_pobillads DROP FOREIGN KEY fk_1_vtiger_pobillads
F
ALTER TABLE vtiger_poshipads DROP FOREIGN KEY fk_1_vtiger_poshipads
F
ALTER TABLE vtiger_potential DROP FOREIGN KEY fk_1_vtiger_potential
F
ALTER TABLE vtiger_potentialscf DROP FOREIGN KEY fk_1_vtiger_potentialscf
F
ALTER TABLE vtiger_pricebook DROP FOREIGN KEY fk_1_vtiger_pricebook
F
ALTER TABLE vtiger_pricebookcf DROP FOREIGN KEY fk_1_vtiger_pricebookcf
F
ALTER TABLE vtiger_productcf DROP FOREIGN KEY fk_1_vtiger_productcf
F
ALTER TABLE vtiger_products DROP FOREIGN KEY fk_1_vtiger_products
F
ALTER TABLE vtiger_purchaseorder DROP FOREIGN KEY fk_4_vtiger_purchaseorder
F
ALTER TABLE vtiger_purchaseordercf DROP FOREIGN KEY fk_1_vtiger_purchaseordercf
F
ALTER TABLE vtiger_quotesbillads DROP FOREIGN KEY fk_1_vtiger_quotesbillads
F
ALTER TABLE vtiger_quotescf DROP FOREIGN KEY fk_1_vtiger_quotescf
F
ALTER TABLE vtiger_quotesshipads DROP FOREIGN KEY fk_1_vtiger_quotesshipads
F
ALTER TABLE vtiger_quotestagehistory DROP FOREIGN KEY fk_1_vtiger_quotestagehistory
F
ALTER TABLE vtiger_salesorder DROP FOREIGN KEY fk_3_vtiger_salesorder
F
ALTER TABLE vtiger_salesordercf DROP FOREIGN KEY fk_1_vtiger_salesordercf
F
ALTER TABLE vtiger_service DROP FOREIGN KEY fk_1_vtiger_service
F
ALTER TABLE vtiger_sobillads DROP FOREIGN KEY fk_1_vtiger_sobillads
F
ALTER TABLE vtiger_soshipads DROP FOREIGN KEY fk_1_vtiger_soshipads
F
ALTER TABLE vtiger_ticketcf DROP FOREIGN KEY fk_1_vtiger_ticketcf
F
ALTER TABLE vtiger_troubletickets DROP FOREIGN KEY fk_1_vtiger_troubletickets
F
ALTER TABLE vtiger_vendor DROP FOREIGN KEY fk_1_vtiger_vendor
F
ALTER TABLE vtiger_vendorcf DROP FOREIGN KEY fk_1_vtiger_vendorcf
Changeset dropForeignKeys applied!
ERROR: Class dropForeignKeys called without update record in application!!

bye all
Lorenzo


RE: Update cbupd-0000443: dropForeignKeys (end with error) - joebordes - 08-25-2022

Hi

Maybe you have already deleted them? can you please try executing one of those SQL commands directly in MySQL, see if it gives you an error you can share with us.


RE: Update cbupd-0000443: dropForeignKeys (end with error) - LorenzoGreco - 08-25-2022

Query SQL:


In the same installation ( i've alredy applyed the patch endind with the error)

ALTER TABLE vtiger_account DROP FOREIGN KEY fk_1_vtiger_account
Messaggio di MySQL: Documentazione

#1091 - Impossibile cancellare (DROP FOREIGN KEY) `fk_1_vtiger_account`. Controllare che il campo chiave esista

It says impossible to delete (DROP FOREIGN KEY) `fk_1_vtiger_account`. check if field exist.

Lorenzo


RE: Update cbupd-0000443: dropForeignKeys (end with error) - joebordes - 08-25-2022

I understand that, for some reason, your database already has those restrictions deleted

I modified the changeset to mark as applied even if one or more of the queries fails

you should be ok