Hi, each time I try to update I am still getting this error:
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);'
Any ideas why ?
RGDS
Saxa
_______________________________________________
Dolibarr-dev mailing list
Dolibarr-dev@nongnu.org
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
