My apologies I accidently used the same subject as a previous poster. Good Afternoon I am runnng OTRS 1.3.2 on a fedora core 2 box. We recently ran out of hard drive space and our php database crashed. Now when I try to view certain pages I get the following error message: Software error: Got no ArticleID! at ../..//Kernel/Output/HTML/ArticleCheckPGP.pm line 32.For help, please send mail to the webmaster (webmaster@pc.com), giving this error message and the time and date of the error. The following appears in the system log: Mon Jun 20 13:56:36 2005 error OTRS-CGI-10 No article found for TicketID 65975! Mon Jun 20 13:56:04 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:54:03 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:52:01 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:51:34 2005 error OTRS-CGI-10 No article found for TicketID 65975! I searched for the tickets in phpmyadmin and i found the tickets but no information was caputred and when I try to view the tickets in articles there is nothing. I thought that by deleting the tickets out of the tickets queue the problem would be resolved but it still exists. I have spoken to the administrator of the box but he has no idea on how we can fix the problem. Any ideas? Thanks Rudi

Rat's, I've already done that but the same message comes up. Also it looks like more and more tickets are being affected: Priority Facility Message Mon Jun 20 14:24:41 2005 error OTRS-CGI-10 No article found for TicketID 65989! Mon Jun 20 14:24:36 2005 error OTRS-CGI-10 No article found for TicketID 65971! Mon Jun 20 14:24:28 2005 error OTRS-CGI-10 No article found for TicketID 66001! Mon Jun 20 14:24:03 2005 notice OTRS-PM3-10 Fetched 2 email(s) from scc@server. Mon Jun 20 14:24:03 2005 notice OTRS-PM3-10 New Ticket [2005062010002734] created (TicketID=66317, ArticleID=201954). Mon Jun 20 14:24:03 2005 notice OTRS-PM3-10 Sent agent 'NewTicket' notification to 'rkramer@domain. Mon Jun 20 14:24:03 2005 notice OTRS-PM3-10 Sent agent 'NewTicket' notification to 'shardy@domain. Mon Jun 20 14:24:03 2005 error OTRS-PM3-10 LoopProtection!!! Send no more emails to '"System Administrator" '! Max. count of 40 has been reached! Mon Jun 20 14:24:02 2005 notice OTRS-PM3-10 New Ticket [2005062010002725] created (TicketID=66316, ArticleID=201953). Mon Jun 20 14:24:02 2005 notice OTRS-PM3-10 Sent agent 'NewTicket' notification to 'rkramer@domain. Mon Jun 20 14:24:02 2005 notice OTRS-PM3-10 Sent agent 'NewTicket' notification to 'shardy@domain. Mon Jun 20 14:24:02 2005 error OTRS-PM3-10 LoopProtection!!! Send no more emails to '"System Administrator" '! Max. count of 40 has been reached! Mon Jun 20 14:23:53 2005 error OTRS-CGI-10 No article found for TicketID 65970! Mon Jun 20 14:23:01 2005 notice OTRS-PM3-10 Fetched 1 email(s) from sos@domain. Mon Jun 20 14:23:01 2005 notice OTRS-PM3-10 FollowUp Article to Ticket [2005062010002501] created (TicketID=66294, ArticleID=201952). Mon Jun 20 14:22:26 2005 error OTRS-CGI-10 No article found for TicketID 65999! Mon Jun 20 14:21:51 2005 error OTRS-CGI-10 No article found for TicketID 65970! Mon Jun 20 14:20:25 2005 error OTRS-CGI-10 No article found for TicketID 65999! ----- Original Message ----- From: "Graeme Brough" To: "User questions and discussions about OTRS.org" Sent: Monday, June 20, 2005 2:32 PM Subject: Re: [otrs] Got no ArticleID! at../..//Kernel/Output/HTML/ArticleCheckPGP.pm line Hi Rudi, I have experienced a similar issue. When this occurs, we simply remove the erroneous tickets from 'ticket' table in the SQL (OTRS) database and this resolves the issue 100% of the time. If this is not helping in your case, I can only assume that some corrupt tickets, without article ids, remain. HTH, Graeme Rudi Kramer wrote:

My apologies I accidently used the same subject as a previous poster.

Good Afternoon

