[dev] OTRS 4 Customer Password reset through customer preference issue
Hello All, i am trying the version 4 on CentOS 6.6. So far its everything working fine, but when any customer access to the customer portal and try to change the password the OTRS gives me an 500 Error Internal Server Error. This is the error on the log: [Mon Sep 21 23:34:58 2015] [error] [client 195.112.214.172] Can't locate object method "new" via package "Kernel::System::CustomerAuth" (perhaps you forgot to load "Kernel::System::CustomerAuth"?) at /opt/supportOTRS/bin/cgi-bin/../../Kernel/Output/HTML/PreferencesPassword.pm line 105., referer: https://support.i2cinc.com/otrs/customer.pl?Action=CustomerPreferences [Mon Sep 21 23:34:58 2015] [error] [client 195.112.214.172] Premature end of script headers: customer.pl, referer: https://support.i2cinc.com/otrs/customer.pl?Action=CustomerPreferences [Mon Sep 21 23:35:03 2015] [error] [client 195.112.214.172] Can't locate object method "new" via package "Kernel::System::CustomerAuth" (perhaps you forgot to load "Kernel::System::CustomerAuth"?) at /opt/supportOTRS/bin/cgi-bin/../../Kernel/Output/HTML/PreferencesPassword.pm line 105., referer: https://support.i2cinc.com/otrs/customer.pl?Action=CustomerPreferences [Mon Sep 21 23:35:03 2015] [error] [client 195.112.214.172] Premature end of script headers: customer.pl, referer: https://support.i2cinc.com/otrs/customer.pl?Action=CustomerPreferences [Mon Sep 21 23:35:05 2015] [error] [client 195.112.214.172] File does not exist: /opt/supportOTRS/var/httpd/htdocs/skins/Customer/default/img/login2.jpg, referer: https://support.i2cinc.com/otrs/customer.pl?Action=CustomerPreferences Error Message: Please help me to fix this problem Regards Ali Umair ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Re: [dev] [OTRS] JavaScriptError: Cannot call method 'Init' of undefined
Browser version is Firefox 13.0.1 On 4/8/2015 12:09 PM, Moritz Lenz wrote: On 04/08/2015 07:57 AM, Ali Umair wrote: Hi, - Browser *(Client Browser firfox and chrome)* - OS *(Client browser linx and OTRS running on Linux)* - OTRS Version *(3.0.6)* - What Host (Linux, Win) *Host is linux* - Webserver *(Apache)* - Is anything in the logs (apache / nginx error log) and OTRS Log that maybe related to you action - when does the error occur? * When i hit on Login page Too Old browser message displayed Maybe the problem is actually what the error message says? Your browsers are too old? You didn't include the browser versions. Cheers, Moritz and on alert bo javascript message displayed of *TypeError: Cannot call method 'Init' of undefined* in common JS file In error log:* [Sat Mar 28 23:44:11 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/skins/Agent/default/css-cache/CommonCSS_f0d8130800dc2d7b6a226b692b4a8776.css, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:13 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:22 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl *In access log i get following msgs:* ; - - [29/Mar/2015:03:57:26 -0700] GET /otrs/index.pl HTTP/1.1 200 10732 - Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ;2 - - [29/Mar/2015:03:57:27 -0700] GET / 200 275 - - ; - - [29/Mar/2015:03:57:27 -0700] GET /otrs-web/js/js-cache/ModuleJS_262e1655ed48a1645e7d6aaa7eab7cd8.js HTTP/1.1 200 680 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:27 -0700] GET /otrs-web/js/js-cache/CommonJS_bb6e60a0b78bf3e1bd894440b20a34a8.js HTTP/1.1 200 300568 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_d2cb2cb04e61217e3345baf51d998492.css HTTP/1.1 404 283 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/skins/Agent/default/css/thirdparty/ui-theme/jquery-ui.css HTTP/1.1 200 30158 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/js/js-cache/CommonJS_dd46ed1a27280cd74ffde3b1f18acd58.js HTTP/1.1 404 263 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 On 4/8/2015 10:43 AM, Johannes Nickel wrote: Hey, to help you we need some more information like: - Browser - OS - OTRS Version - What Host (Linux, Win) - Webserver - Is anything in the logs (apache / nginx error log) and OTRS Log that maybe related to you action - when does the error occur? regards Johannes 2015-04-08 7:10 GMT+02:00 Ali Umair aum...@i2cinc.com mailto:aum...@i2cinc.com: Hi, I am facing same issue in OTRS. Can anyone please guide how i fix this issue?? Its humble request if someone help or guide me?? [ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 • c.t/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:168[ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37
Re: [dev] [OTRS] JavaScriptError: Cannot call method 'Init' of undefined
My otrs application run on single node fine, but when run otrs application on nodes two nodes for load balancing, after that i am getting this exception on login page. I try to execute script of deletecache, loadcache and rebuild config but error is still persist... Ali On 4/8/2015 12:34 PM, Renee B wrote: Did you upgrade your OTRS or is it the initial installation? On 08.04.2015 07:57, Ali Umair wrote: Hi, - Browser *(Client Browser firfox and chrome)* - OS *(Client browser linx and OTRS running on Linux)* - OTRS Version *(3.0.6)* - What Host (Linux, Win) *Host is linux* - Webserver *(Apache)* - Is anything in the logs (apache / nginx error log) and OTRS Log that maybe related to you action - when does the error occur? * When i hit on Login page Too Old browser message displayed and on alert bo javascript message displayed of *TypeError: Cannot call method 'Init' of undefined* in common JS file In error log:* [Sat Mar 28 23:44:11 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/skins/Agent/default/css-cache/CommonCSS_f0d8130800dc2d7b6a226b692b4a8776.css, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:13 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:22 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl -- -- *Best Regards* *Ali Umair * ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
[dev] [OTRS] JavaScriptError: Cannot call method 'Init' of undefined
Hi, I am facing same issue in OTRS. Can anyone please guide how i fix this issue?? Its humble request if someone help or guide me?? [ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 • c.t/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:168[ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 -- -- *Best Regards* *Ali Umair * ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Re: [dev] [OTRS] JavaScriptError: Cannot call method 'Init' of undefined
Hi, - Browser *(Client Browser firfox and chrome)* - OS *(Client browser linx and OTRS running on Linux)* - OTRS Version *(3.0.6)* - What Host (Linux, Win) *Host is linux* - Webserver *(Apache)* - Is anything in the logs (apache / nginx error log) and OTRS Log that maybe related to you action - when does the error occur? * When i hit on Login page Too Old browser message displayed and on alert bo javascript message displayed of *TypeError: Cannot call method 'Init' of undefined* in common JS file In error log:* [Sat Mar 28 23:44:11 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/skins/Agent/default/css-cache/CommonCSS_f0d8130800dc2d7b6a226b692b4a8776.css, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:13 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl?Action=AgentTicketSearch;Subaction=Search;Profile=last-search;SortBy=Age;OrderBy=Down;TakeLastSearch=1;StartHit=1;TicketID=161936 [Sat Mar 28 23:44:22 2015] [error] [;] File does not exist: /opt/iplOTRS/var/httpd/htdocs/js/js-cache/CommonJS_26da628935b53a24253a5f2450c56db2.js, referer: https://support.innovative-pk.com/otrs/index.pl *In access log i get following msgs:* ; - - [29/Mar/2015:03:57:26 -0700] GET /otrs/index.pl HTTP/1.1 200 10732 - Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ;2 - - [29/Mar/2015:03:57:27 -0700] GET / 200 275 - - ; - - [29/Mar/2015:03:57:27 -0700] GET /otrs-web/js/js-cache/ModuleJS_262e1655ed48a1645e7d6aaa7eab7cd8.js HTTP/1.1 200 680 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:27 -0700] GET /otrs-web/js/js-cache/CommonJS_bb6e60a0b78bf3e1bd894440b20a34a8.js HTTP/1.1 200 300568 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_d2cb2cb04e61217e3345baf51d998492.css HTTP/1.1 404 283 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/skins/Agent/default/css/thirdparty/ui-theme/jquery-ui.css HTTP/1.1 200 30158 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 ; - - [29/Mar/2015:03:57:40 -0700] GET /otrs-web/js/js-cache/CommonJS_dd46ed1a27280cd74ffde3b1f18acd58.js HTTP/1.1 404 263 https://support.innovative-pk.com/otrs/index.pl; Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0 On 4/8/2015 10:43 AM, Johannes Nickel wrote: Hey, to help you we need some more information like: - Browser - OS - OTRS Version - What Host (Linux, Win) - Webserver - Is anything in the logs (apache / nginx error log) and OTRS Log that maybe related to you action - when does the error occur? regards Johannes 2015-04-08 7:10 GMT+02:00 Ali Umair aum...@i2cinc.com mailto:aum...@i2cinc.com: Hi, I am facing same issue in OTRS. Can anyone please guide how i fix this issue?? Its humble request if someone help or guide me?? [ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 • c.t/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:168[ERROR] JavaScriptError: Cannot call method 'Init' of undefined • /otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212Uncaught TypeError: Cannot call method 'Init' of undefined • TargetNS.HandleFinalError/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:212 • (anonymous function)/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:546 • c.b.extend.ready/otrs-web/js/js-cache/CommonJS_164eff894a813f6591b6435b5c04d077.js:37 -- -- *Best Regards* *Ali Umair * ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http
Re: [dev] OTRS error in Log file
Dear Moritz, Thanks for your reply, Following query state is empty.. due to some dashboard configuration. but do you know this configuration is stored in which file? so that i can remove or i am able to fix this issue? SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913) AND st.until_time = 1427722133 LIMIT 1 On 3/30/2015 4:39 PM, Moritz Lenz wrote: Hi, On 30.03.2015 13:29, Ali Umair wrote: Team, I am continuously facing following exception in OTRS, and i am unable to track Anybody can suggest the root cause of this exception ? if no user access the OTRS application but still this exception is printing in error log continuously... [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] index.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id IN (99) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line 1 at /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553. [Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Sun Mar 29 17:29:53 2015 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id IN (99) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.queue_id IN (99) That's the problem here: the list of ticket states is empty, and the SQL syntax doesn't allow an empty list here. So, why is it empty? The dashboard does a search for tickets (or probably more than one search, but at least one is problematic), and selects by certain ticket states, but no ticket states match the search criteria. I don't know the dashboard well, but I guess there'll be a search by viewable states, so maybe somebody configured your OTRS to not contain any valid, viewable states? Cheers, Moritz AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913) AND st.until_time = 1427722133 LIMIT 1' [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Traceback (12647): [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853 [Sun Mar 29 17:29:53 2015] [error] Module: /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] index.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 82' at line 1 at /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553. [Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Sun Mar 29 17:29:53 2015 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 82' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913) AND st.until_time = 1427722133 LIMIT 1' [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Traceback (12647): [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853 [Sun Mar 29 17:29:53 2015] [error] Module: /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45 [Sun Mar 29 17:29:53 2015
[dev] OTRS error in Log file
Team, I am continuously facing following exception in OTRS, and i am unable to track Anybody can suggest the root cause of this exception ? if no user access the OTRS application but still this exception is printing in error log continuously... [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] index.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id IN (99) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line 1 at /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553. [Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Sun Mar 29 17:29:53 2015 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id IN (99) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.queue_id IN (99) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913) AND st.until_time = 1427722133 LIMIT 1' [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Traceback (12647): [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853 [Sun Mar 29 17:29:53 2015] [error] Module: /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] index.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 82' at line 1 at /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553. [Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Sun Mar 29 17:29:53 2015 [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 82' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913) AND st.until_time = 1427722133 LIMIT 1' [Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015] [error] Traceback (12647): [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307 [Sun Mar 29 17:29:53 2015] [error] Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853 [Sun Mar 29 17:29:53 2015] [error] Module: /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45 [Sun Mar 29 17:29:53 2015] [error] -- -- *Best Regards* *Ali Umair* ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
[dev] Please help me About filter out freeTextField
/Hi, Is it posible auto filling the contents of TicketFreeText2 dropdown from database depending /of/ value selected on TicketFreeText1 which foriegn key?, or develop something that filters /the/ TicketFreeText2 content depending of value selected on/ TicketFreeText1? -- *Best Regards* *Ali Umair | Software Engineer * *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN Ph: 0092-42-111 000 911 X 171 | Cell: +92-334-4556898 ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
[dev] Help me, and guide me
i want to update my OTRS, 2.2 to 3.0, but when i run script of 2.3 then in alter statements i found this error 0 66 12:04:13 ALTER TABLE queue_preferences ADD CONSTRAINT FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id) Error Code: 1005 Can't create table 'otrs.#sql-223f_49' (errno: 150) 0.031 sec i am working on mysql workbench and i install otrs on red hat linux, please guide me as soon as possible. Thanks -- -- *Best Regards* *Ali Umair | Software Engineer * *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN Ph: 0092-42-111 000 911 X 171 | Cell: +92-334-4556898 ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
[dev] Please help me
Hi, I am new in OTRS and want to upgrade 2.2 to 3.0. but i am confused what i take first step to ahead. I read only developer guide of OTRS. I know this is step by step up gradation like 2.2 to 2.3 and then 2.4 then 3.0. but suggest me in detail what step i follow. and if i customize (Add new column and remove some colum or concate some column) in the reports of OTRS then what files are changed and what should i take first step. kindly guide me about it. I really thankful to you !!! -- -- *Best Regards* *Ali Umair | Software Engineer * *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN ___ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev