CPG integration with IPB

[kegobeer]

You will have to use a tool like phpMyAdmin to manually change usernames and userids for personal galleries, images, comments, etc to match the bbs userids and usernames.

[Geeck]

That's the problem!
I've changed MY user_id in "cpg_users" table to match this from forum's database. The "user_name" is the same in both databases. After this it still wrong! That's what i'm saying all the time. But GauGau said that Coppermine database is no longer used after bridging for that... All this is weird for me.

[kegobeer]

No, no, no, no.  You have to change the userids associated with the pictures, albums, etc, not the ids in the user table.  That means going thru the pictures table and manually changing the uid for each picture.  The same goes for albums.

[Geeck]

Now this makes sense... but I have sooo many numbers to change My God

[kegobeer]

Dump your bbs user table and your Coppermine user table.  Crossreference the userids.  Use phpMyAdmin to execute a query like this:

Code Select Expand


UPDATE TABLE cpg142_pictures SET uid=10099 where uid=10005


You will also have to update usernames where applicable.  As always, backup your database before proceeding.

[Geeck]

I must do:
* albums
* pictures
* comments

Is that all?

[kegobeer]

The comments table is author_id instead of uid.
There's nothing to change in the albums table, since they are assigned to categories.  You'll have to change the categories table's owner_id.
The favpics table is user_id.
The pictures table is owner_id and owner_name.

Several tables have a md5 hash applied to the owner_id/author_id - nothing to do about those.

Backup, make the changes, and see what happens!

[ISBB]

If anyone can get ahold of GeorgeCC he did a re-direction work around for me..   This is w/ 1.3 and ipb 2.1.3

[Geeck]

kegobeer: OK. I'll try today and tell if it helps.

[Geeck]

kegobeer: I've changed everything in database. Now it works perfectly! Thank You very much

Is it possible to use Coppermine User manager after bridging? At least to see currently used quota. Right now I don't have any possibilty to check that.

[Joachim Müller]

"one issue per thread"!

[Geeck]

Yes... all those issues concerns bridging.

[Joachim Müller]

different issues though. Locking this thread.