5.02 and missing thumbnails

TundraSoul · March 23rd, 2005, 06:54 AM

I upgraded from 4.86 to 5.02 and encountered the missing thumbnail problem that I've read about here. I made it through Step 1, and Step 2, and was given this error for step 3. (See attached image)

I restored the database once already, did Step 1 again, skipped 2, and tried Step 3 again, but received the same error.

What should I do next?

Here's My Gallery but I have it closed.

Chuck S · March 23rd, 2005, 07:19 AM

Interesting your gallery is not closed though

Make sure your config settings are right as that error is when the database settings are not right.

Step 3 is not running on your install but I cant explain why other than the query is failing. You run that more than once.

Try this file rename to php as its just that last query

TundraSoul · March 23rd, 2005, 01:55 PM

Well I thought it was closed, and it's closed now.

At any rate, thanks for the file, I tried it, but it gave me the same error.

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

Everything other than this step works fine. Heck, people even uploaded when I wasn't looking and it worked fine.

The database settings are correct, or I suspect others errors would be present. Debugging suggestions?

Quote:

Originally Posted by omegatron

Interesting your gallery is not closed though

Make sure your config settings are right as that error is when the database settings are not right.

Step 3 is not running on your install but I cant explain why other than the query is failing. You run that more than once.

Try this file rename to php as its just that last query

Chuck S · March 23rd, 2005, 01:58 PM

Debugging well that error says your database settings are incorrect

Try running the file I gave you but replace the {$pp_db_prefix} with your actual table prefix

TundraSoul · March 23rd, 2005, 02:04 PM

I would but my tables don't use prefixes.

Quote:

Originally Posted by omegatron

Debugging well that error says your database settings are incorrect

Try running the file I gave you but replace the {$pp_db_prefix} with your actual table prefix

TundraSoul · March 23rd, 2005, 04:34 PM

No luck so far.

I restored the photos tables a few times now, ran the upgrade script and the file you sent me separately but neither was successful. It appears if you run step 3 more than once you end up with numbers in front of your photo names.

Suggestions, comments, jokes?

Quote:

Originally Posted by omegatron

Debugging well that error says your database settings are incorrect

Try running the file I gave you but replace the {$pp_db_prefix} with your actual table prefix

TundraSoul · March 23rd, 2005, 04:56 PM

Restored the ran step 3 again. I noticed it updated about 100 photos by applying the userid to the filename in the bigimage fields. However, it obviously stops at some point.

What id does in run to update the bigimage table? In another words what order does it process the photos in?

If I can figure out what photo it's stopping at I may be able to fix it.

TundraSoul · March 23rd, 2005, 04:59 PM

Many of our photos in the data directories are set to 664 instead of 666.

Does that matter?

New uploads are saved at 666.

Chuck S · March 23rd, 2005, 09:10 PM

Now your step2 query does not run.

If your step3 query is quitting I dont know what to say other than check your mysql settings

Drop me an admin login to check out your site

Step 3 resaves all images with the userid on front. You can only run this once.

Chuck S · March 23rd, 2005, 10:12 PM

Check the 500 category and check permissions. I am getting all kind of errors when viewing your admin settings it cant stat none of your files in your 500 cat. Could be this is why step2 is failing since this would be the first cat done

TundraSoul · March 23rd, 2005, 11:13 PM

Step 2 finished without any problems. Step 3 is the issue.

Quote:

Originally Posted by omegatron

Check the 500 category and check permissions. I am getting all kind of errors when viewing your admin settings it cant stat none of your files in your 500 cat. Could be this is why step2 is failing since this would be the first cat done

TundraSoul · March 24th, 2005, 05:13 AM

All the images are 666, and all the sub directories are 777, every single one of them. Load up the control panel and check my settings.

I did another database restore and upgrade, again, tonight, but it never finishes STEP 3 successfully.

In one of your messages in another thread you wrote:
1. Adds the normal upgrade stuff (DONE)
2. moves all medium and thumb images (DONE)
3. Resets the bigimage photos field imagename to useridimagename for compatibility with the new format of not writing images to userid prepended (INCOMPLETE).

Do you understand my complaint? The filenames in the bigimage field in the photos table are NOT being renamed. Help!

Chuck S · March 24th, 2005, 12:49 PM

Tundra

I have done literally tons of PP5 upgrades since pp5 came out not one install has a problem if the database settings are correct and the data directory path is correct and permissions are 777 on the data directories

Any problems reported in these forums are traced back to improper data path improper permissions or users running the upgrade script more than once resulting in image names being updated multiple times with the userid

From a coding aspect I dont see anything wrong. You cant even run a slimmed down upgrade I hand wrote just for the you

Your step2 or step3 will not run correctly if I remember

Chuck S · March 24th, 2005, 12:56 PM

Try this upgrade script just rename to a php file and run. Maje sure to edit the file and place your mysql username and password in there before uploading

I did not want to link the file here with them in it

TundraSoul · March 24th, 2005, 01:30 PM

Here is the error this file gave me:

Updating filenames...

Fatal error: Call to undefined function: ppmysql_query() in /mypath/photopost/fixnames.php on line 44

Quote:

Originally Posted by omegatron

Try this upgrade script just rename to a php file and run. Maje sure to edit the file and place your mysql username and password in there before uploading

I did not want to link the file here with them in it

Chuck S · March 24th, 2005, 01:45 PM

My Bad

As you see I am trying to bypass the pp-inc.php and do it without any interaction from Photopost

change ppmysql_query to mysql_query

TundraSoul · March 24th, 2005, 02:09 PM

Done, good job! The filenames in bigimage have been updated correctly!

Quote:

Originally Posted by omegatron

My Bad

As you see I am trying to bypass the pp-inc.php and do it without any interaction from Photopost

change ppmysql_query to mysql_query

Chuck S · March 24th, 2005, 02:18 PM

Your error then makes no sense at all

You sure you updated all files?

pp-inc.php especially

All I did was use your mysql info and in a script and run the same query we use in the upgrade

TundraSoul · March 24th, 2005, 02:40 PM

I saw that. Yes, all the files were uploaded from the zip except install and config.

Quote:

Originally Posted by omegatron

Your error then makes no sense at all

You sure you updated all files?

pp-inc.php especially

All I did was use your mysql info and in a script and run the same query we use in the upgrade

indiamike · April 15th, 2005, 03:40 PM

I had the same error and thanks to the script above I got it to work.

Whew....wipes sweat from brow.

I don't know why it happened either.