Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » Error: Can't open file: 'tiki_pages.MYI'
 
Thread actions
Print this page
  • Print all pages

    • Error: Can't open file: 'tiki_pages.MYI'

    Posted by katdillon posts: 4

    Does anyone know what this error means, and how to fix it?

    Warning: mysql error: Can't open file: 'tiki_pages.MYI'. (errno: 145) in query:
    select `pageName`,`lastModif`,`user` from `tiki_pages` order by `lastModif` desc
    in /home/awaken/public_html/underground/tikiwiki/lib/tikidblib.php on line 134

    An error occured in a database query!
    Context:
    File /underground/tikiwiki/tiki-index.php
    Url /underground/tikiwiki/tiki-index.php
    Query:
    select `pageName`,`lastModif`,`user` from `tiki_pages` order by `lastModif` desc
    Values:
    Message:
    Error Message Can't open file: 'tiki_pages.MYI'. (errno: 145)

    Nothing unusual was going on when the wiki broke. I was trying to edit a page to add a link. Wiki's been up and running for a long time.

    Thanks if you can help!
    Kat

    Reads: 884
    Posted by Maarten posts: 45 United Kingdom


    Basicaly, the index is corrupted. Try and fix using PHPMyAdmin and working with the table 'tiki_pages' or if that doesn't work you will have to go to a shell command line and run myisamchk --r tiki_pages.myi.

    > Does anyone know what this error means, and how to fix it?
    >
    > Warning: mysql error: Can't open file: 'tiki_pages.MYI'. (errno: 145) in query:
    > select `pageName`,`lastModif`,`user` from `tiki_pages` order by `lastModif` desc
    > in /home/awaken/public_html/underground/tikiwiki/lib/tikidblib.php on line 134
    >
    > An error occured in a database query!
    > Context:
    > File /underground/tikiwiki/tiki-index.php
    > Url /underground/tikiwiki/tiki-index.php
    > Query:
    > select `pageName`,`lastModif`,`user` from `tiki_pages` order by `lastModif` desc
    > Values:
    > Message:
    > Error Message Can't open file: 'tiki_pages.MYI'. (errno: 145)
    >
    > Nothing unusual was going on when the wiki broke. I was trying to edit a page to add a link. Wiki's been up and running for a long time.
    >
    > Thanks if you can help!
    > Kat

    Posted by katdillon posts: 4
    Thanks much! Seems to be fixed now.