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.
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?
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
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.
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
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.
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?
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.
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.
Please do not PM me for support or sales questions. Thank you for your understanding.
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?
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."