Results 1 to 2 of 2

Thread: MySQL error 1194: Table 'leads' is marked as crashed and should be repaired

  1. #1
    panim.park is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    49

    Default MySQL error 1194: Table 'leads' is marked as crashed and should be repaired

    I got this error as below which shows up the Campaign Status page and there hasn't any Sub-panel such as Track url, leads, accounts, contacts and targets.
    And for Click-Thru number has only for Targets, no leads, no accounts anything.
    Anyone, any ideas?

    Error running count query for Campaign List: Query Failed SELECT count(*) c FROM leads where ( leads.campaign_id= '96ce0520-920a-7238-7382-4da874484fdd' AND leads.deleted=0) AND leads.deleted=0 )::MySQL error 1194: Table 'leads' is marked as crashed and should be repaired
    Attached Images Attached Images  

  2. #2
    kbrill's Avatar
    kbrill is offline SugarCRM PS Engineer
    Join Date
    Jul 2004
    Location
    St Louis, MO
    Posts
    3,183

    Default Re: MySQL error 1194: Table 'leads' is marked as crashed and should be repaired

    You need to repair or restore that table. This page describes the process for a repair. I would start with a

    REPAIR TABLE leads;

    but if that leaves you with the problem still then go here and follow this.

    http://www.techrepublic.com/article/...tables/5193721

    good luck
    Kenneth Brill - Help Forum Moderator

    I do not respond to 'Private Messages'. Please email me directly instead

    When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
    Help us Help You

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 2011-04-29, 08:21 AM
  2. Replies: 0
    Last Post: 2010-02-04, 10:40 PM
  3. Table is crashed and last repair failed
    By samjoseph74 in forum Help
    Replies: 2
    Last Post: 2009-06-15, 04:31 AM
  4. MySQL error 1194
    By PavelK in forum Help
    Replies: 3
    Last Post: 2008-07-08, 08:31 AM
  5. Replies: 2
    Last Post: 2007-11-16, 04:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •