Error in suppinvstogrn

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Error in suppinvstogrn

Rafael Chacón
Hi All,

I updated a webERP to test. I got this error:

Cannot add or update a child row: a foreign key constraint fails (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES `supptrans` (`id`))

Somebody has an idea abiout how to trouble shoutting this?

Best regards, Rafael.

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

Re: Error in suppinvstogrn

Rafael Chacón
More info:

Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The invoice could not be mapped to the goods received record because Cannot add or update a child row: a foreign key constraint fails (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES `supptrans` (`id`))

Database SQL Failure : The following SQL to map the invoice to the GRN was used INSERT INTO suppinvstogrn VALUES ('457', '123')

Operation:
Enter an invoice, from a purchase order.
Existent suppinv=supptrans.id=457.  No, next auto_increment: 367.
Existent grnno=grns.grnno=123. Yes, It is the last record. Next auto_increment: 124.

Regards, Rafael.



2015-11-30 9:33 GMT-06:00 Tim Schofield <[hidden email]>:
Hi Rafael, could it be that you already have a credit note with that
transaction number. Try echoing the SQL at line 1553 of
SupplierInvoice.php and let me know what the output is.

Thanks
Tim

On 30 November 2015 at 15:08, Rafael Chacón
<[hidden email]> wrote:
> Hi All,
>
> I updated a webERP to test. I got this error:
>
> Cannot add or update a child row: a foreign key constraint fails
> (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN
> KEY (`suppinv`) REFERENCES `supptrans` (`id`))
>
> Somebody has an idea abiout how to trouble shoutting this?
>
> Best regards, Rafael.
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



--
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T   <a href="tel:%2B256%20%280%29%20312%20314%20418" value="+256312314418">+256 (0) 312 314 418
M <a href="tel:%2B256%20%280%29%20752%20963%20325" value="+256752963325">+256 (0) 752 963 325
www.weberpafrica.com
Twitter: @TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk/


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|

Re: Error in suppinvstogrn

ExsonQu
Administrator
Hi, Rafael,

           Thank you for your test!

           It's a bug. Just drop the foreign key as:

            ALTER table suppinvstogrn DROP FOREIGN  KEY `suppinvstogrn_ibfk_1`;

           Best regards!

          Exson
Reply | Threaded
Open this post in threaded view
|

Re: Error in suppinvstogrn

Rafael Chacón
Hi Exson,

Problem solved. Thank you very much!

Best regards, Rafael.

2015-11-30 16:33 GMT-06:00 ExsonQu <[hidden email]>:
*Hi, Rafael,*

           Thank you for your test!

           It's a bug. Just drop the foreign key as:

            ALTER table suppinvstogrn DROP FOREIGN  KEY
`suppinvstogrn_ibfk_1`;

           Best regards!

          Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-in-suppinvstogrn-tp4658434p4658436.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers