Cannot see attachment after upgrade to OTRS 5

[akis]

Hi,

After upgrade from 3.3.14 -> 4.0.16 -> 5.0.9 I cannot see any attachments.

I have also wired error messages in the log:
error OTRS-CGI-66 No State for open found!
error OTRS-CGI-66 Unknown column 'disposition' in 'field list', SQL: '

Someone have an idea to help me?

[akis]

I also see this error in the Apache error log /var/log/apache2/error.log

DBD::mysql::st execute failed: Unknown column 'disposition' in 'field list' at /opt/otrs//Kernel/System/DB.pm line 666.
ERROR: OTRS-CGI-66 Perl: 5.14.2 OS: linux Time: Thu Apr 7 10:40:56 2016

Message: Unknown column 'disposition' in 'field list', SQL: '
SELECT filename, content_type, content_size, content_id, content_alternative,
disposition
FROM article_attachment
WHERE article_id = ?
ORDER BY filename, id'

[reneeb]

Did you run all the Update-to-x.pl and *.sql scripts during the upgrade process? That column was added in March 2014

[akis]

May I forgott scripts/DBUpdate-to-4........
Any ideas who I can fix this?

[akis]

I solved the problem

Something went wrong with the DBUpdate-to-4.mysql.sql script

I added manually following to commands or tables to my mysql database:
ALTER TABLE web_upload_cache ADD disposition VARCHAR (15) NULL;
ALTER TABLE article_attachment ADD disposition VARCHAR (15) NULL;

After this two additional tables the attachment is again available.

[jojo]

you should revert to your 3.3 database and run the migration again. there might be still other issues...

[akis]

do you know how I can revert my database to 3.3?

[jojo]

restore your backup

[akis]

The problem is that our OTRS system is already online and few new tickets are created. Other ideas?

[jojo]

thats the only clean solution...

[Charmacas]

The problem is that our OTRS system is already online and few new tickets are created. Other ideas?

You always should have a test system or at least a backup. And you should revert as fast as possible because if more problems occur the difference of data will become bigger.

[akis]

I checked the .sql script and all tables and Foreign Key are in the database.
I also checked the apache, OTRS and mysql log. The system runs actually without any error.