View Full Version : Moved to new server now problem
October 9th, 2006, 07:25 AM
Just moved to new server same hosting company. Also upgrade to 5.5 and now I am getting the following errors in photopost admin panel (also receive many of the same errors when I asked the script to rebuild thumbnails.
Warning: opendir(/home/httpd/*****/*****/html/photopost/data/) [function.opendir]: failed to open dir: No such file or directory in /home/*****/public_html/*****/photopost/adm-inc.php on line 588
Warning: readdir(): supplied argument is not a valid Directory resource in /home/*****/public_html/*****/photopost/adm-inc.php on line 591
Warning: closedir(): supplied argument is not a valid Directory resource in /home/*****/public_html/*****/photopost/adm-inc.php on line 608
Any idea or help as to what I need to do to fix this problem would be greatly appreciated ? Several of my thumbnails and a few of the pics are not showing up (just the default thumbnail).
New problem, now all my pics seemed to have vanished ! Checked data folder and they are still there by not showing at all ??
October 9th, 2006, 10:30 AM
If you moved servers you need to update your config files with any new server paths. Once that is done you should be able to sign in and in global options in admin correct your data and uploads paths to the new paths and then in storage options hit revert and save twice to load the new paths.
October 9th, 2006, 12:53 PM
Thanks for the reply... the revert in storage options fixed the error messages, however, now I have no photo or views ?
Current Version 5.5
Registered Users 10,204 Comments/Ratings 5,464
Image Space Used 0.0 mb Total Photos 0
Total disk space used by the DATA directory 450.24 mb
Number of Albums 277 Photos in Albums 0
Posts in Albums 926 ECards in Queue 0
Awaiting Approval 0 Total Views 0
Any suggestions ?
October 9th, 2006, 01:57 PM
well if you tried to run a rebuild in scan database while your image path was wrong you deleted all the image inserts. You need to restore a backup of the photopost photos table.
October 9th, 2006, 03:18 PM
Yeah, I did a scan database... I'm not very good at restoring tables but at least I have a back up... I give it a try.
Thanks for the quick reply.
October 10th, 2006, 11:51 AM
I've restored photo table and got most of the pictures back, but now while I've got thumbnails again the pics themselves are missing and I get the following error message at the top of the page when you click on the thumbnail: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/*****/public_html/*****/photopost/showphoto.php on line 83
Any ideas as to where I need to go next to fix this latest problem. I really didn't think changing servers within the same hosting company would be such a pain!
October 10th, 2006, 02:36 PM
This tells me there is a problem trying to run the standard query for showphoto so nothing is going to appear. You tried to upgrade right well I would suggest in Admin => Global options you set debug setting to display errors so when logged in as admin you see the true error so we know what is wrong.
October 10th, 2006, 06:25 PM
Set to debug to show error, clicked on a thumbnail here it the result:
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: SELECT id,user,userid,cat,storecat,storeid,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,extra1,extra2,extra3,extra4,extra5,extra6,disporder,ipaddress,allowprint,allowrate,allowcoms FROM pp_photos WHERE id=3780
Result: Unknown column 'allowrate' in 'field list'
Database handle: Resource id #27
Does this help? Not sure what to do about "unknown column 'allowrate' in field list. Do I need to change the setting which allows users to rate pics ?
October 10th, 2006, 07:56 PM
You need to run your 5.3 to 5.5 upgrade script
October 11th, 2006, 03:07 PM
I had already run the script but I guess with the move it didn't take or something was lost. Ran the upgrade script and wow, everything works!
Thanks for your help you guys do a great job.
October 11th, 2006, 07:36 PM
remember you had to restore that photos table so the upgrade needed to be ran again to put that field in your old table you restored ;)
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.