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.
after Upgrade from 4.0.16 to 5.0.7 :: no FAQ content
Moderator: crythias
-
- Znuny newbie
- Posts: 32
- Joined: 22 Sep 2011, 16:39
- Znuny Version: 5.0.7
- Real Name: Stefan Weichinger
- Company: oops!
- Contact:
Re: after Upgrade from 4.0.16 to 5.0.7 :: no FAQ content
some help on this, someone? thanks ...
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: after Upgrade from 4.0.16 to 5.0.7 :: no FAQ content
Any messages in the webserver or OTRS log?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny newbie
- Posts: 32
- Joined: 22 Sep 2011, 16:39
- Znuny Version: 5.0.7
- Real Name: Stefan Weichinger
- Company: oops!
- Contact:
Re: after Upgrade from 4.0.16 to 5.0.7 :: no FAQ content
I could have looked that up earlier, sorry
Yes, there is something:
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.
Yes, there is something:
I assume there are some FAQ-tables that have to be updated as well?[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
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.