webERP Forum

Full Version: Can´t add Prices, Database Error 1452
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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?
Have you created any price lists (called sales types) in webERP yet?
Go to

Menu -> Setup ->Receivables/Payables SetupReceivables/Payables Setup -> Sales Types

or http://yourdomain/webERP/SalesTypes.php
Great...
Just a simple Solution. Thank You.
Why I am getting four ERROR 1452 (23000): MySQL Cannot add or update a child row: a foreign key constraint fails (look above for exact errors)

Does anyone know how to fix this? Or what I did wrong at least?
Have you setup a Sales Type as per Phils comment above?

Thanks
Tim
Reference URL's