3
« on: March 05, 2013, 10:17:25 am »
OK, after searching a while through the php upgrade scripts, I found the following SQL in public\upgrade\scripts\AsadoUpgradeScript.class.php:
CREATE TABLE IF NOT EXISTS `fo_mail_spam_filters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`text_type` enum('email_address','subject') COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci NOT NULL,
`spam_state` enum('no spam','spam') COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
Apparantly this SQL was never executed during the upgrade. I executed it manually and the table was created. I checked my emails again and everything works fine.
I hope this will help other people who experience the same problem.
This topic may be closed.