Upgrade Problem

[Intex]

URGENT REQUEST - GALLERY UNAVAILABLE

I've recently upgraded my forum running vB2 to vB3 which works great and then decided to upgrade my photopost from version 4.0 to 4.8c.

I copied all files from the zip and overwrote all files in the gallery root as highlighted in the installation instructions, with the exception of install.php and config-inc.php. I then ran convertor.php and put in my respective cookie / vB license settings. This was all ok.

However, now when I try to enter the gallery index page, I get the following error:

Content visible to verified customers only.

The first thing I note is that it's trying to select from a table called 'photopostuser' and there isn't a table called this, but there is one called 'photopostusers'. Now I remember having this problem with an earlier version of photopost and posted it in this forum, but it appears as though you've removed a lot of the old posts so I cannot see what was done to correct it. If I remember rightly - I had to actually modify the files themselves so that it called the table by 'photopostusers'.

My knowledge of mySQL is a bit better now so rather than adjusting the files, I renamed the table temporarily to 'photopostuser' to see what that did. I was then just presented with another SQL error:

Content visible to verified customers only.

So it appears as though other information is missing. I also get an error at the top of the screen as shown in the attachment.

I'd really appreciate some urgent help on this because the website gallery is current down. A copy of my config-inc.php file is attached (database username / password and vB license info REMOVED).

[Chuck S]

I would go to PHPmyadmin and actually check what line 41 says in the setting table?

[Intex]

Line 41 States:

ID: 41
Title: User Registration System
Varname: vbversion
Description:
Setting: vb3
Optionorder: 12
Section: 1


Are you thinking it's to do with the fact that it's not setup for vb3 properly? I can't see how it could be that to be honest, I mean there's a more fundamental problem that that I suspect, i.e. the scripts are calling a table that doesn't exist. There is a 's' on the end of my photopostusers and the script is requesting photopostuser.

[Intex]

This error applies to any file I call for the gallery, i.e. adm-index.php, adm-main.php etc.

[Chuck S]

Looks like you have it looking for member information from your photopost database not VB3

Is your VB3 tables in the database photopost or some other? Check the bb database info in your config and make sure it is accurate. That would explain your error.

[Intex]

vB3 and Photopost share the same database yes. I attached my config-inc.php file above, what configuation(s) am I looking at exactly? If you (also) mean in phpmyadmin, can you also confirm where I should be looking.

Thanks for your help.

P.S. The only configuration I see in config-inc.php relating to bb is this:

Content visible to verified customers only.

As you can see it's using a database called 'skynet'. This is the correct database for my vB installation.

[Chuck S]

Okay we have verified your in the proper database.

Then your table prefix for VB3 can not be correct as you entered it.

Okay then setting 83 in your photopost setting table is what?

Result: Table 'skynet.photopostuser' doesn't exist

Database handle: Resource id #7

this tells me your telling Photopost that the VB3 tables have a prefix of photopost. If VB3 has a table prefix you need to make sure it is properly entered in setting 83 of the settings table

[Intex]

Setting 83 is:

ID: 83
Title: Forum database table prefix
Varname: dprefix
Description:
Setting: photopost
Optionorder: 14
Section: 1

I'm not using any prefix with vB3 (which I know is a new function). I simply upgraded v2.x to v3.0.1 (which is working fine).

As I was saying before regardless of the prefix, there isn't a table called 'photopostuser' only 'photopostusers'.

I've attached a screenshot to show you my database column. I've just done a screenshot of the top part and then the relevant section where photopost tables are.

[Michael P]

So your vB3 forum prefix is "photopost"? I doubt it. I fyou have no prefix, remove the "photopost" setting.

[Intex]

OK, now I'm confused.

My database structure has not changed. I had vB2.x installed for a long time along with photopost. Photopost has been working with the database structure you see in the screenshot in my last post, i.e. photopost tables prefixed with 'photopost'. I then upgraded to vB3 and obviously had to update Photopost. It's only at this point that I've had a problem.

I'm not suggesting my vB3 forum prefix is photopost. I have a database called 'skynet'. On the root of the database are all the vBulletin database tables. Some of these tables belong to photopost as you can see. It's only these that have the prefix photopost, i.e. photopostusers.

[Chuck S]

Intex

You missing what we are saying.

You obviously at some point when upgrading changed setting 83 possibly when using the forum convert script donb posted here for users. Setting 83 for you should be empty remove photopost from there

photopost.user does not exist as you state. What you do have is skynet.user and so remove that prefix and your install will work.

[Intex]

Ahh I see what you're saying. Apologies for that.

OK, I've removed that setting and the SQL error has disappeared. However I still get the error at the top of the page (see attachment) and also I don't get anything showing on the page, thumbnails, categories etc.

Any ideas?

[Intex]

OK, ignore the above - I can see categories etc. it helps if I actually login - doh!! Forgive my lameness .

I do however, still have that error at the top of the page, so any help on that would be appreciated.

[Chuck S]

Try commenting out these lines at the top of index.php and see what you get

if ( is_numeric($argv[0]) ) {
header("Location: {$Globals['maindir']}/showphoto.php?photo={$argv[0]}");
exit;
}

would be thus

//if ( is_numeric($argv[0]) ) {
// header("Location: {$Globals['maindir']}/showphoto.php?photo={$argv[0]}");
// exit;
//}

[Intex]

Thx. Omegatron, that certainly removes the error. However, don't I need this code?

I think I only have one outstanding issue now and I'm all ok. All areas of the gallery look fine and appear to be functioning as expected. However, when clicking on any thumbnail of any image in any category, all that's displayed it the typical image placeholder, like it can't find where the images are. See screenshot for an example.

Once I've got that sorted, I'm good to go, so any last bits of help would be appreciated. That's for your persistence.

[Chuck S]

Do you have on the fly watermarks enabled? Turn them off as you have not filled out the watermark.php file

At least that is what it looks like in your picture

[Intex]

Yeps, that's exactly what was causing the problem. Thx. for all your help Omegatron. Appreciated .