Distorted thumbnails(NOT A BUG)

[sheri9642]

Linux Red Hat
Apache/1.3.34 (Unix) PHP/4.4.1
Dedicated Server under our control but we lease the box from Verio
MySQL 4.1.15

http://www.mydaughterswish.com/photopost/

We just transfered the site from a shared virtual server to a new dedicated server. Everthing went fine, duplicated the mysql data bases and dumped all the data in the db without any problem.

Uploading of images worked fine for a week but suddenly we are getting distorted and discolored thumbnails. Can't understand it.

GD Info:

GD Support enabled
GD Version bundled (2.0.28 compatible)
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled


Config setting:

// GD2 support
// this will only work if you have GD2 or better installed
// 0 - use mogrify; 1 - use GD2; 2- use GD1
$usegd = 1;


Any ideas what is wrong?

Thanks.

K

[Chuck S]

Looks to me like the GD library on the new server is messed up. Usually means the libraries are messed up.

If you are on a dedicated server you can install imagemagick if its not installed and try that out

http://www.photopost.com/howtoinstall-php.html

[sheri9642]

We reinstalled gd (2.0.28 compatible). But same problem. I'll install image magic if you think that it will solve the trick. But I don't understand why the gd program doesn't work still. Makes me think that the problem lies elsewhere.

[Chuck S]

Go ahead and email me your admin login so I can look at the settings. almost looks to me like your using gd1 not gd2

The issue is definately a processor based error involving the image libraries

[sheri9642]

Sooo..... after three weeks of head scratching.

After reinstalling gd, image magic, installing a brand new version of photopost to test image uploads I found the cause of the problem.

Turns out that the problem was caused by a missing row in the 'settings' table - row id 88 - that sets jpeg image quality. I added the row with the default setting at 70%, then made sure that the permissions were open up to 777 on the uploads and data directories and hey presto! - works. The thumbnails and other images are no longer distorted.

Gifs uploaded fine which should have given me a clue but I didn't even know a jpg image quality database row existed until I compared the test version of photopost with the original and spotted the missing row in the test version.

I've had a horrible three weeks trying to get this done so I hope that this posting saves someone else the grief I've been through.

[Chuck S]

Well the question would remain why was the setting not there. How did it get deleted. Good Catch

By the way your about 50% done on thumbnail rebuild and mediums are next

[sheri9642]

I did a global search of all the install and upgrade scripts and found that one of the mysql commands near the relevant row was missing a semi colon. I think that the script stopped upgrading the database at that point.

Here's the error:

upgrades/upgradegms.php was missing a semi colon on line 103;

$query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (92,'Display Members Gallery on the main index page?','showmem','','no',55,2)

Maybe this has something to do with it.

[Chuck S]

Okay but you dont own photopost gms? That is a product that was discontinued 2.5 yrs ago.

That setting was added in the Photopost 4.0 upgrade and I do beleive your license number suggests you had like 4.0 or above to begin with so no issue there. This was deleted a few weeks ago which suggest some upgrade that was not suppose to be ran was.

If that upgradegms was ran when you never owned the product maybe that could have been your issue. On the normal upgrade path and install files I show no issue with it.

Very good catch though not your run of the mill issue as everything pointed to GD2 being whacked. As soon as Kumar told me earlier tonight that he installed a fresh copy of photopost and it worked fine I was gonna check that very setting and saw you posted this here first and responded.