Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Strange Error

    Posted by sakura92983

    I have a website that is using an older version of tikiwiki. It has not been updated in a while, but I want to keep it going in case I decide to revive it. I tried visiting it the other day and received the following error:

    An error occured in a database query!

    Context:
    File tiki-index.php
    Url tiki-index.php
    Query:
    select count(*) from `tiki_stats` where `object`=? and `type`=? and `day`=?
    Values:
    0 J-Music Ignited
    1 wiki
    2 1243742400
    Message:
    Error Message


    I'm not sure what triggered this or how it can be fixed. Any help would be appreciated.

    Reads: 2281
    Posted by Gary Cunningham-Lee

    Many times these database errors are caused by a mismatch between the query sent by the Tiki files and the structure of the database that receives the query. So the fix is to run the database upgrade script to make sure the database is up to date with the files of that version (and also to make sure the files are complete). Other people might have more suggestions, but this is what I'd try first.

    It might be worth upgrading the site to at least the last Tiki 2 release (list of releasesQuestion), which might take care of the problem and also fix some security vulnerabilities. For Tiki 3, there are template file changes that will mean more upgrading work for sites with custom themes, which is worth it IMHO, for the jquery and other goodies.

    -- Gary


    Posted by sakura92983

    I tried updating the database and the site to tiki 2, but the problem is still there. I can't access any of the pages that I created. I can only access admin and such on my menu. I decided to also check the mysql database on the server and it came up with 3 warnings:

    jmignite_tiki.tiki_pageviews
    warning : 12 clients are using or haven't closed the table properly
    status : OK

    jmignite_tiki.tiki_searchindex
    warning : Table is marked as crashed
    warning : 1 client is using or hasn't closed the table properly
    warning : Found 13100 deleted space in delete link chain. Should be -12048
    error : Found 264 deleted rows in delete link chain. Should be 4294967194
    error : record delete-link-chain corrupted
    error : Corrupt

    jmignite_tiki.tiki_stats
    error : File './jmignite_tiki/tiki_stats.MYD' not found (Errcode: 2)


    When I clicked repair, it fixed everything except the following:
    jmignite_tiki.tiki_searchindex
    warning : Number of rows changed from 353065 to 352723
    status : OK

    jmignite_tiki.tiki_stats
    error : File './jmignite_tiki/tiki_stats.MYD' not found (Errcode: 2)

    Could this possibly be causing the errors on my site and how can I fix this?