Mail Server Error

[stephenb]

When i try to change the password for my incoming mail server, i always get this error:

DAO_Mail(4550):Out of range value adjusted for column 'enabled' at row 1

I have more than one incoming mail server and this error only shows up on this specific one. I'm using the latest stable build. Any ideas?

[Hildy]

That's a little odd, Stephen. I'd suggest checking (either through the mysql console or through phpmyadmin) the values on that record in the `pop3_account` table. (You can also change the password directly there.)

Let us know if there's something funky still going on,

[stephenb]

Well, we have 4 e-mail addresses that are routed to different groups on the helpdesk. The very first e-mail address we used has a 21 in the enabled column, which is the same as it's ID. The other 3 have a 1 in the enabled column with a different number in the ID column.

The 21 for the first e-mail address is probably the cause of my problems. I'm going to change it back to a 1 and see what happens.

[stephenb]

Nope, i'm still experiencing the same error. After i change the 21 to a 1, I still get the same error. It's actually giving me that error if i change any settings from mail servers 2-4. If i change the settings from the first e-mail server, it changes the number in the enabled column back to a 21 but it does not give me an error.

[mfogg]

The reason you were getting the "out of range" error was because of a bug where the pop3 account modification form was submitting the id of the record into the enabled field if you had the enabled checkbox checked. So when the record you are editing happens to exceed MySQL's tiny int allowable range it complains.

I've gone ahead and changed it so it always sends a 1 value when checked in the dev branch revision 732. The bug is actually pretty harmless though aside from that error message since any non zero value in the enabled field will still signal to the pop3 scheduled task that it is enabled.

For the record the bug created for this is at http://wgmdev.com/jira/browse/CHD-820

Thanks for letting us know about this.

[stephenb]

Sounds good. Thanks!