Announcement

Collapse
No announcement yet.

Database Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • George L
    replied
    Originally posted by Sinko
    This is what I get:

    post Check Warning: Table is marked as crashed and last repair failed
    post Check Error: Found 126 keys of 72167
    do the following in this order

    1. close forum via admincp off switch
    2. if you have ssh telnet access type the following

    mysqlcheck -s -u mysqlusername -p vbdatabasename

    this reports which mysql tables have errors (ignore any messages to do with session table)

    now to repair

    mysqlcheck -r -q -u mysqlusername -p vbdatabasename

    reason why is vB's internal mysql repair options can no repair all mysql corruptions like mysqlcheck can

    mysqlcheck is available from mysql 3.23.38 onwards

    Leave a comment:


  • Zachery
    replied
    This is sounding like a host issue, you should try contacting your host.

    Leave a comment:


  • Sinko
    replied
    And... this is the error I get when I enter the SQL you told me to enter in earlier.

    Can't create new tempfile: '/var/lib/mysql/maddenna_forums/post.TMD'

    Leave a comment:


  • Sinko
    replied
    And if that doesn't work?

    Leave a comment:


  • Zachery
    replied
    Keep trying untill its repaired

    Leave a comment:


  • Sinko
    replied
    This is what I get:

    post Check Warning: Table is marked as crashed and last repair failed
    post Check Error: Found 126 keys of 72167

    Leave a comment:


  • Zachery
    replied
    If you can login to your adminCP.

    AdminCP > Import & Maitence > Repair / Optmize Tables > Select all and hit continue, you made need to do this more than once.

    If you cannot access the AdminCP from phpmyAdmin you can run this

    REPAIR TABLE post;

    Leave a comment:


  • Sinko
    started a topic Database Error

    Database Error

    Hey guys, I got this error today:

    Database error in vBulletin 3.0.0:
    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM post
    WHERE dateline >= 1082876400

    mysql error: Can't open file: 'post.MYI'. (errno: 144)
    mysql error number: 1016
    Date: Sunday 25th of April 2004 01:01:18 PM
    Script: http://www.maddennation.com/forums/
    Referer:
    Username: CraigM
    IP Address: 68.204.249.154

    I tried to repair it but I can't. Any suggestions? Thanks!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X