Users Struggling to Upload Photos...

[grahamsmythe]

Have been experimenting with this and spent the entire weekend trying to work out what's wrong, but have now come to a dead end.

Many of our users have struggled to upload photos for some time now, and although I tried to fix it, I drew a blank.

On Friday I upgraded to the very latest version, but still things don't work as they should.

I recently tasked a user from Australia to try again and he's still struggling. He gets the message

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@vincentownersclub.co.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I also get the error emailed to me...

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 18 AND userselect = 1)
OR styleid = 18
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, November 11th 2012 @ 03:46:57 PM
Error Date : Sunday, November 11th 2012 @ 03:49:49 PM
Script : Login - The Vincent H.R.D. Owners Club Photo Gallery
Referrer : Login - The Vincent H.R.D. Owners Club Photo Gallery
IP Address : 220.239.216.185
Username : MartynG
Classname : vB_Database
MySQL Version :

Help!

[Chuck S]

This looks like an email I recently answered via our helpdesk a few days ago.

1. There are a wealth of info here on upload issues. Are you using GD2? Is this just one user or can you upload or all users can not upload. Very hard to answer without information.

user gets error while uploading photos

Maybe that will help you can also try seeing if Imagemagick is installed and use that.

2. You section issue has nothing to do with our product that is a vb error and mysql gone away means your mysql has shut down on your server. The only thing this gives credence to is maybe your using GD2 and the user is uploading a huge file and your server has shut down as a result since GD2 takes all your php memory

Up your PHP memory to say 84M with the statement example provided and in your upload options in admin make sure your max dimensions are no more than 1500

[grahamsmythe]

We do have ImageMagick installed on our server, and the option for this is selected under Global Options.

Many, many users have experienced the same problems. As I say, I've spent an age trying to get to the bottom of it, but never succeeded!

Although our maximum width and depth were set to a maximum of 5000px each, I have just reduced them both to a maximum of 1500px each.

Furthermore, our PHP memory was set at 32mb, which was the server-level default, but I have now arranged for this to be increased to 128mb - slightly more than suggested.

Can you think of anything implement before I get some 'guinea pigs' to test it?

Finally, is it still worth putting

ini_set("memory_limit", "72M");

into pp-inc.php even though we're not using GD2?

Cheers

Graham

[grahamsmythe]

1. I have 124 images in my upload folder and have just tried posting them.
Same problem. Same error.

2. Have also just inserted ini_set("memory_limit", "72M"); into pp-inc.php
Same problem. Same error.

[Chuck S]

1. Delete all folders under uploads directory

2. You can try 84 or 96M. What is the memory limit it says under phpinfo in admin? lets see if your doing it rigfht. Have you also verified whether imagemagick is installed and tried using that? After deleting uploads directory try a smaller file

[grahamsmythe]

1. Have deleted all the upload folders
2. Have altered the php.ini file so the maximum memory is 96mb.
3. In PHP Info in admin - Local Value 72mb. Master Value 96mb.
4. Not sure how to test ImageMagick, but my host has assured me it is installed.

[Chuck S]

Local value 72mb means you have not edited the file correctly or your server does not support ini_set overrides

You would need to have your host give you the path to mogrify and enter that in your config settings then switch global options to imagemagick and try.

So after clearing your uploads directory are you able to say upload a small image as a test. There are alot of info here you can not process a 4mb image with GD2 that will crash PHP every single time so it that is how your testing you might want to try a different image.

I really can not give any more hints without seeing the actual site here.

[grahamsmythe]

Q.

Originally Posted by Chuck S

Local value 72mb means you have not edited the file correctly or your server does not support ini_set overrides

I've spoken with our host (Westhost), and they DO support ini_set services.

In my php.ini file, I have put the following
memory_limit = 96M ; Maximum amount of memory a script may consume (128MB)

In my pp-inc.php file, I have put the following
error_reporting(E_ALL & ~E_NOTICE & ~8192);
ini_set("memory_limit", "72M");
define('PP_SCRIPT', 'PP_Pro');


Q.

Originally Posted by Chuck S

You would need to have your host give you the path to mogrify and enter that in your config settings then switch global options to imagemagick and try.

My host just gave me the path to mogrify which is
/usr/bin/mogrify

I checked in PhotoPost Admin Configuration Administration
and my Path for MOGRIFY executable is already
/usr/bin/mogrify

Q.

Originally Posted by Chuck S

So after clearing your uploads directory are you able to say upload a small image as a test.

A single file using the Flash uploader works fine.

