More on my database issue.

Greetings Everyone I decided to disable Selinux. Thats really not a good way to go, but I'm still learning about it and I don't know enough about selinux yet top ensure that its not the problem. I am seeing a very specific error now. It happens when I try to go to the Changes Overview page. The web server reports an INternal Server Error, and the log file shows this: [Mon Sep 26 12:02:46 2016] -e: DBD::mysql::st execute failed: Table 'otrs.change_item' doesn't exist at /opt/otrs//Kernel/System/DB.pm line 666. ERROR: OTRS-CGI-12 Perl: 5.16.3 OS: linux Time: Mon Sep 26 12:02:46 2016 Message: Table 'otrs.change_item' doesn't exist, SQL: 'SELECT COUNT(c.id) FROM change_item c WHERE ( c.change_state_id IN (43) ) ' RemoteAddress: 10.50.104.80 RequestURI: /otrs/index.pl?Action=AgentITSMChange Traceback (2719): Module: Kernel::System::ITSMChange::ChangeSearch Line: 2224 Module: Kernel::Modules::AgentITSMChange::Run Line: 185 Module: Kernel::System::Web::InterfaceAgent::Run Line: 1053 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 [Mon Sep 26 12:02:46.694578 2016] [:error] [pid 2719] Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/Modules/AgentITSMChange.pm line 215.\n Any ideas? I will keep looking. -- Thanks, James “Zeke” Dehnert Enphase Energy | Senior Linux Administrator [http://dehnert.users.sonic.net/images/Enphase-sig.jpeg] (707)763.4787 x7636 // Office GPG Fingerprint: E899 A10A 960D 4B6C 22D2 8FC2 EA5E4E81 The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message!
participants (1)
-
James P Dehnert Sr