SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict itsource's Avatar
    Join Date
    Jun 2001
    Location
    Thailand
    Posts
    369
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL error : Got error 127 from table handler

    I just insert new record in mysql, Before add I query view old recode, it work but when insert new record and

    select * from tablename

    I have error message, I try to read manual but not found

    SELECT * FROM staff_profile
    MySQL said: Got error 127 from table handler

    Can any body help please?

  2. #2
    SitePoint Addict itsource's Avatar
    Join Date
    Jun 2001
    Location
    Thailand
    Posts
    369
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hey all, I have good news.
    I can solve my problem.

    My sql has command
    check table and repair table

    If your table has problem and error when you query in database, chcek table will check table and report error and repair table can fix it.

    for my problem i insert some rows that cause table error and repair command can remove those row already

    see more information about check and repair table at this
    http://www.mysql.com/documentation/m...le_maintenance


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
  •