Skip to main content

Hello. 

I added a new column to a table and I made a reference to another table. And when I tried to add a value in the column I received this error.

 

 

Can you expand the error by clicking on the blue arrow in the bottom left corner?

And can you also open up the developer tool → debug and show that screen as well?


 


Can you check in your upgrade trigger of good receipts line on line 47? 


I only have a trigger with insert, nothing with update

 

 


Can you check on the database it self?
 

I do think you have a update trigger on the “goods_receipt_line” :)


this is the trigger I sent you earlier
 

 


In that trigger (goods_receipt_line_tu) on line 47, there is something that cannot be converted to a int. That is the location you should be looking at.

I would guess the problem is that the INT you are tying to insert is getting larger then 2147483647, which is the maximum for an int. If you need to go bigger you should be using a BIGINT. 
Or maybe the calculation for adding up is not correct which results into a large number.

This is the error you are getting.

 


It was something wrong with the trigger, thank you! 😊