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.
Best answer by Robbert van Tongeren
View original
This topic has been closed for comments
Userlevel 5
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?
Userlevel 5
Can you check in your upgrade trigger of good receipts line on line 47?
Userlevel 1
+1
- Vanguard
- 18 replies
-
15 July 2022
I only have a trigger with insert, nothing with update
Userlevel 5
Can you check on the database it self?
I do think you have a update trigger on the “goods_receipt_line” :)
Userlevel 5
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.
Userlevel 1
+1
- Vanguard
- 18 replies
-
15 July 2022
It was something wrong with the trigger, thank you! 😊
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.