Request
109 sql='UPDATE llx_bank_account AS ba SET fk_accountancy_journal =
(SELECT rowid FROM llx_accounting_journal AS aj WHERE
ba.accountancy_journal = aj.code) WHERE accountancy_journal NOT IN ('1',
'2', '3', '4', '5', '6', '5', '8', '9', '10', '11', '12', '13', '14',
'15');'
Request 110 sql='ALTER TABLE llx_bank_account ADD
CONSTRAINT fk_bank_account_accountancy_journal FOREIGN KEY
(fk_accountancy_journal) REFERENCES llx_accounting_journal (rowid);'
Errore
DB_ERROR_1452: ALTER TABLE llx_bank_account ADD CONSTRAINT
fk_bank_account_accountancy_journal FOREIGN KEY (fk_accountancy_journal)
REFERENCES llx_accounting_journal (rowid);
Cannot add or update a
child row: a foreign key constraint fails
(`banco_dolibarr`.`#sql-4af_41f63d`, CONSTRAINT
`fk_bank_account_accountancy_journal` FOREIGN KEY
(`fk_accountancy_journal`) REFERENCES `llx_accounting_journal`
(`rowid`))
Request 111 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_tiers varchar(32);'
Request 112 sql='ALTER TABLE llx_accounting_bookkeeping CHANGE COLUMN code_tiers thirdparty_code varchar(32);'
Request 113 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN subledger_account varchar(32);'