I am runnng OTRS 1.3.2 on a fedora core 2 box.

We recently ran out of hard drive space and our php database crashed.

Now when I try to view certain pages I get the following error message:

Software error: Got no ArticleID! at ../..//Kernel/Output/HTML/ArticleCheckPGP.pm line 32.For help, please send mail to the webmaster (webmaster@pc.com), giving this error message and the time and date of the error.

The following appears in the system log:

Mon Jun 20 13:56:36 2005 error OTRS-CGI-10 No article found for TicketID 65975! Mon Jun 20 13:56:04 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:54:03 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:52:01 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:51:34 2005 error OTRS-CGI-10 No article found for TicketID 65975!

I searched for the tickets in phpmyadmin and i found the tickets but no information was caputred and when I try to view the tickets in articles there is nothing. I thought that by deleting the tickets out of the tickets queue the problem would be resolved but it still exists.

I have spoken to the administrator of the box but he has no idea on how we can fix the problem.

Any ideas?

Thanks Rudi

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/

Hi Richard, What I do is simply use the import external data function in Excel which is under the data menu. Import the csv files as is but specify that the delimiter is a semi colon instead of a comma. This does the job and it is better than modifying the code, well IMHO it is. Regards Mark "Imagination is more important than knowledge, the important thing is to not stop questioning." -- Albert Einstein

-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Richard Hamson Sent: 21 June 2005 00:28 To: otrs@otrs.org Subject: [otrs] Reporting / .csv files

Hello,

I am currently looking into setting up reports by exporting .csv file out of OTRS. Unfortunately the .csv files are coming out with ; instead of , between the columns of data thus Excel (in this case) is putting all of the information in one column.

Does anyone know where to amend the syntax so that , are used and not ;?

Regards

Richard

_________________________________________________________________ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

Hi, Where can I download a tarball of the 2.0 beta of OTRS? Thanks, Andreas

Good Morning Graeme Yours was the correct solution it seems as though all the email received during the time the database was giving problems were all corrupt, about 18 of them and after deleting all of these emails the problem was corrected. Rudi ----- Original Message ----- From: "Rudi Kramer" To: "User questions and discussions about OTRS.org" Sent: Monday, June 20, 2005 2:44 PM Subject: Re: [otrs] Got no ArticleID!at../..//Kernel/Output/HTML/ArticleCheckPGP.pm line

Rat's, I've already done that but the same message comes up. Also it looks like more and more tickets are being affected:

Priority Facility Message

----- Original Message ----- From: "Graeme Brough" To: "User questions and discussions about OTRS.org" Sent: Monday, June 20, 2005 2:32 PM Subject: Re: [otrs] Got no ArticleID! at../..//Kernel/Output/HTML/ArticleCheckPGP.pm line

Hi Rudi,

I have experienced a similar issue.

When this occurs, we simply remove the erroneous tickets from 'ticket' table in the SQL (OTRS) database and this resolves the issue 100% of the time.

If this is not helping in your case, I can only assume that some corrupt tickets, without article ids, remain.

HTH,

Graeme

Rudi Kramer wrote:

...

My apologies I accidently used the same subject as a previous poster.

Good Afternoon

I am runnng OTRS 1.3.2 on a fedora core 2 box.

We recently ran out of hard drive space and our php database crashed.

Now when I try to view certain pages I get the following error message:

Software error: Got no ArticleID! at ../..//Kernel/Output/HTML/ArticleCheckPGP.pm line 32.For help, please send mail to the webmaster (webmaster@pc.com), giving this error message and the time and date of the error.

The following appears in the system log:

Mon Jun 20 13:56:36 2005 error OTRS-CGI-10 No article found for TicketID 65975! Mon Jun 20 13:56:04 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:54:03 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:52:01 2005 error OTRS-CGI-10 No article found for TicketID 65988! Mon Jun 20 13:51:34 2005 error OTRS-CGI-10 No article found for TicketID 65975!

I searched for the tickets in phpmyadmin and i found the tickets but no information was caputred and when I try to view the tickets in articles there is nothing. I thought that by deleting the tickets out of the tickets queue the problem would be resolved but it still exists.

I have spoken to the administrator of the box but he has no idea on how we can fix the problem.

Any ideas?

Thanks Rudi

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/