table fo_mail_spam_filters is missing

[caillech]

I upgraded Feng Office from version 1.7.5 to 2.2.3.1.

When checking my email, I receive a message that 3 messages are received, but they don't show up. I checked the log.php and I see that the table fo_mail_spam_filters is missing. Is there a way to create this table so that my emails can arrive again?

[caillech]

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.

[franponce87]

Thanks for your feedback!
We are currently improving our upgrade script for the next version with this.

Best regards,
Francisco

[rickxx]

They did great with their new version of Feng Office, it's better that the older one.