do you know where otrs\process_id exists on your filesystem? Can you find it? http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
basically, you use any method to get to a mysql interface and follow the above instructions. Use MySQL Workbench (free download) or the mysql command line. On Thu, Feb 21, 2013 at 10:36 AM, Gadow, Shawn <[email protected]> wrote: > 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]> wrote: > **** > > 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 >
--------------------------------------------------------------------- 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
