Big problem after upgrade!!!!!!!

Johnny Doomo · April 2nd, 2005, 05:53 PM

I updated from an old version to the latest 5.03

The upgrade went fine and the new gallery is up and everything appears to work just fine. But when I login using my old username and password it gives the error: "Invalid login. Please check your username and password, or register. "

1. I have it use my forum for the user database.

2. I have checked and it appears to be working as at the bottom of the page it says: "Users: 3,824" so it at least got that.

3. In the config-inc.php I have made sure to change the $database_bb, $user_bb, and $password_bb. They are set correctly as I pulled them straight from my old config file.

I don't need to change the $host_bb do I? It sounded like it was fine being left as local host.

I didn't have any errors updating. (4.0.1 to 5.0.3)

I need to get into my admin CP ASAP so that I can begin changing the colors and turn off user access to the gallery so that it can be updated properly with a new scheme.

Can somebody please help me at how to fix the problem? Is there a section I need to specify what forum version I have? I remember in the older photopost version there was a dropdown menu in the admin section, but I can't even get to that nor did I see any other options I could change in the new config file.

PLEASE HELP!!!

Johnny Doomo · April 2nd, 2005, 06:18 PM

After Looking into the problem more I have found this:

On pages with comments this error appears above the header:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/domain/gallery/forums/vb2.php on line 127

