webERP Forum
Can´t add Prices, Database Error 1452 - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: Can´t add Prices, Database Error 1452 (/showthread.php?tid=1928)



Can´t add Prices, Database Error 1452 - MoZqUiTo - 09-24-2013 10:58 PM

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?


RE: Can´t add Prices, Database Error 1452 - phil - 09-25-2013 07:53 AM

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


RE: Can´t add Prices, Database Error 1452 - MoZqUiTo - 09-25-2013 02:08 PM

Great...
Just a simple Solution. Thank You.


RE: Can´t add Prices, Database Error 1452 - batool100 - 01-28-2014 07:44 PM

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?


RE: Can´t add Prices, Database Error 1452 - Forums - 01-28-2014 08:02 PM

Have you setup a Sales Type as per Phils comment above?

Thanks
Tim