forum.coppermine-gallery.net

No Support => General discussion (no support!) => Topic started by: LadyAnna on March 10, 2006, 01:31:41 am

Title: getting an error on your gallery
Post by: LadyAnna on March 10, 2006, 01:31:41 am

I'm trying to view the larger image in: Themes > User-contributed themes
and all I get is this, for all tested (about everyone I think) " There was an error while processing a database query "

Dunno if its known to you or not, so I fgured I'd tell just in case you dont know already

Title: Re: getting an error on your gallery
Post by: Abbas Ali on March 10, 2006, 09:34:05 am

Confirming that this is happening on displayimage.php for all albums in the demo gallery....

@Joachim: Could you please look into it.

Title: Re: getting an error on your gallery
Post by: Joachim Müller on March 10, 2006, 10:32:06 am

I wasn't able to replicate in the first place - everything worked for me as expected both in IE and FF, both logged in as admin or as guest. Then I tried loging in as non-admin user and got the error message you reported, so I enabled debug_output. This showed that one of the tables had been broken:

Quote

While executing query "INSERT INTO cpg140_hit_stats
                          SET
                            pid = 68,
                            search_phrase = '',
                            Ip   = '84.172.100.74',
                            sdate = '1141982565',
                            referer='http://coppermine-gallery.net/demo/cpg14x/thumbnails.php?album=20',
                            browser = 'Microsoft Internet Explorer 6.0',
                            os = 'Windows 2000'" on 0

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

, so I went into phpMyAdmin and executed the query

Code: [Select]

repair table cpg140_hit_statsas suggested in the thread "Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145) (http://forum.coppermine-gallery.net/index.php?topic=10409.0)".

Thanks for your reports, issue solved.