Syntax error

Hilfe zu OTRS Problemen aller Art
Post Reply
farukotrs
Znuny newbie
Posts: 35
Joined: 13 Mar 2008, 18:33

Syntax error

Post by farukotrs »

vorerst sorry leute das ich das forum hier voll spam ...

ich habe eben otrs 2.4.7 installiert, und beim ersten blick hat es den anschein das es auch funktioniert.

nur ist mir aufgefallen das es ewig lange dauert (immer über 6 / 7 sekunden) wenn ich z.b. im admin interface paket verwaltung oder sonst was anklick
hier ist die "fehlermeldung" die internet explorer bringt:
manchmal kommt auch ein time out ... ?

Code: Select all

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Timestamp: Wed, 10 Feb 2010 12:13:19 UTC


Message: Syntax error
Line: 228
Char: 13
Code: 0
URI: http://otrsn.mci.edu/otrs/index.pl?Action=AdminSysConfig

syntax error ? obwohl das hier ausgegeben wird:

Code: Select all

otrs-neu:/usr/local/otrs# perl -cw bin/cgi-bin/index.pl
bin/cgi-bin/index.pl syntax OK
otrs-neu:/usr/local/otrs#

wo schauen ?

danke
OS: Debian STABLE
OTRS 2.4.7.
MYSQL 5
Apache2
Dennis
Znuny wizard
Posts: 310
Joined: 16 Dec 2005, 14:40
Location: Schömberg
Contact:

Syntax error

Post by Dennis »

Schau mal bitte ins OTRS Log, wenn das nicht aktiviert ist:

Framework -> Core::Log

Kannst einfach mal nach /tmp/otrs.log schreiben lassen, da sollte mehr über den Fehler stehen
Produktiv:
SuSE 11.2 - OTRS 2.4.7
farukotrs
Znuny newbie
Posts: 35
Joined: 13 Mar 2008, 18:33

Syntax error

Post by farukotrs »

im admin interface habe ich ein "system log" button

Code: Select all

[ System Log ]  
Zeit Priorität Einrichtung Nachricht 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:41:01 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:40:31 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:09 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:30:08 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:30:08 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:08 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:30:08 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:16 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need User or UserID! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need TicketNumber! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need User or UserID! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need TicketNumber! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need User or UserID! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 Need TicketNumber! 
Wed Feb 10 13:25:14 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:25:12 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:24 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:24:23 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:24:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:24:23 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:22:23 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:20:22 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:18:21 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 No article found for TicketID 19926! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:16:18 2010 error OTRS-CGI-10 No article found for TicketID 19925! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 No article found for TicketID 19927! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need QueueID! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need ArticleID! 
Wed Feb 10 13:14:17 2010 error OTRS-CGI-10 Need ArticleID! 
 
OS: Debian STABLE
OTRS 2.4.7.
MYSQL 5
Apache2
Dennis
Znuny wizard
Posts: 310
Joined: 16 Dec 2005, 14:40
Location: Schömberg
Contact:

Syntax error

Post by Dennis »

Hm das sind immer wieder die gleichen Tickets und die sollten eigentlich auch nicht für den Syntax Error verantwortlich sein.
Kamen vielleicht grad Mails rein während dem Update die dann zerhackt wurden?
Steht vielleicht noch was im Apache Error Log?

Wirklich komisch
Produktiv:
SuSE 11.2 - OTRS 2.4.7
farukotrs
Znuny newbie
Posts: 35
Joined: 13 Mar 2008, 18:33

Syntax error

Post by farukotrs »

hier ist was interessantes:

unter Support Assessment finde ich

Code: Select all

Table Collation (utf8) Your charset collation is set to Invalid charset collation for: article[latin1_swedish_ci], article_attachment[latin1_swedish_ci], article_flag[latin1_swedish_ci], article_plain[latin1_swedish_ci], article_sender_type[latin1_swedish_ci], article_type[latin1_swedish_ci], auto_response[latin1_swedish_ci], auto_response_type[latin1_swedish_ci], charset[latin1_swedish_ci], customer_preferences[latin1_swedish_ci], customer_user[latin1_swedish_ci], faq[latin1_swedish_ci], follow_up_possible[latin1_swedish_ci], generic_agent_jobs[latin1_swedish_ci], group_customer_user[latin1_swedish_ci], group_role[latin1_swedish_ci], group_user[latin1_swedish_ci], groups[latin1_swedish_ci], notifications[latin1_swedish_ci], object_link[latin1_swedish_ci], package_repository[latin1_swedish_ci], personal_queues[latin1_swedish_ci], pop3_account[latin1_swedish_ci], postmaster_filter[latin1_swedish_ci], process_id[latin1_swedish_ci], queue[latin1_swedish_ci], queue_auto_response[latin1_swedish_ci], queue_standard_response[latin1_swedish_ci], role_user[latin1_swedish_ci], roles[latin1_swedish_ci], salutation[latin1_swedish_ci], search_profile[latin1_swedish_ci], sessions[latin1_swedish_ci], signature[latin1_swedish_ci], standard_attachment[latin1_swedish_ci], standard_response[latin1_swedish_ci], standard_response_attachment[latin1_swedish_ci], system_address[latin1_swedish_ci], system_user[latin1_swedish_ci], theme[latin1_swedish_ci], ticket[latin1_swedish_ci], ticket_history[latin1_swedish_ci], ticket_history_type[latin1_swedish_ci], ticket_index[latin1_swedish_ci], ticket_link[latin1_swedish_ci], ticket_lock_index[latin1_swedish_ci], ticket_lock_type[latin1_swedish_ci], ticket_loop_protection[latin1_swedish_ci], ticket_priority[latin1_swedish_ci], ticket_state[latin1_swedish_ci], ticket_state_type[latin1_swedish_ci], time_accounting[latin1_swedish_ci], user_preferences[latin1_swedish_ci], valid[latin1_swedish_ci], web_upload_cache[latin1_swedish_ci], xml_storage[latin1_swedish_ci]. 
OS: Debian STABLE
OTRS 2.4.7.
MYSQL 5
Apache2
Dennis
Znuny wizard
Posts: 310
Joined: 16 Dec 2005, 14:40
Location: Schömberg
Contact:

Syntax error

Post by Dennis »

Dürfte aber auch nicht zu diesem Fehler führen. Hier stimmt halt der Charset/Collation nicht, kannst du den Fehler reproduzieren? Wann genau tritt er auf?
Produktiv:
SuSE 11.2 - OTRS 2.4.7
farukotrs
Znuny newbie
Posts: 35
Joined: 13 Mar 2008, 18:33

Syntax error

Post by farukotrs »

mir kommt vor nur wenn ich Paket Verwaltung anklicke dauerts weit länger.
Die links unter Sonstiges funtionieren, ohne längere Wartezeiten nur wenn ich dann wieder auf Paket Verwaltung klicke dauerts länger.

vielleicht neu installieren ...
OS: Debian STABLE
OTRS 2.4.7.
MYSQL 5
Apache2
Dennis
Znuny wizard
Posts: 310
Joined: 16 Dec 2005, 14:40
Location: Schömberg
Contact:

Syntax error

Post by Dennis »

Sicher, dass da keine Fehlermeldungen mit Paketen die nicht korrekt installiert sind angezeigt werden?
Produktiv:
SuSE 11.2 - OTRS 2.4.7
Post Reply