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]   Go Down

Author Topic: Edit Image-Owners after phpBB-Integration  (Read 15496 times)

0 Members and 1 Guest are viewing this topic.

Loewenherz

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
    • Wolke23 - Webdesign und Suchmaschinen-Optimierung
Edit Image-Owners after phpBB-Integration
« on: September 24, 2005, 12:27:18 pm »

Hi,
the integration from Coppermine in phpBB seems to work fine. I know: "If your coppermine users have already created private albums and uploaded pics to them, they will be lost as well!" But I think, it's not really necessary. The private albums are existing. Only I have to do, is to change the owner of the private album. But how? With phpMyAdmin I found in the table cpg-albums the table "category". Entries are like "10002". If the old uid is "2" and the new phpbb uid is "17", I have to change this entry to "10017"?
And I want to change the user-id from old fotos in the database. Okay, this seems easy: i change the owner-id in cpg-pictures. The owner-names are correct.
« Last Edit: September 30, 2005, 08:52:28 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Edit Image-Owners after phpBB-Integration
« Reply #1 on: September 26, 2005, 07:51:34 am »

That's not new, but well known, especially to the devs. Has been discussed before. Needs manual editing though, which means it's only an option for smaller coppermine installs with a small amount of user ids that need to be converted. We chose to not make things more complicated for newbies by simplifying things in the docs, so we said that the users will be lost when bridging. However, thanks for your effort to share your thoughts with others.
Logged

Loewenherz

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
    • Wolke23 - Webdesign und Suchmaschinen-Optimierung
Re: Edit Image-Owners after phpBB-Integration
« Reply #2 on: September 26, 2005, 09:27:43 am »

I solved the problem on Friday and will post a HowTo on phpbb.de in german language for Newbies.
Logged

Loewenherz

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
    • Wolke23 - Webdesign und Suchmaschinen-Optimierung
Re: Edit Image-Owners after phpBB-Integration
« Reply #3 on: September 29, 2005, 11:48:55 am »

There's the HowTo: http://www.phpbb.de/viewtopic.php?t=99113 - sorry, but here is no german language area.
Is my warning at the end of the topic really a coppermine-bug? Or not?
« Last Edit: September 29, 2005, 12:00:57 pm by Loewenherz »
Logged

Nibbler

  • Guest
Re: Edit Image-Owners after phpBB-Integration
« Reply #4 on: September 29, 2005, 03:06:22 pm »

It's been asked before. The system is not 10XXX it's 10000 + XXX so the 10000th user will have the category 20000
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Edit Image-Owners after phpBB-Integration
« Reply #5 on: September 30, 2005, 08:52:08 am »

Loewenherz: everything is correct on your detailed explanation except the last section
Quote
Warnung
Hinsichtlich der fünfstelligen Coppermine-Alben frage ich mich, ob hier nicht eine Art "y2k"-Bug lauert. Wer also phpBB's mit mehr als 10000 Usern betreibt (soll es bekanntlich geben), dem rate ich erst einmal vom Einsatz der Bridge ab, bis er das Problem im Coppermine-Forum geklärt hat oder künftige cpg-Versionen das Ganze anders lösen.
- see Nibbler's explanation. There's no "Y2K"-bug there, there can be an infinite number of users (at least in theory), although I doubt that users will go through the modification if they have 10.000 users, as this'd be very hard to accomplish, even with the instructions you provided.
I made this thread a sticky, feel free to translate your posting http://www.phpbb.de/viewtopic.php?t=99113 into English, it's well-written.
You might want to look into the thread/mod migrate / convert users to phpbb as well.
Logged

Loewenherz

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
    • Wolke23 - Webdesign und Suchmaschinen-Optimierung
Re: Edit Image-Owners after phpBB-Integration
« Reply #6 on: October 04, 2005, 05:29:27 pm »

Thanks for the infos. You can feel free to translate my HowTo in any language. Sorry, I'm not really good for german > english.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Edit Image-Owners after phpBB-Integration
« Reply #7 on: October 04, 2005, 11:05:48 pm »

Thanks for granting permissions to translate, I won't - I'm too busy. Maybe someone else wants to take a shot - would be a nice way to give something back to the community.
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.