Advanced search  

News:

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.
[more]

Pages: [1]   Go Down

Author Topic: Critical Error - while doing a batch upload  (Read 3771 times)

0 Members and 1 Guest are viewing this topic.

Bry5012

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Critical Error - while doing a batch upload
« on: April 27, 2009, 03:14:30 am »

i searched a little for this and could not find anything that answered my question...so I am posting here.

I was doing a batch upload from my FTP to the gallery and ended up getting this critical error:

"While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_53a6_1.MYI'; try to repair it"




what do I need to do to fix this and not lose any info from the gallery?
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: Critical Error - while doing a batch upload
« Reply #1 on: April 27, 2009, 04:12:33 am »

Try to repare the table usgin phpMyAdmin as the error suggested.
Logged
Read Docs and Search the Forum before posting. - Soporte en espaņol
--*--
Fabricio Ferrero's Website

Catching up! :)

Bry5012

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical Error - while doing a batch upload
« Reply #2 on: April 27, 2009, 05:15:41 am »

umm....I honestly don't know how to do that, is there someone that could assist me, please....
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Critical Error - while doing a batch upload
« Reply #3 on: April 27, 2009, 07:25:26 am »

Ask the hosting company where your site is hosted.
Logged

Bry5012

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical Error - while doing a batch upload
« Reply #4 on: April 27, 2009, 04:15:32 pm »

sorry to ask this....but why would I ask my hosting company if this is a Coppermine program issue?
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/
Re: Critical Error - while doing a batch upload
« Reply #5 on: April 27, 2009, 04:28:52 pm »

Do as suggested please. It's due to a DB problem, so it's not a CPG issue but a Hosting one.
Logged
Read Docs and Search the Forum before posting. - Soporte en espaņol
--*--
Fabricio Ferrero's Website

Catching up! :)

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Critical Error - while doing a batch upload
« Reply #6 on: April 27, 2009, 04:45:10 pm »

As Fabri already explains this concerns a mysql error.. not a coppermine error.

Quote
"mySQL error: Incorrect key file for table '/tmp/#sql_53a6_1.MYI'; try to repair it"

Hence you have to either repair it yourself using phpmyadmin or have your host do it.

Cheers
Hein
Logged

Bry5012

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critical Error - while doing a batch upload
« Reply #7 on: April 27, 2009, 04:51:21 pm »

ok...thank you.
Logged

Nibbler

  • Guest
Re: Critical Error - while doing a batch upload
« Reply #8 on: April 27, 2009, 06:09:31 pm »

You can't repair it yourself since it's a temporary table. Best you can do is disable the random files block in config.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.