Big Stock Photo offers nearly 3 million stock photos to choose from - royalty free, starting at $1 per photo. We're able to extend 5 free photo credits to our visitors for a limited time. Click here and use promo code DIR5XM2 when you sign up.
It's easy to setup your own toll free number for as little as $2/ month. Try Kall8 today and get your 800 number. Features include call forwarding, voice mail and fax, caller ID, email notifications, VoIP, and more.
We're going to show you how to update your Drupal user ID without wreaking havoc across your site. If you are comfortable administering your database tables updating a user ID for a particular user is not all that difficult. The key is updating all the tables where the variable for user ID, "uid", takes place. At the time of this writing we were not aware of a Drupal module that automates this process. If you know of one, or are interested in working on one, please post below.
The reason we initially came across the need to change a user ID is due to the fact that we were in the process of embedding a forum installation (phpBB) within Drupal (read our article on integrating phpBB with Drupal for the details). phpBB, for some odd reason, required the use of Drupal user ID #2 as the primary administrator. We therefore had to regain control (and therefore change), user ID #2.
You'll need to update the following tables (using, for example, phpMyAdmin), in order to cover the most common instances of "uid" (if you are using additional contrib modules you'll want to search for additional tables making use of "uid). Important: Before proceeding, as with any database updates, make sure you backup your database in case something goes awry! Once you're ready, execute the following SQL command on the tables below (in this example we're changing user ID 5 to user ID 2). Note: You need to make sure you're updating to a user ID that does not already exist! If the user ID you wish to update to already exists, simply take control of that user and create a new user for the former user. If it does not exist, proceed with the following:
UPDATE node SET uid = 2 WHERE uid = 5;
You'll want to update the tables:
Voila :) If you updated all instances of uid 2 you should see all nodes intact on your site. If you forgot some, you may see instances of "n/a" in place of posts, or modules behaving oddly. If this is the case, restore your backup and find the additional tables utilizing "uid" that need updating via the above SQL command.
All Content © 2005 - 2010 Contract Web Development, Inc. All Rights Reserved. Privacy Policy | Terms of Use | Powered by Drupal
Hi
Nice information provided here which is very useful to everyone...I am not a huge fan of this side, there do seem to be a lot these days...thanks for posting...Let me know more about this one... Elenora