I understand all of that. And I have searched.. hence why I am posting here asking the question.
All of my searches come back to run myisamchk on the table one says to run it in var/lib/otrs/ problem is there is no lib folder in the var folder so I am kind of at a loss there. I don't know how to go about running that command and all of the results I have found don't appear to fit my folder structure. From: [email protected] [mailto:[email protected]] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 9:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues also, the otrs.log can't be written to because of permissions. so allow "everyone" to write to the file. The error messages tell you exactly what the problem is. If a table is crashed, repair the table. If you have no permissions, give them. On Thu, Feb 21, 2013 at 10:21 AM, Gerald Young <[email protected]<mailto:[email protected]>> wrote: Believe the error. Fix the MySQL table. (Google the error.) On Thu, Feb 21, 2013 at 10:11 AM, Gadow, Shawn <[email protected]<mailto:[email protected]>> wrote: When I attempt to run postmaster mailbox from command prompt I get the following.. Microsoft Windows [Version 6.0.6002] Copyright (c) 2006 Microsoft Corporation. All rights reserved. H:\>C:\PROGRA~2/OTRS/StrawberryPerl/perl/bin/perl.exe C:/PROGRA~2/OTRS/OTRS/bin/ otrs.PostMasterMailbox.pl<http://otrs.PostMasterMailbox.pl> DBD::mysql::st execute failed: Table '.\otrs\process_id' is marked as crashed an d should be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 618. >> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied << ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'SELECT process_name, process_id, process_host, process_create, process_ch ange FROM process_id WHERE process_name = ? LIMIT 1' Traceback (6556): Module: Kernel::System::PID::PIDGet (v1.28) Line: 184 Module: Kernel::System::PID::PIDCreate (v1.28) Line: 124 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.pl<http://otrs.PostMasterMailbox.pl> (v1.4) Line: 83 DBD::mysql::db do failed: Table '.\otrs\process_id' is marked as crashed and sho uld be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 478. >> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied << ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?' Traceback (6556): Module: Kernel::System::PID::PIDDelete (v1.28) Line: 226 Module: Kernel::System::PID::PIDCreate (v1.28) Line: 150 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.pl<http://otrs.PostMasterMailbox.pl> (v1.4) Line: 83 DBD::mysql::db do failed: Table '.\otrs\process_id' is marked as crashed and sho uld be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 478. >> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied << ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_c reate, process_change) VALUES (?, ?, ?, ?, ?)' Traceback (6556): Module: Kernel::System::PID::PIDCreate (v1.28) Line: 154 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.pl<http://otrs.PostMasterMailbox.pl> (v1.4) Line: 83 NOTICE: PostMasterMailbox.pl is already running (use '-f 1' if you want to start it forced)! From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:56 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues You may start here to find the answer as it's the path I'd take. https://www.google.com/search?q=site:forums.otterhub.org+windows+cron On Thu, Feb 21, 2013 at 9:32 AM, Gadow, Shawn <[email protected]<mailto:[email protected]>> wrote: I have restarted the box numerous times how do I manually start the cron job(s) and/or check them (on a windows box) From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:15 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues cron has stopped. On Thu, Feb 21, 2013 at 9:07 AM, Gadow, Shawn <[email protected]<mailto:[email protected]>> wrote: I have a couple of odd issues. That started on the 20th of last month approximately 1 E-mails just stopped fetching automatically all of the sudden.. I don't remember how that works or how I set that up.. but I can manually fetch.. 2. the 7 day stats graph stopped showing closed tickets. It is only showing created. Both of these things happened at the same time we are currently running 3.1.9 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
