[resolved] Failed Mail Sending Invitation and Mail Virus

Hello,

For a while, email inviations generate an error as well as virus detection mails.
Emails for notifications work well …

seahub_email_sender.log

`Warning: File comment has changed since version 6.3, while table `base_filecomment` is not migrated yet, please consider migrate it according to v6.3.0 release note, otherwise the file comment feature will not work correctly.`

but command already push
./seahub.sh python-env seahub/manage.py migrate_file_comment

./seahub.sh python-env seahub/manage.py migrate_file_comment

LC_ALL is not set in ENV, set to en_US.UTF-8

Warning: File comment has changed since version 6.3, while table `base_filecomment` is not migrated yet, please consider migrate it according to v6.3.0 release note, otherwise the file comment feature will not work correctly.

Start to update schema...
ALTER TABLE base_filecomment RENAME TO base_filecomment_backup_020985

CREATE TABLE `base_filecomment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) NOT NULL,
  `comment` longtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `uuid_id` char(32) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `base_filecomment_uuid_id_93ee16_fk_tags_fileuuidmap_uuid` (`uuid_id`),
  KEY `base_filecomment_author_a4d10b` (`author`),
  CONSTRAINT `base_filecomment_uuid_id_e447c4_fk_tags_fileuuidmap_uuid` FOREIGN KEY (`uuid_id`) REFERENCES `tags_fileuuidmap` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Start to migate comments data...
Done
Done.

and always in the pannel administration :

(1054, "Unknown column 'post_office_attachment.mimetype' in 'field list'")

Any idea ?

i am on seafile pro 6.3.6 same error with 6.3.5

ITS OK, i passed seahub.sql again, and its ok …

1 Like

Hi,sorry for the noise,I have manually resolved this issue by searching everywhere.After a deep reading at upgrade/6.3.0/seahub.sql file,I ran mysql command and altered the post_office_attachment table with add column function.Tested a shared link,goes back normal days.
LOL.