Ran Upgrade from wrong version.
 

Ran the upgrade to 8.22 from 3.3 instead of 5.5 as I should have.

Am now getting the following error:

Site URL: http://www.warofthering.net/photoforum/
MYSQL version: 5.1.66-cll
PHP version: 5.3.9

I exported the dabase prior to the upgrade so can restore if needed. Any advise would be helpful...thanks....

I was going to restore the DB and try the upgrade from the correct verion but belive I have screwed the pooch so wanted to ask here first.

I cannot access anything to create a test login but will gladly provide my credentials via PM.

Not sure what your comments about 3.3 or 5.5 are

Did you overwrite your config file and maybe put wrong wrong information.

The error you put is pretty straight forward. Basically it says your photopost database name is warofthe_photopost and your table prefix is photopost.

Therefore it can not find a table in the warofthe_photopost database called photpostusers.

So based on my observation of your error what is your problem? If photopost is correctly installed there should be a users table so is your database name wrong or is your table prefix wrong in your config-inc.php file?

Basically you must ensure the database and its tables exists and you have the proper information for that database in the config file for you to upgrade and things to work right. If this was a functional install before you upgraded and you followed the upgrade documentation you should not have any issues.

Basically now we just need to track down the problem based on the errors posted.

Thanks for the prompt response Chuck!

What I was going on about is that I believe I was running version 5.5 but started the upgrade from version 3.3....and the upgrade warns that can seriously screw things up which is what I thought I had done.

You were exactly right though sir. I'm not sure if my old partner who had originally set this up did this correctly, but the section in the config-inc file here:
// PhotoPost's database name
$database="warofthe_forums";

actually specified the VB database before we upgraded to VB 4.1 Suite......I changed it to point to my new VB database:
// PhotoPost's database name
$database="warofthe_forumsnew";

I ran the upgrade again pointing to the correct database and now the gallery comes up and I have access to the admin panel...and this is strange as it's not pointing to the PhotoPost database so I guess they are integrated? Not sure...but part of it's working!

Couple of issues now though.

1. Tried to follow this to complete the upgrade: That button it mentions does not exist so I cannot generate the plugin. I had to remove those files to check out the User Index, but have put them back to you can test if you have the time.

2. It appears that the user database is no longer being pulled from VB due to the fact that I have to use an old password to logon to the Photo Forum rather than the new one I have set for my VB install. (will send that to you)

3. Even though all of that data folders are populated, there are only 4 photos showing up as random and all the catagories are empty. No photos anywhere and there are thousands.

I've tried most of the options under Scan Database in the AdminCP but no luck.

Since the user DB does not appear to be linked, I cannot create you a test user but will pm you the current my admin info and will change it later.

*Edit.....cannot send you a PM. Here is the user to use then:

The gallery you showed me you installed as a standalone not integrated with vb. Likewise the database that is under the user database portion says the database was photopost not forums.

See the point here is not only do you have to upgrade properly you also have to make sure it is installed properly if you moved servers database etc.

Now you have it integrated with a supposed forum your saying exists here but it doesnt

http://www.warofthering.net/forum/vbulletin225/upload/

Basically my suggestion would be that you purchase the installation service and they can install a properly copy integrated with the vb forum.

Obviously I do not know what can be kept or salvaged because I do not know what you have done or how the gallery was installed. Like if you had an old gallery standalone and are now trying to integrate it with a new clean vb forum you can not do that until such time as you use the vb impex script to import all those old photopost users.

Thanks Chuck....I think I know where some of the confusion lies here. You saw the navigation which still had the linki to the old VB install.

If you look at the admin link here: Login - War of the Ring Community Photo Forum

You will see that it is pointing to War of the Ring - The Ultimate Hobbit, Lord of the Rings, and Tolkien site which does indeed exists and is live and well. We've been integrated since we were running VB2.

Does that help any? If not, I'll go ahead and purchase the upgrade assistance as it's clearly how the upgrade was done that caused the problem.

there is no confusion this is the same thing you showed me in my last reply

Message - War of the Ring Community Photo Forum

This would not be an upgrade service it would be an install service your site is clearly broken and not installed right.

Look at the gallery if I click the register link it tried to take me here

http://www.warofthering.net/forum/vbulletin225/upload

Does that make sense here? Do you see what I am seeing here? You may once upon a time had this gallery integrated with vbulletin 2 and that might have worked however your now trying to integrate with a different product which was released a decade after vb2 and is a totally separate forum product.

Just like my last reply you would need to properly install your gallery to integrate with vb4 which is a totally different product just like vb3 was. I am assuming you have properly ran any upgrade.

Hello Chuck,

I thought I would get back to you here just in case somebody else makes the same mistakes that I did.

As it turned out, in addition to starting the upgrade from the wrong version (which I reported in my initial post) I also had the User Database "$database_bb="databasename" pointing to the old PhotoPost DB instead of my current VBulletin DB like the other entries in the config-inc file which was a bigger issue.

The reason you were getting the wrong registration link was just an entry in the Admin panel that was pointing to where my old VB3 install was...even though we still left the folder named vb225......

Fortunately, I did a msqldump of all the dabases prior to the upgrade so I was able to re-run the upgrade from v5.5 and everything went as planned.

So basically...as you originally suspected, there were mis-matches in my config file and admin panel between the previous VB3 version (that was and is still integrated) and my new install of VB4.

Here are the steps that I followed to correct it..

1. Restored the VBulletin database containing the PhotoPost tables.
2. Verified that the config-inc file was pointing to the correct dabase variables.
3. Re-ran the upgrade from the proper version.

Everything is fine now as you can see here:
A community photo gallery - War of the Ring Community Photo Forum

You can even click the registration button if you like. It will take you right to my VB4 community as it should. I still have to tweek the stylesheets to match the rest of the site but we are online! :cool:

My only concern now is still the fact that even with the files in the install folder set to 777 as they should be there is still no link to download a plugin like the instructions say:

I have removed the install folder for now for security reasons but can put it back up there, CMHOD the files, and give admin login to have a look if you are so inclined.

well running the install would have let you see your mistakes easily pointing to the wrong database if your going to change them is a biggy. ;)

The reason you do not see generate an xml plugin link is easy. You are not turning on the vb integration switches under admin-> edit integration they are off hense there is no reason to generate plugins as your not telling our program you have vb4. You will need to upload the install folder to generate those plugins.

Okay....I kept trying that but was editing via the PHP file itself rather than the interface. As soon as I set the config-int file to chmod 777 and set it to yes there then poof....the download link appeared.

Now if I can figure out why the gradients and borders that I have defined for the forums don't port over to the photoforum along with the rest of the style I will be golden!

It seems like it's just picking up the CMS styles which are pretty much flat with no borders.

*Edit....whoa whoa whoa!! As soon as I installed the product it fixed EVERYTHING!!! It seems like it actually needs the plugin in order to import the styles correctly. This is great! I thought I was going to have to manually skin it again like I had to do with VB3.....

I am a happy camper.....thanks.

Yep as stated you simply need to install the plugin for vb4. ;)