User (admin user) unable to login

jstubbs2 · February 8th, 2006, 10:09 PM

Hello,

A client has PP 4.66 running. Yesterday for some reason he is unable to login. I checked the MySQL table and the users table is now empty. I tried adding a new user via phpMyAdmin but 4.66 does not see the new user.

Possibly this is because of the cookies I previously deleted just to be sure it was not a cookie issue.

In the login screen there is a "register" link that points to profile.php, which does not exist. I thought it could have been deleted, and checked the original 4.66 folder, and it is not there either.

Any ideas on what to do now?

Thanks.

Chuck S · February 9th, 2006, 08:51 AM

register.php points to register.php is you are using a standalone install

How about what type of integration you using and a link?

If you register a user via the registration script and then via phpmyadmin change his usergroupid to that of admin groupid you will have an admin but of course the registration depends on what integration type.

I would instead see if you have a mysql backup and restore the users table.

jstubbs2 · February 9th, 2006, 10:05 AM

Thanks for the reply. Here is a link: http://www.solborg.fhs.no/album/

I backup the database every day and looking back, it seems the database must have become corrupted somehow. In my backups, the users table is always empty.

The issue now is what to do. I created a new user in phpMyAdmin (because I could not do it via the register script) and assigned group user status to 2, or an admin.

I still can't login. Its a bit strange.

There is only one user, that is the admin who runs the album.

Its a stand alone 4.66, and does not integrate with any forum software or forum user tables.

jstubbs2 · February 9th, 2006, 10:11 AM

Sorry, forgot to say that the register link does not go to the right place. For some reason it goes to http://solborg.fhs.no/gjestebok/prof...?mode=register instead of http://solborg.fhs.no/album/profile.php?mode=register

At least, http://solborg.fhs.no/album/ is the correct URL. I don't know why the link is wrong, the album works fine otherwise.

Chuck S · February 9th, 2006, 10:31 AM

You still did not answer here what forum your intergrating with?

However I know your integrating with phpBB so your users table should be empty in photopost

You need to ensure your pointing Photopost to the proper url to the phpbb forum you are integrating with. It seems you have not done this or changed this.

If you use PHPMYADMIN view the settings table entry 7 and place the proper url to your phpBB forum

jstubbs2 · February 9th, 2006, 10:36 AM

Hello, I said earlier that this site does not use ANY forum software. It did previously (phpBB2 as you said), but not anymore. In fact, not for several months and it has been working correctly.

I still have the phpBB2 database backed up, I could put it back up I suppose.

Is there a way to have PP run by itself? Sorry if the question is bad, but to be honest I put PP up on this site a couple of years back and have not kept up to date.

jstubbs2 · February 9th, 2006, 10:42 AM

mmm...the site now uses punBB forum, but I don't think we integrate it into PP in any way...let me check what we do with that..

Chuck S · February 9th, 2006, 10:53 AM

Well there is your issue. You installed photopost with phpBB integration then deleted phpBB

Photopost has no users etc since your integrating with phpBB and it does not exist anymore.

jstubbs2 · February 9th, 2006, 11:04 AM

Thanks Chuck I figured that out after your previous post. I have now re-installed the old phpBB2 database where it was before, and also pointed PP's config.inc.php variable:

$database_bb="myoldphpBB2";

to the correct database.

Still can't login! Wonder what I am missing. phpBB2 is not installed - only the old phpBB2 database..

jstubbs2 · February 9th, 2006, 11:06 AM

Question: I removed phpBB2 because punBB was smaller and suited the client better. punBB has a tool to insert all phpBB2 data which we used.

Does PP support punBB forum? Could I integrate PP with that?

Chuck S · February 9th, 2006, 11:45 AM

No we do not support punBB

Check your phpBB database that the user exists and is admin. Check your settings table in photopost as it should say phpBB2 in setting 41

As long as your integrating with phpBB and the database user exists you should be able to login and authenticate. Also phpBB must be installed on the server if you want the program to operate correctly.

