Gallery problems

[mickw]

Can't upload to the Gallery.  Goes through the motions and on the final "continue" get critical error message

[Rick]

Erf. Exact text of message would be helpful. I'll have a look.

[Rick]

Usual problems are caused by size and format, so knowing what sort of file you're uploading, and its size (both the actual file size and the dimensions of the image) will also help.

[mickw]

Doh, just read the "how big can files be"

Smaller was the answer 

[Rick]

As a matter of interest, how big was the one you were trying to upload?

[mickw]

4538 x 3308 @ 6.4 meg

[Rick]

4538 x 3308 @ 6.4 meg

...which is about 15 mega pixels, and the software has to expand the image to make the thumbnails...

I'll have to see whether we can let the server use more memory...

[mickw]

Or me resample the image to something less weighty

[mickw]

Failed again.
Got
Successful Uploads
1 uploads were successful.

Please click 'Continue' to add the files to albums.
It just went to blank white screen - url - http://gallery.orpington-astronomy.org.uk/upload.php - which was the same as the previous page

File was jpeg 3000x2368 3.73mb

[Rick]

Hmmm... Sounds like a time-out, perhaps.

Any chance you could email me the problem file so that I can test things, please?

[Rick]

I've flipped the image handling package. I think it may work now (as it worked when I tried...) Please try again.

[JohnP]

Mick - why you trying to upload such massive files - can't you resize to something reasonable like 1024X768 or so..

[mickw]

First try I got this -

Critical error
There was an error while processing a database query

Tried again and it worked fine.

Cheers Rick

[mickw]

can't you resize to something reasonable like 1024X768 or so

I could, but that wouldn't keep breaking the Gallery 

I thought the biggest possible was the thing to do 

[Rick]

Ugh. Sounds like some combination of memory and timing might be the problem, then. Glad it worked this time.

[Carole]

Gallery is uploading the file OK, but when I put information in I get the following message:

There was an error while processing a database query

[Rick]

This is during the upload process (the second part of the upload), or when subsequently trying to modify the information you entered previously?

Information that usually helps:

What size (both X and Y dimensions and size in Kbytes) and format is your image?
What date and time did you get the error?
The exact text of the error message.

I've tried an upload of a small (640x480 140Kb) JPG image, and it worked fine.

[Carole]

Hi Rick,

I tried to upload (3 times) just before my NA Nebula post on the Forum, to give you an idea of time.
2.15Mb Jpeg.

It said that the file had uploaded successfully, and then went to the info page.  Once I had entered the info it said

There was an error while processing a database query  

as previously quoted.

Just looked at the size in Photoshop, is a bit large 42.9 inches wide and 28.56 inches high, but would have though it would just shrink it, or fail at the first hurdle.  Just says

The size of files uploaded from your client to the server should not exceed 30000 KB

on the gallery. 

Carole

[Rick]

Just looked at the size in Photoshop, is a bit large 42.9 inches wide and 28.56 inches high, but would have though it would just shrink it, or fail at the first hurdle.  Just says

The size of files uploaded from your client to the server should not exceed 30000 KB

on the gallery. 

The helpful figures are the X and Y dimensions in pixels (not inches, centimetres, furlongs, microns, light years, ...). Multiply one by the other, then multiply that by the image depth in bytes (usually by 1 for greyscale, and 4 for colour (yes, I know 3 makes more sense, but the software usually decides 4 makes more sense)). If that result exceeds 30000 then your image is Too Big.

Jbut would have though it would just shrink it, or fail at the first hurdle.

The gallery doesn't know how big the uncompressed image will be until it has had it uploaded, and tried to uncompress it, and it can't shrink it unless it can first uncompress it...

[Carole]

Yup, too big.
I was just going by file size which appeared to be OK.

Carole