Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By ecore on
Hi!
I forgot the password to my drupal admin account, so i figured i'd just enter PhpMyadmin and create a new user.
What i did was i pressed "Add" in in the "User" table. Bear in mind that I am very new to databases=)
Anyways, i got a couple of forms, example:
Name = (I entered a Name)
Password = (I entered the Password)
Then there were a few other things where the value was set to 0 by default, so i didnt bother changing them, so i added the query to the database.
When i now enter my drupal site it works perfectly, except that i cannot login with my new user, and the following error message is displayed:
user warning: Unknown column 'u.uid' in 'field list' query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2 in /customers/xxxxxxxxxxxxxxm/httpd.www/cms/includes/database.mysql.inc on line 172.
Does anyone perhaps know how i can fix this? I now remembered the password for the admin account, and now i want to redo what i did, and take away the error message =)
Comments
Option 2:<?phpecho
Option 2:
That will output the md5 for a password '123', replace the output in the password field for the original admin, and you are good to go.
I don't have to say that if you do what you did, what happened is what could happen.
Regards.
Geeks Socializing
=-=
Drupal stores the password as MD5, you don't show the query you've used to insert the user and PW. That would certianly help diagnose.
As a last resort to reverse what you've done, import that backup you took before you manually added anything to the DB. You did create a backup before hand ....... yes ?