RP 3.11 - joint registration with PP 5.21

snoopy5 · October 31st, 2005, 09:58 AM

RP 3.11 - joint registration with PP 5.21

Hi

I have one PP5.21 installation and one RP 3.11 installation with only a few users. Now I would like to merge the registration system of both. So the RP registration system shall use the Photopost registration system.

I could make a fresh install of RP 3.11 to do that. It does not matter if those few users get lost.

The only thing that bothers me is to loose the content with a fresh install. The articles and the categories. I would like to keep them. I hate to do this all again.

Is there any trick how to achieve this? I.E. make a fresh install and then delete catogies in phpmyadmin and import that table of my old installation? Same for the table with products?

Any hints are welcome

Thanks in advance

Chuck S · October 31st, 2005, 10:37 AM

Hello since the userid's are prepended to any images there is no way to change the userid so if you do a fresh install the products belong to some one else since most likely the userid are different on this new install

As far as changing integration yes reinstalling and selecting Photopost integration would be fine.

snoopy5 · November 1st, 2005, 10:57 AM

All images are uploaded from admin. would that help?

Chuck S · November 2nd, 2005, 06:23 PM

Well then simply make the necessary integration changes

abd you should be fine

edit the config file and change the settings 41 and 83 in the reviewpost settings table in phpmyadmin

snoopy5 · November 3rd, 2005, 07:30 AM

Thanks, I will try this.

And chuck, you have to go on vacation where no internet is available. Otherwise you will never really have vacations

P.S.: Merger of the english galleries went basically fine. Some minor questions, which I will ask only after you are back from vacation

snoopy5 · November 3rd, 2005, 05:15 PM

mmmhhh,

i did that. the RP 311 shows me no error. So far so good.

But when I want to login as admin, ist sais login successfull, although it did not let me in (same index page as before without the admin access)

If I click on "register" it guides me to my PP521 installation for registration. If I click in RP311 on "members", it only shows me 3 (inkl. admin) although there should be thousands, if shared registration would display both together.

What did I do wrong?

snoopy5 · November 3rd, 2005, 05:45 PM

Just as a side note:

I think it is a cookie problem. In phpmyadmin I looked on the tables 214-216. But I am not suere waht I shall enter there.

Photopost 521 is the master with all users. RP311 shall use this user database. I have currently in the mysql database of RP311:

214: Reviewpost Cookie Path: /
215: Forum Cookie Prefix: photopost
216: Reviewpost Cookie Domain: .barney.com

I have to add that the photopost installation is using a different url on the same server then the RP installation.

What do I need to type in 214-216?

Thanks in advance

Chuck S · November 3rd, 2005, 06:44 PM

Your cookie settings can be whatever although I suggest cookie prefix empty since obviosly internal photopost etc uses no prefix

Now if anything check out your integration

Make sure that the database settings are correct in config file to point to photopost

make sure in phpmyadmin settings 41 says photopost and setting 83 has photopost table prefix entered in settings reviewpost table
if you are integrated in photopost you will show total users

snoopy5 · May 2nd, 2006, 11:36 AM

Hi

I want to make the same integration now with PP 5.3 and RP 3.3.

I had in the past some problems with the integration above, so I switched back to may backup version with no integration

What do I have to pay attention to, if I would try now to have PP 5.3 as the "master" and RP as the "slave".

Both have different urls (gallery.mydomainname.com and reviews.mydomainname.com) on the same server as described above. In RP, only the admin uploaded images. Almost no comments except from 3 person maybe in RP.

I guess tables etc. changed since my old posting 6 months ago with the older versions. Where do I have to do what?

Also I would like to integrate later on an already existing classified installation (after I upgraded it to the newest version). Would that be a problem? Especiall for subscriptions with Paypal?

Thanks in advance

Chuck S · May 2nd, 2006, 12:39 PM

Well integrating an already installed classifieds with photopost would be tough as the users would need to be copied to the photopost users table and users would probally already exist with the same userid so you need to figure how to combat that issue.

As far as integrating with Photopost on a normal install or classifieds or reviewpost you simply install and select external integration and pick photopost treating things on install as an external integration.

Basically to switch an existing site you would do this

1. make sure the users exist in the photopost users table

2. edit the config file to make sure the database info is correct to connect to photopost for user database

3. change settings 41 and 83 to the proper integration type and photopost table prefix for reviewpost and classifieds

snoopy5 · May 2nd, 2006, 03:12 PM

Quote:

Originally Posted by Chuck S

Well integrating an already installed classifieds with photopost would be tough as the users would need to be copied to the photopost users table and users would probally already exist with the same userid so you need to figure how to combat that issue.

As far as integrating with Photopost on a normal install or classifieds or reviewpost you simply install and select external integration and pick photopost treating things on install as an external integration.

Basically to switch an existing site you would do this

1. make sure the users exist in the photopost users table

2. edit the config file to make sure the database info is correct to connect to photopost for user database

3. change settings 41 and 83 to the proper integration type and photopost table prefix for reviewpost and classifieds

o.k. I di that.

In addition I set the paths in admin menu of reviewpost in "Forum Settings" and in "Edit Integration" to the photopost addresses.

It worked for admin, but as expected not for those suers, who have in both installations already an account with the same username, but different "userid" and "group id". Tere are no errors, but if I login, it accepts the login without showing "upload product" etc., so teher is something wrong with it.

