cron.myi error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Watson
    Senior Member
    • May 2004
    • 281

    cron.myi error

    Ello all, my site seems to be up and running ok, but I am getting thousands of emails saying the following

    Code:
    [FONT=Consolas][SIZE=3]Database error in vBulletin 3.6.5:[/SIZE][/FONT]
    [FONT=Consolas][/FONT]
    [FONT=Consolas][SIZE=3]Invalid SQL:[/SIZE][/FONT]
    [FONT=Consolas][/FONT]
    [SIZE=3][FONT=Consolas]                  SELECT cron.*[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                  FROM cron AS cron[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                  LEFT JOIN product AS product ON (cron.product = product.productid)[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                  WHERE cron.nextrun <= 1182975207 AND cron.active = 1[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                        AND (product.productid IS NULL OR product.active = 1)[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                  ORDER BY cron.nextrun[/FONT][/SIZE]
    [SIZE=3][FONT=Consolas]                  LIMIT 1;[/FONT][/SIZE]
    [FONT=Consolas][/FONT]
    [FONT=Consolas][SIZE=3]MySQL Error  : Can't open file: 'cron.MYI'. (errno: 145) Error Number : 1016[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Date         : Wednesday, June 27th 2007 @ 09:13:27 PM[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Script       : [/SIZE][/FONT][URL="http://www.bootleg.org.uk/forums/cron.php?&rand=744963"][FONT=Consolas][SIZE=3][COLOR=#0000ff]http://www.bootleg.org.uk/forums/cron.php?&rand=744963[/COLOR][/SIZE][/FONT][/URL]
    [FONT=Consolas][SIZE=3]Referrer     : [/SIZE][/FONT][URL="http://www.bootleg.org.uk/forums/forumdisplay.php?f=19"][FONT=Consolas][SIZE=3][COLOR=#0000ff]http://www.bootleg.org.uk/forums/forumdisplay.php?f=19[/COLOR][/SIZE][/FONT][/URL]
    [FONT=Consolas][SIZE=3]IP Address   : 91.168.84.152[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Username     : Unregistered[/SIZE][/FONT]
    [FONT=Consolas][SIZE=3]Classname    : vb_database[/SIZE][/FONT]
    Anyone able to advised?

    Regards

    Watson
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    Error code 145: Unknown error 145

    145 = Table was marked as crashed and should be repaired

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...