Unable to update email. Internal error occured

Hello Everyone,

I am new to osticket.

I just successfully install osticket 1.6 on win2k3 IIS6, mysql, and PHP.

When I try to setup email I am keep getting "Unable to update email. Internal error occured".

I searched Google and the forum but unable to find much info.

Any information will be greatly appreciated!

Thank you very much

I've got the exact same problem, anyone with a solution please help asap.

Anybody has solution to this?

If you have access to your mysql logs I would start the troubleshooting there. Maybe it can give you more information or at least a better clue/hint.

DB Error #1265

i have the same problem trying to create a new email address, i also receive an email with the next error:

DB Error #1265

Data truncated for column 'mail_protocol' at row 1

anyone know how to fix this?

I found the same error when trying to update the user.

It appears that if you do no have the "Delete fetched message(s)" box ticked the SQL it generates is not correct.

The column mail_delete is set as blank instead of a 0/1 which MySQL will not allow. For the moment I just make sure I have ticked that box.

Perhaps the developers could look into sorting this issue!

Note: Even if you have not enabled that section of the form it still effects the SQL.

Alex