(it doesn't say path to domain I changed that)

in vb2.php on line 127 it reads:

Code:

Content visible to verified customers only.

It looks like it could be having troubles with my forum version. I have a fairly old one (I'm not going to state publicly)

Is it possible to recover from this problem? I really hope it is as nobody nor your requirement pages say anything about a certain version of VB being required to use/upgrade a Photopost install.

Chuck S · April 2nd, 2005, 09:47 PM

I would more likely say that your vb2 has been altered from the default vb2 install.

I know in VB3 some users have this issue because they delete the location field

userfield table field2

If this is the case you need to adjust our query

Johnny Doomo · April 2nd, 2005, 10:09 PM

What exactly do you mean? Yes I have modified VB2 from a brand spankin new installation, but it worked fine on my Photopost from before. Also, I am not incorporating it in any way to the site, only to use it's registration database, so since my VB user database has not been changed in the last 24 hours since I updated my Photopost, what did you guys change from 4.0.1 to 5.0.3 that messed up grabbing user logins and passwords from VB2?

Chuck S · April 3rd, 2005, 06:38 AM

Johnny most likely you made this alteration before and forgot about it

What I am saying is look at our file and the field it is looking for in your userfield table. Does field2 exist

$query = "SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,u.signature FROM user u
LEFT JOIN userfield uf ON uf.userid=$cuserid
LEFT JOIN session s ON s.userid=$cuserid
WHERE u.userid=$cuserid LIMIT 1";
$results = ppmysql_query($query,$db_link);
list( $cuser, $chomepage, $ctitle, $cposts, $regdate, $clocation, $conline, $csig ) = mysql_fetch_row($results);
ppmysql_free_result( $results );

Point being as said we code our product to a normal vb2 or vb3 install if your tables or fields are modified then you need to modify our code to match. If you have removed the user location field then as stated you need to modify our code to match

Johnny Doomo · April 5th, 2005, 11:57 AM

Hmm, I'm confused now. As far as I know and remember I never changed my old photopost to look at a different registration field on my forums. (If that is what you were reffering to?) I have two questions:

1. Would it be possible/easier to switch so that my gallery running on an internal registration system and not my VB2 board? I tried changing in my config-inc.php file the "User database MySQL database name" and the "MySQL username and password to access user database", but registration/login still didn't work, still redirected me to my forum registration page. It also put more errors at the top of the photopost pages.

2. If that is not possible/easier what do I need to do/look for in my VB code? I am almost postive I never did this before for my older photopost, but if you claim that is what is causing the problem I will change whatever I need to, but I don't know what to look for or where to begin.

Thanks for any help you can offer me. Please let me know what would be easier out of the two options and how to get the easier one to work. I believe I would preffer getting my photopost on it's own internal registration system so that I do not run into this problem again in the future.

Chuck S · April 5th, 2005, 12:12 PM

If you are integrating with vb2 you need to find out what change you made and alter our query. I have already stated the most common problem as the field2 thing. If you remove the location field from VB you will have this problem

Try changing the query I posted above to this which removes the location field in vb2.php

Code:

Content visible to verified customers only.

Johnny Doomo · April 5th, 2005, 04:16 PM

Nope. It is the same problem. If that change is something I would have had to have done on my original Photopost install, I don't believe I ever changed anything to make it compatible with my VB nor do I believe I have modified anything on my VB board since the installation of my original Photopost.

That is why I am a little concerned of why it's not working now.

Would it be hard to switch over to the internal registration system? Shouldn't it have worked with what I mentioned in my last post? I thought that those settings in the config-inc.php file were the only things that need to be changed.

I don't however want to lose user galleries that have already been created either.

Chuck S · April 5th, 2005, 05:35 PM

This means that you are missing something in that query

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/domain/gallery/forums/vb2.php on line 127

That would be something you need to correct as in a default vb2 install all those fields exist

If you want to switch to internal then you need to adjust all the appropriate database integration settings

Johnny Doomo · April 5th, 2005, 07:00 PM

Well it's looking more and more like the Photopost update program F'ed up. Despite it not reporting any errors, cats claim to have comments that aren't there, no dates are appearing on image posts and that's just what I've been able to see.

And people wonder why I don't upgrade. Appearantly the upgrade really screwed up my entire site, despite following the instructions to the letter.

OK can you tell me what I need to do to change it to the internal registration system? Where to I find all the "appropriate database integration settings"? I changed all the user database info in the config-inc.php file. Where else is info stored and what will I need to change it to?

Johnny Doomo · April 7th, 2005, 10:18 AM

Bumpbump

Chuck S · April 7th, 2005, 10:44 AM

Johnny

The error your reporting has nothing to do with our upgrade program period. I have stated this several times.

How does this have anything to do with the upgrade

Code:

Content visible to verified customers only.

I have replied several times that you have altered or removed from vb2 a field we look for in a default vb2 install. Given that it would be up to you to figure out what you altered.

I have done recently a vb2 install and there are no issues.

Johnny Doomo · April 7th, 2005, 11:32 AM

1. So why did my previous installation of Photopost work from scratch and this one doesn't? I haven't changed anything since.

2. What did you start looking for in a VB2 installation that you didn't look for in 4.0.3 that you do look for now?

3. How am I suppose to figure out what I / you changed to get my new Photopost to work? It's not like I remember all the lines of code I changed.

Chuck S · April 7th, 2005, 11:58 AM

Johnny

To my knowledge the query to grab the profile info for a user has not changed. I have stated several times in this thread what you need to do. The issue is that your vb2 profile fields are not stock vb2 fields which we code our integrations to. That would be on you to modify the code to suit your specific hacked needed.

There is not more I can say on this issue. You have posted one problem and I have answered with the proper reply. You would need to examine the query I have noted and seen what fields exist and which ones you have altered or removed.

Michael P · April 7th, 2005, 01:07 PM

Johnny,

Have you looked into the issue that Chuck has pointed out to you? It's possible that we addressed this a long time ago and maybe you forgot? You could compare the vb2.php file from the version you were using to the new one and check for any differences (I use Beyond Compare to compare two files).

Nothing in the vb2.php file changed that would break this query that I am aware of; so you should look closer at what Chuck has been saying as vB2 has a nasty habit of removing fields when you removed a user field from the admin panel. Since we work with a stock version of vB2, we don't have any way of knowing if this field was removed beforehand.

Johnny Doomo · April 7th, 2005, 08:50 PM

Michael P

I updated from 4.0.1 so I didn't have a vb2.php file nor a forum directory. Should I check somewhere else?

In both my 4.0.1 install of gallery if it was suppose to show a location in the replies, then yes I took it out. If you are reffering to did I take it out of the VB forum then yes I did. But if I never had a vb2.php file before, where do I look?

Michael P · April 7th, 2005, 09:00 PM

If you removed it, then you'll need to modify that section of code in vb2.php to remove the reference to the field (lines 122-127 in forums/vb2.php):

Code:

Content visible to verified customers only.

Chuck already posted this above.

Johnny Doomo · April 8th, 2005, 01:34 AM

I added the changed code that he posted to my VB2.php and uploaded it and it did not fix the problem. To double check I made the changes you just said just in case they differed and it's still the same problem: "Invalid login. Please check your username and password, or register."

What else?

Chuck S · April 8th, 2005, 06:25 AM

I showed you where the code block is and a test block to use as the location field is the most common cause.

I have said you need to figure out what you deleted in vb2 and adjust our query accordingly several times if the location field is not it.

Johnny Doomo · April 8th, 2005, 10:39 AM

Quote:

Originally Posted by omegatron

I showed you where the code block is and a test block to use as the location field is the most common cause.

I have said you need to figure out what you deleted in vb2 and adjust our query accordingly several times if the location field is not it.

Once again, if I NEVER had a vb2.php in 4.0.1 how could I have deleted code from it? 4.0.1 didn't have a vb2.php file, so unless it was located in another file I don't know where to go to even begin.