But apart of that the shared user registration seems to work, which is good news for me

I tried now to change in the tables of reviewpost afterwards the userid and group id to the equivilant numbers in photopost, but it does not help anymore. The admin was fine, because it has in both installations same userid and group id from the beginning.

My questions are now the folowing:

1. Is there a way to change the userid and group id in RP to the same number in photopost before doing the integration, so that it gets accepted?

2. what happens with users, who are only registered in RP, but not at all in PP? Do they "disappear"? (since they are only in the RP tables, which are not used anymore) - I could add them manually in photopost, but would like to know, whether this causes errors/technical problems

Thanks in advance

Chuck S · May 2nd, 2006, 03:32 PM

As stated you need to make sure all users exist in the Photopost user database. You might need to also change there usergroups to default 4 for any special groups that dont exist in photopost.

Next you can clear every usergroup out of reviewpost and classifieds usergroup table and do a refresh usergroups thing to import the photopost groups and set permission how you want.

snoopy5 · May 2nd, 2006, 08:14 PM

Quote:

Originally Posted by Chuck S

As stated you need to make sure all users exist in the Photopost user database. You might need to also change there usergroups to default 4 for any special groups that dont exist in photopost.

Next you can clear every usergroup out of reviewpost and classifieds usergroup table and do a refresh usergroups thing to import the photopost groups and set permission how you want.

Hi

Integration of Reviewpost worked.

But not with classifieds.

I did the exact same thing as with Reviewpost for the users and I alos deelted in mysql table all usergroups except admin and did a refresh usergroups in admin of classifieds. But nothing happens. it is still only the admin group there.

What did I do wrong?

Chuck S · May 2nd, 2006, 08:39 PM

I dont know you would need to double check and make sure you did all the steps I noted when switching an integration.

Your using the latest classifieds right?

snoopy5 · May 3rd, 2006, 04:33 PM

Hi Chuck

Yes everything exactly how you described it. It is version 2.5. I even downloaded today the download pack again from your members area and overwrote all old files, to avoid any old bugs til February.

I deleted all users except admin and me. And both users work fine. I tested also registration for new users, worked fine too. so the integration works.

The only thing that does not work is the usergroup update/refresh. I deleted all Usergroups except admin, unreg. users., reg. users, coppa and banned.

I also had me in usergroup 4 (both in classifieds and photopost). So this can not be the reason neither.

I transferred now the whole classifieds installation on a new unknown url. I also created a new mysql table and copied it there. I will send you the link and you can play with it as much as you want to.

Maybe you find something I did not find...

Only pay attention to photopost, since this is a live board

Chuck S · May 3rd, 2006, 04:52 PM

well try making your import usergroups function this in photopost.php in your forums subdirectory of classifieds

Code:

Content visible to verified customers only.

snoopy5 · May 4th, 2006, 12:57 AM

Thanks, that worked. I will do further testing tonight/tomorrrow, but it looks good...

snoopy5 · May 7th, 2006, 06:49 AM

Quote:

Originally Posted by snoopy5

Just as a side note:

I think it is a cookie problem. In phpmyadmin I looked on the tables 214-216. But I am not suere waht I shall enter there.

Photopost 521 is the master with all users. RP311 shall use this user database. I have currently in the mysql database of RP311:

214: Reviewpost Cookie Path: /
215: Forum Cookie Prefix: photopost
216: Reviewpost Cookie Domain: .barney.com

I have to add that the photopost installation is using a different url on the same server then the RP installation.

What do I need to type in 214-216?

Thanks in advance

Hi

For the sake of others (and my memory) I just wanted to do a follow up on my old posting of 3.11.2005 here in this thread. At that time, I did not succeed with the integration between reviewpost and photopost. At that time it was version 3.11 for RP and 5.21 for Photopost. This was another language installation then the one I successfully managed a week ago. So these two integration have nothing to dowith each other, although it is the same subject.

After upgrading, the problem was still present. I deleted all users except admin, and had only the mandatory usergroups etc. So I set up everything the exact same way as last week with the other installation (which went fine).

I could login as admin, got the successfull login alert, but the index page stayed the same (no admin or upload textlink visible)

I went with phpmyadmin into the settings table and deleted all standard cookie paths, which came with the normal installation by default:

#214: Reviewpost Cookie Path: I left this empty (no dots, slashes or whatever)
#215: Forum Cookie Prefix: also empty (if you used standard settings in your photopost installation -> no prefixes)
#216: Reviewpost Cookie Domain: also empty

I do think #216 was the most important one for this problem. At least only after I changed that one, it started to work.

Now the login works perfectly. I will test further later, but I guess there will be no problems anymore.

Chuck S · May 7th, 2006, 08:39 AM

Cookie path must always be set to /

Cookie Domain is best at .domain.com yes because it will work on every subdomain.

snoopy5 · May 7th, 2006, 01:57 PM

Quote:

Originally Posted by Chuck S

Cookie Domain is best at .domain.com yes because it will work on every subdomain.

Hi Chuck,

if I do this, I get again the logout problem. I log out, get the sucessfull logout message but see still the admin and upload photo link and can also enter the admin menu without logging in again.

This is with all installations in English: Photopost, Reviewpost and Classifieds by the way...