Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Tiki_pages Mysql error

    Posted by azwli

    Hello, I m getting an error when I try to edit a wiki page. It is this:


    Warning: mysql error: Incorrect key file for table 'tiki_pages'; try to repair it in query:

    update `tiki_pages` set `description`=?, `data`=?, `comment`=?, `lastModif`=?, `version`=?, `user`=?, `ip`=?, `page_size`=?, `is_html`=? where `pageName`=?

    in /home/commun/public_html/wiki/lib/tikidblib.php on line 134


    I edited 4 different pages, and then on the 5th and 6th, it started giving me this error. I have checked other pages and they all edit fine. I am not sure what makes those two pages different, they are longer, that is the only thing I see. Does anyone have any idea of what to do?

    Jason

    Reads: 611
    Posted by azwli

    Thank you for your reply, I am fairly new at this and I am not sure where to look for phpMyAdmin or for that matter how to repair the table 'tiki_pages'.

    A new problem has cropped up as well, Wiki pages can't be displayed. It gives me this error:

    • "Warning*: mysql error: Can't open file: 'tiki_pages.MYI' (errno: 145) in query:


    select `pageName` from `tiki_pages` where `pageName` = ?


    in */home/commun/public_html/wiki/lib/tikidblib.php* on line *134"

    In fact mamy pages I try to view give me a similar error.

    Thankyou for looking in to this.

    Jason


    Posted by Hades

    Hello,

    I would try at first to repair the table 'tiki_pages'. If it doesn't solve the proble, then I'd reindex it.

    You can do it through phpMyAdmin, the MySql administration utility. There are contextual icons/buttons to do it.

    Hope this helps

    Posted by azwli
      • Solved**


    I was able, in all of my ineptness, to figure out where the PHPMyAdmin tool was located and then fixing it was easy.

    Thanks for the help