/
Error null when editing item
Error null when editing item
The error appears after clicking save and the item does not updated.
Showlog the error will give error at line 871 from DoInvItemEdit
Check the categoryid for the item
select pkid, item_code, categoryid from inv_item where item_code = 'ACER-K202HQL'; pkid | item_code | categoryid -------+--------------+------------ 83838 | ACER-K202HQL | 1000 (1 row)
Check the categoryid. This shows that the categoryid for the item is not existing.
select * from inv_category where pkid = 1000; pkid | category_code | name | description | status | lastupdate | userid_edit | parent_id | level ------+---------------+------+-------------+--------+------------+-------------+-----------+------- (0 rows)
Check the existing category, for this example, the category code is 0X0
select * from inv_category where pkid = 0; pkid | category_code | name | description | status | lastupdate | userid_edit | parent_id | level ------+---------------+------+-------------+--------+-------------------------+-------------+-----------+------- 0 | 0X0 | | | active | 2012-04-27 17:23:45.236 | 504 | -1 | 0 (1 row)
Update the categoryid for the item and double check if the item was correctly updated.
Private & Confidential