Crop and Rotate error Crop and Rotate error
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Crop and Rotate error

Started by flurdy, January 10, 2006, 12:47:50 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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?
hmmmm

flurdy

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