Orpington Astronomical Society

Back Room => Updates and Upsets => Topic started by: mickw on Apr 15, 2011, 20:51:57

Title: Gallery problems
Post by: mickw on Apr 15, 2011, 20:51:57
Can't upload to the Gallery.  Goes through the motions and on the final "continue" get critical error message
Title: Re: Gallery problems
Post by: Rick on Apr 15, 2011, 23:58:52
Erf. Exact text of message would be helpful. I'll have a look.
Title: Re: Gallery problems
Post by: Rick on Apr 16, 2011, 00:11:19
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.
Title: Re: Gallery problems
Post by: mickw on Apr 16, 2011, 08:19:42
Doh, just read the "how big can files be"

Smaller was the answer  :oops:
Title: Re: Gallery problems
Post by: Rick on Apr 16, 2011, 09:34:53
As a matter of interest, how big was the one you were trying to upload?
Title: Re: Gallery problems
Post by: mickw on Apr 16, 2011, 09:48:44
4538 x 3308 @ 6.4 meg
Title: Re: Gallery problems
Post by: Rick on Apr 16, 2011, 12:39:46
Quote from: mickw on Apr 16, 2011, 09:48:44
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...
Title: Re: Gallery problems
Post by: mickw on Apr 16, 2011, 13:28:35
Or me resample the image to something less weighty
Title: Re: Gallery problems
Post by: mickw on Apr 19, 2011, 13:24:56
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
Title: Re: Gallery problems
Post by: Rick on Apr 19, 2011, 13:56:21
Hmmm... Sounds like a time-out, perhaps.

Any chance you could email me the problem file so that I can test things, please?
Title: Re: Gallery problems
Post by: Rick on Apr 19, 2011, 15:20:55
I've flipped the image handling package. I think it may work now (as it worked when I tried...) Please try again.
Title: Re: Gallery problems
Post by: JohnP on Apr 19, 2011, 16:35:37
Mick - why you trying to upload such massive files - can't you resize to something reasonable like 1024X768 or so..
Title: Re: Gallery problems
Post by: mickw on Apr 19, 2011, 16:37:32
First try I got this -

Critical error
There was an error while processing a database query

Tried again and it worked fine.

Cheers Rick
Title: Re: Gallery problems
Post by: mickw on Apr 19, 2011, 16:40:03
Quotecan't you resize to something reasonable like 1024X768 or so

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

I thought the biggest possible was the thing to do  :oops:
Title: Re: Gallery problems
Post by: Rick on Apr 19, 2011, 17:49:43
Ugh. Sounds like some combination of memory and timing might be the problem, then. Glad it worked this time.
Title: Re: Gallery problems
Post by: Carole on Jun 12, 2011, 11:58:49
Gallery is uploading the file OK, but when I put information in I get the following message:
QuoteThere was an error while processing a database query
Title: Re: Gallery problems
Post by: Rick on Jun 12, 2011, 15:11:10
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.
Title: Re: Gallery problems
Post by: Carole on Jun 12, 2011, 18:18:33
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
QuoteThere 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
QuoteThe size of files uploaded from your client to the server should not exceed 30000 KB
on the gallery. 

Carole
Title: Re: Gallery problems
Post by: Rick on Jun 12, 2011, 19:03:43
Quote from: Carole on Jun 12, 2011, 18:18:33Just 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
QuoteThe 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.

Quote from: Carole on Jun 12, 2011, 18:18:33Jbut 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...
Title: Re: Gallery problems
Post by: Carole on Jun 12, 2011, 20:35:16
Yup, too big.
I was just going by file size which appeared to be OK.

Carole