New user registration

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

I've looked a bit in the forums and I can't find the answer to this. Once the Gallery2 and phpBB2 are integrated, if you are not signed in there is a register link in the Gallery section. Is there a way to redirect the registration link so that it goes to the phpBB2 regsitration screen instead of the Gallery2 registration link?

AdBot

rollins · Novice Joined: Oct 27, 2005 Posts: 23

Where is the registration link? I did not install the Registration module, and I don't see a registration link. Try un-installing the Registration module.

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

So... I deactivated the registation module earlier...
apparently thats not a good idea
the Export Users function is not working any more (even after activating the registration module again)
i get the error:

"The import of the following phpBB2 user_id's failed:
13
The most common reasons for failed imports are:

* Duplicate phpBB usernames
* A phpBB username of "guest"
* A phpBB username consisting of only numbers

Check the failed user_ids and re-run the export"

Any ideas?

rollins · Novice Joined: Oct 27, 2005 Posts: 23

In my upgrade plan, I will only run the sync once. I recommend trying this from a clean install with no registration module. However, if you want to look into this more, here is some SQL which you can run.

Code: ›

connect to you db:

mysql -u USERNAME DBNAME -p

> show tables;

find the name of your gallery user table and your php user table. The name will depend on the table prefix_ you chose on installation for the phpBB2 tables and the Gallery2 tables. The gallery tables also have a column prefix_

> describe phpbbtableprefix_users;
> describe gallerytableprefix__User;

select P.user_id AS "BB ID",
P.username AS "BB Username",
G.gallerycolumnprefix_id AS "G2 ID",
G.gallerycolumnprefix_userName AS "G2 Username"
from phpbbtableprefix_users P,
gallerytableprefix_User G
where P.username = G.gallerycolumnprefix_userName;

You can then see the username of your phpBB user #13

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

In the original integration, is it suppose to be that you only have to sync once or have you modified the code so that this is the case?

rollins · Novice Joined: Oct 27, 2005 Posts: 23

I made some additions to keep the users in sync.

http://www.nukedgallery.net/postt2070.html

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

aaaah cool. I will check it out tomorrow Very Happy

rollins · Novice Joined: Oct 27, 2005 Posts: 23

Tomorrow, I will post the files for the integration with phpBB-2.0.18

dari · Posted: Mon Oct 31, 2005 7:44 am Post subject: Re: New user registration

moogen wrote: › So... I deactivated the registation module earlier...
apparently thats not a good idea
the Export Users function is not working any more (even after activating the registration module again)
i get the error:

"The import of the following phpBB2 user_id's failed:
13
The most common reasons for failed imports are:

* Duplicate phpBB usernames
* A phpBB username of "guest"
* A phpBB username consisting of only numbers

Check the failed user_ids and re-run the export"

Any ideas?

what is the username of your user w/ user_id of 13?

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

user_id 13 is a test user that i created to make sure everything was still working...

the username is: anothertest
i created a few others with varied names that didnt work as well.

when the registration module is activated again... is it not exactly as it was before. Does it change some code that had been altered by the integration file so now the sync doesnt work?

I tried to redo everything that i had done before with the integration with no luck. Confused

dari · Posted: Mon Oct 31, 2005 2:49 pm Post subject: Re: New user registration

is there another user in phpBB that has that username?

moogen · Beginner Joined: Oct 29, 2005 Posts: 14

Nope. The username had never existed before I created it to test the integration out.

Web Hosting India