Invalid object name 'article_attachment' after migration to ArticleStorgaeFS

[RichH]

Hi,

A couple of months ago I migrated our OTRS system from ArticleStorageDB to ArticleStorageFS. The last step of the procedure called for deleting the Article_Attachment table. Everything seems to working fine, but my OTRS.log file is full of errors saying: 'Invalid object name 'article_attachment'.

I'm wondering if it was a mistake to delete the whole table instead of just deleting the data from the table. If so, would you please post the SQL statement to recreate the Article_Attachment table?

Thanks,
Rich

OTRS Version: 3.1.3
OS: Window Server 2008 R2 SP 1
Database: MS SQL Server 2008 R2
Perl Version: Strawberry Perl 5.12.3.0

[crythias]

Note that your version is so old that it's no longer supported.
https://github.com/OTRS/otrs/blob/rel-3 ... l.sql#L594