Posted by exterminatorx on December 26, 2007 at 10:50pm
I'm wanting to integrate a new install of phpbb-2 with an existing Drupal 5 site. Seems straightforward, but in my case, User 2 on my existing Drupal site happens to be one of site's main contributors. Simply taking over his uid and changing the username/password/email is problematic.
If I could "migrate" my current User 2 to a new uid before taking over User 2 for phpbb integration that would suit me fine. My guess is that it is simply a matter of running one or more SQL scripts. Does anyone have such a script that would allow me to move all content references to uid=2 to a newly created uid?
Surely someone has run into this before when integrating phpbb with drupal. Thanks!
Timothy
Comments
It's not that much work,
It's not that much work, just go through the tables and run something like the following (depending on what the uid column is called, could be owner or poster_id or something):
UPDATE tablename SET uid = 1002 WHERE uid = 2;
There's no formula that will work for everyone, unless they all have the same modules installed.