By ledelboy on

My upgrade from 4.6 to 4.7.3 wasn't a piece of cake, but it worked mostly OK, with two problems that I can't solve on my own:


1. the user module and/or the profile module are giving me serious trouble.

  • The user's list has vanished. I can't see it even when logging in as user 1
  • Anonymous and authenticated users can't access user's profiles, although they have permissions to do so.
  • Authenticated users with permission to change own username get a page not found message when trying to get their profiles.
  • Visitors are allowed to create accounts, get their account detais by e-mail with a valid link, they can even go to user/xxx/edit and modify their profile, but user/xxx yields a "polite" (drupal formatted) not found page
  • Only admins with permission to administer users can see the profiles

I read a posting about a similar bug and a subsequent issue but I get nothing clear out of them, except that this is an unsolved issue.

Lucky me, My 4.6 version of the site is still working fine. So this won't be a very very big issue

I am pretty sure that this problem has a lot to do with the upgrade, since I have two sites that were born in 4.7 and have no user.module problems at all.

What I don't know is if this issue is related to a recurrent error that is related to users, and has been documented but not explained -in my humble opinion- in several posts:

Message Unknown column 'access' in 'field list' query: UPDATE users SET access = 1160108187 WHERE uid = 955 en la línea 120 del archivo /home/fepalor/public_html/includes/database.mysql.inc.

This happens consistently with every registered user no matter their permissions.

Not being a very technical person, but one of the growing masses of developers who love Drupal, all of this is well above my understanding. What I do understand is that things like this are a big pain for user, specially when they are absolutely non technical, lime my users. They don't feel angry when something doesn't work as it should. Since they assume they know nothing about computers and are more than a little afraid of them, they feel guilty when they face a bug. And I feel that inflicting them such a pain is bad for my karma.

So, my friends, please help!

⋅ Categories: Drupal 4.7.x

Comments

ledelboy’s picture

ledelboy commented

I was not a cookies issue, but a collating issue at the database. 4.6 was Latin 4.7 is utf.
I found a solution that may look too primitive to the tech savvy, but it worked for me
I exported the "users" table
I made a second barebones installation of drupal 4.7 in a different folder (and different MySQL data base of course)
Once set up, I imported a couple of rows of my exported table. It worked
Then I imported more rows and began to get errors. Checked and saw that all of them had NULL int fields. Why? Who knows.
Using BBEdit I put all the lines with NULL in other document
Imported the clean result and worked perfectly.
I dropped the contents of the original users table and copied the contents from the new installation to the old one.
It worked fine. End of story

Arkar’s picture

Arkar commented

Is there a simpler solution to this problem i get it also and profiles are essential to me.