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.
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” :)
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.
It was something wrong with the trigger, thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.