Believe the error. Fix the MySQL table. (Google the error.)
On Thu, Feb 21, 2013 at 10:11 AM, Gadow, Shawn <[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**** > > 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 (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 (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 (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]] *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]> 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]] *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]> 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
