Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: 1 [2]   Go Down

Author Topic: CPG integration with IPB  (Read 14566 times)

0 Members and 1 Guest are viewing this topic.

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: CPG integration with IPB
« Reply #20 on: December 29, 2005, 09:10:36 pm »
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.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #21 on: December 29, 2005, 09:19:01 pm »
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.
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: CPG integration with IPB
« Reply #22 on: December 29, 2005, 09:21:59 pm »
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.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #23 on: December 29, 2005, 09:27:41 pm »
Now this makes sense... but I have sooo many numbers to change My God :)
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: CPG integration with IPB
« Reply #24 on: December 29, 2005, 09:38:18 pm »
Dump your bbs user table and your Coppermine user table.  Crossreference the userids.  Use phpMyAdmin to execute a query like this:

Code: [Select]
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.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #25 on: December 29, 2005, 11:04:22 pm »
I must do:
* albums
* pictures
* comments

Is that all?
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: CPG integration with IPB
« Reply #26 on: December 29, 2005, 11:29:37 pm »
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!
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

ISBB

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 93
    • Northwest ZR2's
Re: CPG integration with IPB
« Reply #27 on: December 30, 2005, 04:00:19 am »
If anyone can get ahold of GeorgeCC he did a re-direction work around for me.. :D  This is w/ 1.3 and ipb 2.1.3 :D
Logged
Its gaurunteed.. until it breaks

Lifted trucks are like boob jobs, no matter what size shape or dimension they are always fun to look at.

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #28 on: December 30, 2005, 08:33:14 am »
kegobeer: OK. I'll try today and tell if it helps.
Logged

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #29 on: January 01, 2006, 04:05:20 pm »
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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CPG integration with IPB
« Reply #30 on: January 01, 2006, 04:37:31 pm »
"one issue per thread"!
Logged

Geeck

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: CPG integration with IPB
« Reply #31 on: January 01, 2006, 04:43:41 pm »
Yes... all those issues concerns bridging.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CPG integration with IPB
« Reply #32 on: January 01, 2006, 04:47:34 pm »
different issues though. Locking this thread.
Logged
Pages: 1 [2]   Go Up
« previous next »
 

Page created in 0.019 seconds with 19 queries.