forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: flurdy on January 10, 2006, 12:47:50 pm
-
Photos can not be cropped or rotated once uploaded.
Album is on a rebuildt server and I upgraded from 1.3 to 1.4.2 at the same time, so not sure if it is missing modules or 1.4 configuration issue.
Problem occur when trying to crop/rotate a photo. Usually then a preview starts appearing on the page, but it does not.
And when I press save picture and error comes up. The photo file is then reset to no size therefor lost.
The error is : "There was an error while processing a database query."
With debug on the sql error is :
While executing query "UPDATE cpg132_pictures SET pheight = , pwidth = , filesize = 4096, total_filesize = 47545 WHERE pid = '692'" on 0
mySQL error: 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 '
pwidth = ,
So basically the height and width has not been populated in the update string.
I can include the whole debug info if required in another post.
The height and width has been fetched if I scan through the debug, but I presume these are the resized/rotated values, so the problem seems to be with creating the new photo.
So I have been testing with changing between imagemagic/gd1/gd2, installing a couple extra packages, etc with no result. I cant see how these settings are can be wrong since it works fine when doing the initial upload and creating the thumbnails etc.
Any ideas?
-
Ah. okay. the album/edit folder had the wrong owner.