upgrade trouble

creekdawg · October 1st, 2005, 10:57 AM

I upgraded from 4.8 to 5.2 and there is no login box and I cant access the admin section Any ideas?

Chuck S · October 1st, 2005, 11:08 AM

Well we would need some more information here. What integration? what is the url of your install? Test Login

Your post has me thinking your cookies are not aligned properly but lets wait till you respond so I can assist you better

creekdawg · October 1st, 2005, 11:17 AM

upgraded photpost from 4.8 to 5.2

I put the new files back in the main dir the way it was after I upgraded it. So you could see what it did right after the upgrade

www.awesomantlers.com

creekdawg · October 1st, 2005, 11:48 AM

well after reuploading the new files again I got the main page to show up but it seems stuck loading images and wont allow any logins

Chuck S · October 1st, 2005, 01:21 PM

Well you still havent posted a link to your photo gallery and I find non with the link you posted

creekdawg · October 1st, 2005, 04:07 PM

sorry bout that here is the link www.awesomeantlers.com/index.php

creekdawg · October 1st, 2005, 04:11 PM

This is the error I get and it seems it is stuck on getting the go.gif image??

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\inetpub\awesomeantlers\forums\photopost.php on line 243

creekdawg · October 1st, 2005, 04:55 PM

anyone have any idea where to go from here. noone can login and the photos seem to be out of sync???

Michael P · October 1st, 2005, 06:36 PM

Please redownload the build from the Members Area and upload the changed pp-inc.php and upgrade.php and run it again. I've made a modification I think will fix this error.

creekdawg · October 1st, 2005, 08:18 PM

That fixed the errors but now I have no photos and cant get to the admin page. But it does look better

I think its close. Any way to find out where the photos link to the database a setting somewhere>??

Chuck S · October 1st, 2005, 08:26 PM

what do you mean no photos admin area is easy your missing your cookie prefix for vb most likely

Posting a url here will help us assist you faster

creekdawg · October 1st, 2005, 08:53 PM

www.awesomeantlers.com/index.php is the link

I can get to the admin page now after I moved over all the new 5.2 files from the templates folder.

In the admin section it says I am using 2.4gb of disk space but says no photos. It says the comments are there but whne i go into a category there are no photos?

creekdawg · October 1st, 2005, 08:54 PM

Quote:

Originally Posted by omegatron

what do you mean no photos admin area is easy your missing your cookie prefix for vb most likely

Posting a url here will help us assist you faster

Im not running VB,

Here is the link again

www.awesomeantlers.com/index.php

creekdawg · October 1st, 2005, 09:12 PM

On another post you said "Yes after upgrade it looks to me like you ran the 486 upgrade script step3 more than once and then you ran a scan database for missing thumbs which was not something you wanted to do as you have deleted your photo entries

To get your photo's back you need to restore a backup of your photos table and rerun the upgrades from your last version making sure to only run the step mentioned once."

I think this is my problem as well anything I can do if I dont have a backup of that table. I backed up the whole dir of the site and forgot to backup the DB. Am I screwed?

Chuck S · October 1st, 2005, 09:34 PM

well integration has notning to do with this.

I see how your earlier link was wrong thats why we never say a photopost

Okay basically before you do an upgrade the instructions state to take a mysql backup of your database

Your would need to restore a backup of your photos table using phpmyadmin or through ssh

After this you can run that step once.

Do you have a mysql backup of your photos table?

creekdawg · October 1st, 2005, 09:40 PM

on the backup I havent a new one, I have one from 5-30-05

creekdawg · October 1st, 2005, 09:45 PM

Since I dont have a backup of that table but have all the photos. How could I make it to where I could put all the photos back in the database without comments syncd up to them. basically just photos and let people put new comments if they want. Is this possible??

creekdawg · October 1st, 2005, 10:26 PM

I feel it is really screwed now and keep getting hammered with emails? Im desprate for help now? Anyone still up?

Now no catagorys are showing up? geeze

Is there someone I can pay to resolve this issue for me in a timely manner?

Chuck S · October 1st, 2005, 11:14 PM

You would need to use the old one from 5-30 if you want any hope of getting any photos back

creekdawg · October 2nd, 2005, 12:38 AM

Quote:

Originally Posted by Michael P

Please redownload the build from the Members Area and upload the changed pp-inc.php and upgrade.php and run it again. I've made a modification I think will fix this error.

I did this and I lost my database. I know I should of had a more recent backup but didnt think doing this would have resulted in what it did