Horde: Removing email error SQLSTATE HY0001 General error 1267

Error when removing an email in horde:

SQLSTATE HY0001 General error 1267

Install Roundcube in plesk. Switch the webmail to roundcube. Remove Horde. Reinstall. Then switch back to Horde. The installer should install the correct tables.