Error editing e-mail address

[craig]

the OS is windows 7. It does happen every time.

[mlohbihler]

Sorry, by "reproduceable", i meant not reproduceable in a development environment.

[craig]

on my local machine it is reproduceable if you would like me to test any patches

[mlohbihler]

Unfortunately, the UserDao class has undergone changes for multiple purposes, so i can't just send you a class file. But if you're feeling ambitious, you could modify the code by changing the updateUser method to that below. I have not tested this in 1.12.4, so ymmv.

    void updateUser(User user) {
        // Potential fix for "An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'null'"
        if (user.getPhone() == null)
            user.setPhone("");
        if (user.getHomeUrl() == null)
            user.setHomeUrl("");

        try {
            ejt.update(
                    USER_UPDATE,
                    new Object[] { user.getUsername(), user.getPassword(), user.getEmail(), user.getPhone(),
                            boolToChar(user.isAdmin()), boolToChar(user.isDisabled()), user.getHomeUrl(),
                            user.getReceiveAlarmEmails(), boolToChar(user.isReceiveOwnAuditEvents()),
                            user.getId() }, new int[] { Types.VARCHAR, Types.VARCHAR,
                            Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.INTEGER,
                            Types.VARCHAR, Types.INTEGER });
            saveRelationalData(user);
        }
        catch (DataIntegrityViolationException e) {
            // Log some information about the user object.
            LOG.error("Error updating user: " + user, e);
            throw e;
        }
    }

[craig]

that fixed it. thanks.

[mlohbihler]

Awesome. Thanks Craig.

[Victorino]

Can you make the updated library available for 1.12.4? I'm also having the same error when changing data point permissions on any users.

Actually I get the error when changing anything on a user.

[mlohbihler]

You should consider using Mango Automation. http://m2m2.serotoninsoftware.com/

[craig]

I have attached the patched UserDao classes off of an instance of 1.12.4.
Good Luck

@Victorino said:

Can you make the updated library available for 1.12.4?

Attachment: download link

[lordportux]

I had the same problem in mango 1.12.3 and I solved it using the Derby.jar file from mango 1.12.5