Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • board down b ut fixed now... tiki_pages corrupted

    Posted by marvo

    If anyone can help I'd be more than grateful.

    I was editing a page in the wiki. Nothing fancy, just text. I previewed and it was cool so I pressed save page and the database seemed to go haywire. I got this error


    Notice: Undefined variable: ADODB_LASTDB in /home/username/public_html/bcwiki/lib/tikidblib.php on line 134

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

    select `pageName`, `user`, `lastModif` from `tiki_pages` where `lastModif`>? order by `lastModif` desc


    in /home/username/public_html/bcwiki/lib/tikidblib.php on line 134

    also the only thing the wiki will show right now is:

    An error occured in a database query!

    Context:
    File /index.php
    Url /
    Query:
    select `pageName`, `user`, `lastModif` from `tiki_pages` where `lastModif`>? order by `lastModif` desc
    Values:
    0 1144134873

    I have done nothing to the database in the last month, let alone last 24 hours. I have over 300 members staring at this error and I have no idea what to do next.

    Thanks for helping

    Reads: 781
    Posted by marvo
    further to this, lookinng through the MySQL database for the wiki, I notice I have overheads on some tables. Are these connected with the problem?

    Posted by marvo

    Got the lowdown from THISQuestion thread.

    Turns out it was a corrupt tiki_pages table

    Using PHPMyAdmin I selected it and then chose "repair" from the dropdown at the bottom of the page. Worked like a charm.