forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: infotainer on March 28, 2006, 01:16:39 am

Title: cpg143_hit_stats not found after server crash
Post by: infotainer on March 28, 2006, 01:16:39 am
Hello

After my server crashes all users expect "administrators" get the following errors.
Can I recover this file, or copy it from a extisting backup ? 

Thank you for your help. Coppermine is a great tool.

greets from Switzerland
Hans
---------------------------------------------------------------------------------------------------------------error msg start

While executing query "INSERT INTO cpg143_hit_stats
                          SET
                            pid = 938,
                            search_phrase = '',
                            Ip   = '62.202.1.104',
                            sdate = '1143500356',
                            referer='',
                            browser = 'Firefox',
                            os = 'Windows XP'" on 0

mySQL error: Can't open file: 'cpg143_hit_stats.MYI' (errno: 144)

---------------------------------------------------------------------------------------------------------------error msg end

In the "Notices"- section of the debug-screen I can read :

------------------------------------------------------------------------------------------------------------- start text
include/functions.inc.php

    * Notice line 88: Undefined variable: cpg_show_private_album
    * Notice line 2786: Undefined index: HTTP_REFERER
    * Notice line 2786: Undefined index: HTTP_REFERER
    * Notice line 2786: Undefined index: HTTP_REFERER
    * Notice line 1491: Undefined variable: query_term
    * Notice line 1493: Undefined index: HTTP_REFERER

/include/themes.inc.php

    * Notice line 2171: Undefined index: uid
    * Notice line 2247: Undefined variable: ecard_tgt
    * Notice line 2248: Undefined variable: ecard_title
    * Notice line 2255: Undefined variable: report_tgt

------------------------------------------------------------------------------------------------------------- end text
Title: Re: cpg143_hit_stats not found after server crash
Post by: Joachim Müller on March 28, 2006, 07:31:38 am
http://forum.coppermine-gallery.net/index.php?topic=10409.0