Seven files using the Flash uploader crashed the site (although the seven images are now sitting in my uploads folder now)

[grahamsmythe]

Westhost have told me that

You may need a SetEnv PHPRC <filepath> line in a .htaccess file for a php.ini file with local settings to take effect properly.

What do you think?

[Chuck S]

Graham

Your telling me you are specifically putting a line in your pp-inc.php setting the php to 72M which is why your local value shows 72M You can remove that line there is no need to set a line if your altering your gallery php setup to 96M

next like I suggested in your config settings where it asks for your mogrify path put what they are telling you and then set your global options processor to Imagemagick and save. Then you can try your uploads.

[grahamsmythe]

Originally Posted by Chuck S

Your telling me you are specifically putting a line in your pp-inc.php setting the php to 72M which is why your local value shows 72M You can remove that line there is no need to set a line if your altering your gallery php setup to 96M

I have now removed this line from pp-inc.php and memory_limit is now 96mb for both local value and master value

Originally Posted by Chuck S

next like I suggested in your config settings where it asks for your mogrify path put what they are telling you and then set your global options processor to Imagemagick and save. Then you can try your uploads.

In http://www.oursite.com/photos/adm-index.php - Administration - Edit Config - Path for MOGRIFY executable - the path is /usr/bin/mogrify It has actually been set to this path for months.

In http://www.oursite.com/photos/adm-index.php - Administration - Global Options - Imaging Integration (IM or GD) Select ImageMagick or GD1/GD2 for image processing - this is set to ImageMagick It has actually been set to this for months.

I've tried uploading the seven images which were in my upload folder, but again, it brought the site down.

Can you think of anything else?

[Chuck S]

One file works seven do not? Are you using the latest code just in case you have corrupt files? Again just taking a guess since you are not providing real data here.

It would have to be related to server issues then and I would need more information. what is in your server error logs?

what is a url ftp login and url admin login of the site so we can see how you have things set. You can send any site data through the contact us link.

westhost has been my host for many years and there are no issues that I know of. Imagemagick is not held to PHP memory like GD2 to my knowledge.

what size files are these you are uploading?

[grahamsmythe]

Originally Posted by Chuck S

One file works seven do not? Are you using the latest code just in case you have corrupt files? Again just taking a guess since you are not providing real data here.

Yeah, sure I'm using the latest code, as I only downloaded it the other day.
All CHMODs are correct.

Originally Posted by Chuck S

It would have to be related to server issues then and I would need more information. what is in your server error logs?

When I tried to upload seven images via the Flash uploader yesterday, the site fell over, but Westhost said it didn't produce an error on the log. These seven files are now in my queue on my upload photos page, but they don't appear in my Uploads folder via FTP, so not sure what's going on there.

Originally Posted by Chuck S

what is a url ftp login and url admin login of the site so we can see how you have things set. You can send any site data through the contact us link.

I'll send this separately.

Originally Posted by Chuck S

Westhost has been my host for many years and there are no issues that I know of. Imagemagick is not held to PHP memory like GD2 to my knowledge.

You put me onto Westhost quite a few years ago, and I have been more than happy with their service (thanks for that).

Originally Posted by Chuck S

What size files are these you are uploading?

They're not enormous, anything from 0.5mb to 4.0mb.

[Chuck S]

well definately can not respond without knowing what your doing thats for sure. If a photo exists in your uploads page it has to exist in the uploads folder so maybe your looking in the wrong uploads directory.

[grahamsmythe]

That's exactly what I thought.

http://www.oursite.com/photos/uploadphoto.php tells me that I have seven images in my queue.

However,

/public_html/photos/uploads is completely empty

My user number is 24.

Go figure that!

[Chuck S]

That would be impossible. You must be looking in the wrong place. The uploads page has to stat the uploads user folder to report those figures.

I would also suggest you turn off the flash uploads and then try uploading as well but first you need to clear the uploads.

[grahamsmythe]

Am getting somewhere (I think)

Under global options (bearing in mind we're with Westhost as well)

For uploads and data, would you put the path as...
/home/ourserver/public_html/photos/data/
/home/ourserver/public_html/photos/uploads/

or

public_html/photos/data/
public_html/photos/uploads/

[Chuck S]

Your server path would be your full server path so something like your top example definately not the bottom.

[grahamsmythe]

with the final /
?

[grahamsmythe]

I've tried everything.

All my paths are correct.

One image uploads without too much of a problem (although it does take a long time)

Any more than the one image, and I get a server error.