Moved to new server now problem

paprman · 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.

Code:

Content visible to verified customers only.

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

Henry

Chuck S · 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.

paprman · 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 ?

Quote:

Database Statistics
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 ?

Henry

Chuck S · 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.

paprman · 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.

H

paprman · 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:

Code:

Content visible to verified customers only.

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!

Henry

Chuck S · 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.

paprman · October 10th, 2006, 06:25 PM

Set to debug to show error, clicked on a thumbnail here it the result:

Code:

Content visible to verified customers only.

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 ?

Chuck S · October 10th, 2006, 07:56 PM

You need to run your 5.3 to 5.5 upgrade script

paprman · 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.

Henry

Chuck S · 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