Advanced search  


cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: getting an error on your gallery  (Read 4537 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 5
getting an error on your gallery
« 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
« Last Edit: March 10, 2006, 10:32:16 am by GauGau »

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: getting an error on your gallery
« Reply #1 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.
Chief Geek at Ranium Systems

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
Re: getting an error on your gallery
« Reply #2 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:
While executing query "INSERT INTO cpg140_hit_stats
                            pid = 68,
                            search_phrase = '',
                            Ip   = '',
                            sdate = '1141982565',
                            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)".

Thanks for your reports, issue solved.
Pages: [1]   Go Up

Page created in 0.042 seconds with 19 queries.