Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Can´t add Prices, Database Error 1452
09-24-2013, 10:58 PM,
Can´t add Prices, Database Error 1452
Hi there,

I just installed the WebERP on my Server and finished all of my parameters. So I wanted to try that system. I added a Vendor and an Item. After creating the Item I clicked on Maintain Pricing, added my Price and click on enter.

Than an error Message appears:

Database Error 1452 : The new price could not be added
Cannot add or update a child row: a foreign key constraint fails (`weberp`.`prices`, CONSTRAINT `prices_ibfk_3` FOREIGN KEY (`typeabbrev`) REFERENCES `salestypes` (`typeabbrev`))

Database SQL Failure : The SQL that failed was
INSERT INTO prices (stockid, typeabbrev, currabrev, startdate, enddate, price) VALUES ('EK00001', '', 'EUR', '2013-09-24', '0000-00-00', '14.50')

Can somebody help me? Whats wrong?

Messages In This Thread
Can´t add Prices, Database Error 1452 - by MoZqUiTo - 09-24-2013, 10:58 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)