uploading error with SQL

rleroux · August 26th, 2006, 09:02 PM

Hi,

Just upgraded to 5.3. When I try to upload from my computer, or with files already in the upload folder, I get a Page Unavailable message. When I click refresh I get the following error message

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT SUM(filesize) AS fsize FROM pp_photos WHERE userid= AND storecat=0

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND storecat=0' at line 1

Database handle: Resource id #23

Everything was working just fine before when I was using 5.21...

Using PHP 5.0.4, MySQL 4.1.20

Chuck S · August 27th, 2006, 07:31 AM

user cannot upload

rleroux · August 27th, 2006, 10:19 AM

Quote:

Originally Posted by Chuck S

user cannot upload

Hi,

Did everything suggested in the post, and still getting the "Unable to find page" message...

All permissions are set as asked in the doc. Any other idea?

Thanks in advance!

rl

Chuck S · August 27th, 2006, 12:38 PM

The post above takes care of the mysql error. If your using GD2 and uploading large files you may want to visit this thread

http://www.photopost.com/forum/showp...69&postcount=6

rleroux · August 27th, 2006, 09:38 PM

Did that also, but the problem remains. I think it might have something to do with the server settings. I have upgraded another license of Photopost running on another server, as a standalone not integrated with vBulletin, and no problem...

Chuck S · August 28th, 2006, 07:59 AM

Very well could be list your problem site and test login here. So you upped your PHP memory and no go still thats unusual. what size file? Try a smaller one.

rleroux · August 28th, 2006, 12:24 PM

Quote:

Originally Posted by Chuck S

Very well could be list your problem site and test login here. So you upped your PHP memory and no go still thats unusual. what size file? Try a smaller one.

OK, smaller size and dimension files work. I think the problem lies in the resizing for images. In the upload options I have:

Max allowable image width in pixels: 2500
Max allowable image height in pixels: 2500
If photo upload width or height exceeds maximums, resize upload down to max dimensions? : yes

But if I try to upload a larger width or height image, it does not work. I have changed the width and height settings to fit my image (3500) and it worked. So it seems like a resizing problem.

I will send you login details through PM

Thanks

r

Chuck S · August 28th, 2006, 07:09 PM

You know you also have max execution of your php scripts set to 30 seconds thats not gonna work with larger files that may take over 30 seconds

rleroux · August 29th, 2006, 04:57 AM

I have tried everything and it definitely comes down to this: if photo upload width or height exceeds maximums, it will not resize upload down to max dimensions, however I ajust settings. So for this to work I have to either ajust max allowable image width and/or height in pixels in the Admin panel to fit the photo I want to upload, or resize my photo to fit max allowable image width and/or height in pixels prior to upload.

Chuck S · August 29th, 2006, 08:19 AM

Dimensions have nothing to do with anything trust me here. It is filesize because what happens when you edit a big file yourself in a graphics program and resize it then it gets really smaller hense your uploading a small file

The filesizes your sending are real large for a 3500x3500 item no doubt and your issue is as I state. You need to clear your uploads directory and revisit post 4 and 8 and make changes necessary. You might want to also post a url to your site and your sites php settings

rleroux · August 29th, 2006, 07:16 PM

Seems my problem had something to do with GD swallowing anormal amounts of memory on our system (even with memory limit set to 48mgs in php). My system admin installed ImageMagick, I switched to it and everything is now working real fine.

Thanks for your help and sorry for the bother.

r