after Upgrade from 4.0.16 to 5.0.7 :: no FAQ content

[sgw]

ran update from 4.0.16 to 5.0.7 successfully.
had to install/upgrade FAQ package manually after that, now I see FAQ categories, but no actual FAQ content.

What is recommended? Re-import FAQ tables into DB from pre-upgrade mysql dump?
thanks.

[sgw]

some help on this, someone? thanks ...

[reneeb]

Any messages in the webserver or OTRS log?

[sgw]

I could have looked that up earlier, sorry

Yes, there is something:

[Wed Feb 24 09:24:48 2016] -e: DBD::mysql::st execute failed: Unknown column 'i.content_type' in 'field list' at /opt/otrs/Kernel/System/DB.pm line 666.
ERROR: OTRS-CGI-10 Perl: 5.20.3 OS: linux Time: Wed Feb 24 09:24:48 2016

Message: Unknown column 'i.content_type' in 'field list', SQL: '
SELECT i.f_name, i.f_language_id, i.f_subject, i.created, i.created_by, i.changed,
i.changed_by, i.category_id, i.state_id, c.name, s.name, l.name, i.f_keywords,
i.approved, i.valid_id, i.content_type, i.f_number, st.id, st.name
FROM faq_item i, faq_category c, faq_state s, faq_state_type st, faq_language l
WHERE i.state_id = s.id
AND s.type_id = st.id
AND i.category_id = c.id
AND i.f_language_id = l.id
AND i.id = ? LIMIT 1'

RemoteAddress: 172.32.99.12
RequestURI: /otrs/index.pl?Action=AgentFAQExplorer

Traceback (17556):
Module: Kernel::System::FAQ::FAQGet Line: 235
Module: Kernel::Output::HTML::Layout::FAQ::FAQShowTop10 Line: 1044
Module: Kernel::Modules::AgentFAQExplorer::Run Line: 374
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1042
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 40
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry::handler (v1.99) Line: 32

I assume there are some FAQ-tables that have to be updated as well?

Aren't they touched by the main DB-migration script?

thanks

EDIT:

did this within mysql:

ALTER TABLE `faq_item` ADD `content_type` VARCHAR(250) NOT NULL DEFAULT 'text/html' AFTER `changed_by`

now the items display again. Nice.

Although there might be something else still missing, we will see.