Print

[flurdy]

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?

[flurdy]

Ah. okay. the album/edit folder had the wrong owner.