Otherwise you would need to change the variables in the settings table to an standalone install photopost and realign your usergroups table and create an admin user insert in our users table. Probally best to start over and reinstall if your not going to integrate with phpBB anymore.

jstubbs2 · February 9th, 2006, 11:57 AM

Thanks for the help. I think a re-install would be best, as we are unlikely to use phpBB2 again. This version of PP is 4.66 - if I re-install, would it overwrite the current PP database?

Chuck S · February 9th, 2006, 12:47 PM

well if you do a reinstall you cant keep the pics since they belong to users that do not exist anymore so just wipe everything and start over.

I woiuld suggest you download 5.3 as there are alot of security fixes that have taken place in the past two years.

jstubbs2 · February 9th, 2006, 08:57 PM

Chuck - to download 5.3 I have to renew the licence for $39 is that right?

If I install 5.3 over 4.66 will I lose the photos too? The client has 1,435 images! I don't think he will be too happy at having to upload them again...

Quote:

Otherwise you would need to change the variables in the settings table to an standalone install photopost and realign your usergroups table and create an admin user insert in our users table. Probally best to start over and reinstall if your not going to integrate with phpBB anymore.

Would the above work better if we don't want to re-install? Would you mind explaining how to make a standalone install in the settings table (which variables need to be changed and to what)?

How does one realign the usergroups table?

I appreciate the help.

Chuck S · February 9th, 2006, 10:29 PM

Well your images are going to be all anonymous photos. Your users are gone.

Your lost unless you can write an import script to import the phpbb users table into your photopost users table.

Then you can realign to a standalone install.

This is an example of how to change an integration but you still need to solve your issue above with no users existing.

changing BBS need advice

jstubbs2 · February 10th, 2006, 09:15 AM

Thanks for the responses but I am not too clear on the options, so let me see if I read you correctly:

1. I re-install PP 4.66. If I did this, would I lose the photos or does the setup process remove them?

2. I renew the PP licence and upgrade to PP 5.3. Would I lose the photos? The users does not matter - there is only one user - the admin. So, I could create one user and even if the old images are not assigned to him it does not matter

3. I install phpBB2 again, and re-import the old phpBB2 data into the phpBB2 tables. Would that work.

I don't care what happens to the old user (he's gone anyway). The main objective is to see if I can keep the old images while upgrading.

If I did that, would I be able to assign all the old images to the new user?

Sorry if I am asking the same question, but I really could use some clear advice on what to do with the current album which has 1435 images.

Thanks again.

Chuck S · February 10th, 2006, 10:01 AM

Well you could do this.

1. upgrade your 4.66 version to 5.3

2. realign it to use Photopost as the standalone via the switch integration settings link.

3. create a user account and in phpmyadmin make the usergroupid 5 that will be your admin account

4. Issue a query in phpmyadmin on the photos table to set the userid of all photos to the userid of the admin user.

UPDATE pp_photos SET userid = SOMEID

jstubbs2 · February 10th, 2006, 10:30 AM

Hi Chuck,

Appreciate the support. I renewed the licence already, once the membership is updated I can download 5.3 and see how it goes.

Quote:

realign it to use Photopost as the standalone via the switch integration settings link.

Is that an option when upgrading?

Chuck S · February 10th, 2006, 10:43 AM

No it is not. That is why I linked a post here to the steps you need to manually do. It is never an option to switch integrations.

jstubbs2 · February 11th, 2006, 11:16 PM

Chuck, that was hard work. Thanks for the help. I got all sorts of errors with the upgrade, such as when a /forums/.php file was not found.

I fixed that by reading the upgrade.txt file, which says that one needs to run the following script again:
upgrade.php?upgrade=40&step=2&fixvbversion=1

That worked. Then, I tried to create a new user account directly in phpmyadmin. That did not work, so I registered via PP registration system and then edited the user to an Admin account.

Quote:

create a user account and in phpmyadmin make the usergroupid 5 that will be your admin account

This does not work. There are only 3 usergroups:
1. Anonymous, 2. Admin, 3. Regular Users.

Why does the system set a new user to usergroup id of 4?