Upgrade was a disaster

Smoothie · July 17th, 2006, 01:06 AM

Not sure what's happening here, but I'm getting a ton of errors. Also, my users database table is empty.

Upgraded from 4.8.2 to current version. Also I just converted from IPB2 to vB, like 2 days ago. Help.......

http://www.macfora.com/gallery

Chuck S · July 17th, 2006, 07:13 AM

Your users table would always be empty if you did not have Photopost installed as a standalone. Thats only used when your not integrating with a forum.

I dont think all your upgrades ran. Do not run the 485 upgrade again but you can safely run the other ones after say adding this to the top of upgrade.php and see if things run.

Code:

Content visible to verified customers only.

Smoothie · July 17th, 2006, 10:35 AM

Quote:

Originally Posted by Chuck S

Your users table would always be empty if you did not have Photopost installed as a standalone. Thats only used when your not integrating with a forum.

I dont think all your upgrades ran. Do not run the 485 upgrade again but you can safely run the other ones after say adding this to the top of upgrade.php and see if things run.

Code:

Content visible to verified customers only.

At first, the upgrade wouldn't run. I would click the upgrade from 4.8.2 link and the page would just reload. After fiddling with some stuff I finally got it to run, but during a few of the upgrades there were errors about some permissions. I ignored the errors because it said upgrade was successful.

Anyway, now, I can't even access the gallery. I'll try the above and report back.

Question, I edited the config-int file and uploaded it before the upgrade, since there was not such a file before the upgrade. Was that correct? I have it set to vB3 integration.

Smoothie · July 17th, 2006, 10:42 AM

Getting this error:

Code:

Content visible to verified customers only.

Smoothie · July 17th, 2006, 10:44 AM

If I remove that line and just run the upgrade.php I get this:

Code:

Content visible to verified customers only.

Chuck S · July 17th, 2006, 10:59 AM

$skip_exheader="yes";

Smoothie · July 17th, 2006, 11:18 AM

I've made some progress, but there are errors listed at the top of the gallery and it won't let me login. It's also showing 0 users under statistics

BTW, I re-ran all the upgrade scripts

Chuck S · July 17th, 2006, 11:23 AM

well your errors are easy here.

You still have your gallery set to integrate with ib2 and not vb3 so you would need to change setting 41 in the photopost settings table to read vb3

Now the main issue I see if the one I warned you about above when I said explictly not to run the upgrade for 485 more than once. It seems you have ran it 4 times resulting in the userid's being prepending on the filename 4 times instead of once. You would need to restore a backup of the photos table in mysql and run the upgrades again once.

http://www.macfora.com/gallery/data/...81844478_l.JPG

Smoothie · July 17th, 2006, 11:27 AM

Restore a backup of the table photos and re-run the upgrade script after the 485 one?

Smoothie · July 17th, 2006, 12:06 PM

Quote:

Originally Posted by Chuck S

You would need to restore a backup of the photos table in mysql and run the upgrades again once.

That's a big table.

Smoothie · July 17th, 2006, 01:10 PM

Did what you said and its still giving me errors and I can't login.

Chuck S · July 17th, 2006, 03:23 PM

Okay delete the upgrade script. You can rebuild missing thumbnails but the photos now appear fine

http://www.macfora.com/gallery/

Check to ensure in setting 83 of the settings table you have the correct vbulletin table prefix set. Most likely you still have your invisionboard prefix there

Your main issues besides the fact of running the upgrade script over and over do not come from the upgrade. It is coming from the fact you are switching integrations midstream

Smoothie · July 17th, 2006, 04:28 PM

Quote:

Originally Posted by Chuck S

Okay delete the upgrade script. You can rebuild missing thumbnails but the photos now appear fine

http://www.macfora.com/gallery/

Check to ensure in setting 83 of the settings table you have the correct vbulletin table prefix set. Most likely you still have your invisionboard prefix there

Your main issues besides the fact of running the upgrade script over and over do not come from the upgrade. It is coming from the fact you are switching integrations midstream

I changed setting 83, it was set to the ibf prefix. Things are looking bettter but still problems. It shows me logged in as admin, but I can't get to the PP admin cp.

It's also still showing no members in PP under stats.

Smoothie · July 17th, 2006, 04:39 PM

Ok, now it's showing the users under stats, but I can't get to the admin cp

Smoothie · July 17th, 2006, 04:57 PM

Making progress, still no login options for the admin cp

Chuck S · July 17th, 2006, 05:05 PM

Have you read the various threads about switching integrations on the site?

changing BBS need advice

that should help you alot as you have not done any of that so you in essense never switched integrations yet

You need to delete all the inserts under your photopost usergroups table except administrators and change the groupid to 6 instead of 4. That will give you admin access. You can verify the rest of the steps in the other thread

Smoothie · July 17th, 2006, 05:18 PM

Quote:

Originally Posted by Chuck S

Have you read the various threads about switching integrations on the site?

changing BBS need advice

that should help you alot as you have not done any of that so you in essense never switched integrations yet

You need to delete all the inserts under your photopost usergroups table except administrators and change the groupid to 6 instead of 4. That will give you admin access. You can verify the rest of the steps in the other thread

No, I haven't read that, but I will now. Thanks chief!

Smoothie · July 17th, 2006, 05:39 PM

Do I run that script you have listed there?

Smoothie · July 17th, 2006, 05:50 PM

Quote:

Originally Posted by Chuck S

Have you read the various threads about switching integrations on the site?

changing BBS need advice

that should help you alot as you have not done any of that so you in essense never switched integrations yet

You need to delete all the inserts under your photopost usergroups table except administrators and change the groupid to 6 instead of 4. That will give you admin access. You can verify the rest of the steps in the other thread

Ok, I ran the script, so far so good. Now, could you explain which table I'm looking for to change the groupid's? I don't see a PP usergroups table

Smoothie · July 17th, 2006, 06:00 PM

Ok, when I navigate to PP db and table users, I click usergroup id and I get this:
MySQL returned an empty result set (i.e. zero rows).