Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Error entering Credit
10-16-2015, 10:34 AM,
#1
Database Error entering Credit
Received this error when processing a credit against a customer invoice.

Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The debtor transaction taxes records could not be inserted because
Cannot add or update a child row: a foreign key constraint fails (`bmba`.`debtortranstaxes`, CONSTRAINT `debtortranstaxes_ibfk_1` FOREIGN KEY (`taxauthid`) REFERENCES `taxauthorities` (`taxid`))
Database SQL Failure : The following SQL to insert the debtor transaction taxes record was used
INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount) VALUES('47', '', '-1.818')
Database Rollback Due to Error Above : Rolling Back Transaction OK
Reply


Messages In This Thread
Database Error entering Credit - by M Watson - 10-16-2015, 10:34 AM
RE: Database Error entering Credit - by M Watson - 10-16-2015, 12:15 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)