Woke up to blank pages

k2504 · November 30th, 2006, 02:00 PM

Hi there, I have had PhotoPost and Review post for approx 8 months now. I woke up to both programs displaying blank pages. I have these both programs on the same DB. Nothing else is on this data base.

I'm thinking that it's a cashe thing, as I had this problem on my other data base where my PhpBB is stored. Woke up to a blank page on my forums. I refreshed the cashe, and it came back.

Since both PhotoPost and Review Post went down at the same time, I'm ruling out a software problem. Any ideas?

Cheers. Rusty

http://www.riubambu.com/reviewpost/
http://www.riubambu.com/photopost/

Chuck S · November 30th, 2006, 02:17 PM

Well without any errors it is hard to respond.

I would suggest you check your server error logs for any errors and post them here so we can see if they assist.

You can also ensure the database info is correct in the config and the databases your pointing to.

k2504 · November 30th, 2006, 02:38 PM

Below was the last log

TTP/1.1" 200 1907 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Win32)"
host217-40-9-233.in-addr.btopenworld.com - - [29/Nov/2006:12:08:20 -0500] "GET /photopost/data/954/medium/Punta_Cana_Oct_22-29_2006_200.jpg HTTP/1.1" 200 50276 "http://www.riubambu.com/photopost/showphoto.php?photo=6331&limit=recent" "Mozilla/4.0 (compatible; MSIE 5.17; Mac_PowerPC)"
host217-40-9-233.in-addr.btopenworld.com - - [29/Nov/2006:12:08:20 -0500] "GET /photopost/data/954/thumbs/Punta_Cana_Oct_22-29_2006_195.jpg HTTP/1.1" 200 3179 "http://www.riubambu.com/photopost/showphoto.php?photo=6331&limit=recent" "Mozilla/4.0 (compatible; MSIE 5.17; Mac_PowerPC)"
host81-137-58-149.in-addr.btopenworld.com - -

Chuck S · November 30th, 2006, 03:14 PM

Nope no help there. Did you check out your config files and databases to ensure the information is correct. You sure your photopost and reviewpost directories and all the files exist and where not deleted?

k2504 · November 30th, 2006, 03:21 PM

All files and directories are fine and untouched. DataBase user names and passwards are untouched and correct. Just got off the phone with the server hosting my DB and they say nothing has changed. I can log into my DB and everything is there.

Chuck S · November 30th, 2006, 05:04 PM

well we need to have an error here to have something to work with your not posting an error so it is hard to give advise here to what might be your issue since your saying everything is fine.

Chuck S · November 30th, 2006, 05:05 PM

Maybe your host changed your servers paths. Check your config-inc.php file and ensure the $PP_PATH and $RP_PATH statements are correct

k2504 · November 30th, 2006, 09:20 PM

ok, I just created an .htaccess file and these are the errors I receive. They are the same errors in Photopost and Review post.

Warning: main(/services2/webpages/r/i/riubambu.com/public/photopost/languages/english.php): failed to open stream: No such file or directory in /services5/webpages/r/i/riubambu.com/public/photopost/pp-inc.php on line 175

Fatal error: main(): Failed opening required '/services2/webpages/r/i/riubambu.com/public/photopost/languages/english.php' (include_path='.') in /services5/webpages/r/i/riubambu.com/public/photopost/pp-inc.php on line 175

I'm not sure where the services5 is coming from......

k2504 · November 30th, 2006, 10:07 PM

I changed to services5 and both programs are back, but a few errors. Some stuff still linking to services2, like header, footer, and no thumbs. I'll keep working away.

It appears that the server changed it's path. I did a phpinfo and the old path is still there. Not sure what the services5 is all about. I'll blast them tomorrow morning. In the meantime, any ideas in getting the things back? Thanks

k2504 · November 30th, 2006, 10:16 PM

Well, I thought that everything was fixed and I did a database scan and I think that I lost everything. Everything was working photos, albums, and when I did a db scan, it deleted all the photos. all 5000. The data base is tiny now. But all photo are still in the data directory. Am I screwed?

Chuck S · November 30th, 2006, 11:48 PM

Yes your host changed your server paths without saying anything to you.

k2504 · December 1st, 2006, 12:09 AM

Registered Users 9,561 Comments/Ratings 237
Image Space Used 0.0 mb Total Photos 0
Total disk space used by the DATA directory 695.48 mb
Number of Albums 104 Photos in Albums 3756
Posts in Albums 100 ECards in Queue 3
Awaiting Approval 0 Total Views 0

k2504 · December 1st, 2006, 12:10 AM

can the data in the directories be used?

Chuck S · December 1st, 2006, 07:41 AM

Did you try rebuilding photos with the wrong path? You need to restore the photos table and correct the global and storage options in admin.

k2504 · December 1st, 2006, 10:49 AM

ok, Review Post seems to be working. I can uplaod new items and photos.

Photo post has these errors when trying to upload

Warning: getimagesize(/services2/webpages/r/i/riubambu.com/public/photopost/data/848/00780004.JPG): failed to open stream: No such file or directory in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 247

Warning: copy(/services2/webpages/r/i/riubambu.com/public/photopost/data/848/00780004.JPG): failed to open stream: No such file or directory in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 279

Warning: getimagesize(/services2/webpages/r/i/riubambu.com/public/photopost/data/848/00780004.JPG): failed to open stream: No such file or directory in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 508

Warning: getimagesize(/services2/webpages/r/i/riubambu.com/public/photopost/data/848/00780004.JPG): failed to open stream: No such file or directory in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 756

Warning: filesize(): Stat failed for /services2/webpages/r/i/riubambu.com/public/photopost/data/848/00780004.JPG (errno=2 - No such file or directory) in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 765

Warning: fread(): supplied argument is not a valid stream resource in /services5/webpages/r/i/riubambu.com/public/photopost/image-inc.php on line 765

I'm using the server path /services/ same as in the Review post. I have changed it in config and intergration but still get these errors. Why is it still coming up as /services5/ and /services2/ .

My server also changed my DB user name. I just found that out while talking to them. I have added the new user name and Review Post seems to be working fine.

Also, How do I rebuild table to make photos come back. Thanks. Rusty

Chuck S · December 1st, 2006, 11:03 AM

Your global options and storage options in admin must be updated to the new path more than likely your storage options still are set to the old path. You can view that and hit revert and save twice to load the corrected path from global options

You can not get photos back without restoring a backup of the mysql photos tables, You do take backups right?

k2504 · December 1st, 2006, 11:06 AM

ok, Fixed the storage options and the Software is working. My last backup is awhile ago, but I guess that it's better than nothing.

k2504 · December 1st, 2006, 11:12 AM

ok, how to I restore my backups?

Chuck S · December 1st, 2006, 11:18 AM

Well you do that either by using PHPMYADMIN through your control panel or SSH if your server has it. You host could probally help there since they caused this issue by changing all this without any notification to you.