I have been using Mango for several months with no serious problems; until now.
I attempted to update a user's password, and received the following error message when I clicked on the save icon:
PreparedStatementCallback; SQL [update users set username=?, password=?, email=?, phone=?, admin=?, disabled=?, homeUrl=?, receiveAlarmEmails=?, receiveOwnAuditEvents=? where id=?]; An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'null'.; nested exception is java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'null'.
After that I went to the "Watch list" page, and immediately receive this error:
getElement(mango.share.users, data.userId) is null
Consequently, I cannot share the watch list with other users because no users are shown; not even admin.
If I attempt to edit a "Graphical view" I also receive the null error message because the share menu is displayed on the "Graphical view" edit page.
I can create new users without seeing this message, and edit the settings for existing users. However, I cannot save any of the changes as the Callback error is displayed instead. I restarted Tomcat in the hopes that it would fix the problem, but it made no difference.
To summarize: I can't edit users, and I can't share views.
Any help is appreciated. I don't know where to turn from here short of a database restore, which would cause me to lose the all the new configuration work and data points since the last backup / version update.