Hi all,

Nevertheless, yesterday I have upgraded my website to development version of Drupal-5.x, I do not think my issue has something with stability or instability of Drupal versions. Rather it is related to profile module itself.

The problem is that profile module does not list all the users from the same country, but only one user. I have several users on my website from the same country and I have checked their profiles and made sure they had chosen the same option (same field of profile module), but when you try to list all the users from that country it lists only one user.

I had pressed update.php yesterday, but did it again today hoping that something did not go well with upgrading process. Also looked in the logs - the system does not show anything related to profile module and the problem.

I wonder have other Drupalers happen on the same issue and what could be the reason and solution?

Comments

dldege’s picture

Just to rule out the easy stuff - are you sure all of the users have been logged into the system? The profile module will not show users who have a access = 0 or status = 0 (never logged in or blocked).

Can you roll back to a previous version of profile.module to be sure the problem is isolated to the newest version?

Just a couple ideas.
dLd

yngens’s picture

dldege, thanks for suggestions.

Yes, I am sure all the users have been logged and active in the system. Actually, I got complain from an active user about why he could not see himself in the list.

You can take a look at this page that was supposed to show all the users from Israel: http://www.kyrgyz.us/profile/user_from/Israel It only shows one user. But if you take a look at http://www.kyrgyz.us/user/nami_el or http://www.kyrgyz.us/user/gregory_mezentsev you can see both are from Israel too.

It is strange that other country listings show more than one user, but I am not sure if all other country listings really show correct number of users, because we have many users and we need to count to find it out.

And we can not roll back, because the previous version was 4.7 and we totally have transferred to 5.dev.

VM’s picture

you can roll back if kept backups. but you shouldn't have to go all the way back to 4.7.

you were supposed to upgrade to 5.0 before going to 5.1 for a pain free upgrade. see the upgrading tip on release link on front page. you don't specify which version of 4.7.x you were uprading from.

Upgrading into a dev environment, wouldn't be the best thing to do especially on a production environment.

yngens’s picture

Well, we have backup of 4.7, but it will be real headache for us to install it back. Everything except this issue is functioning on the website and we really do not want to switch back because of a single problem. I just hope that we can somehow find solution without switching back.

We actually went trough 5.0 to 5.dev skipping 5.1. Were we supposed to go through every version? As for 4.7.x I really do not know the exact version, but it was one of the earlier versions of 4.7. Do you want to imply that we were supposed to go through every version of 4.7 and 5.0?

I know VM that it is not the best idea to upgrade into dev on production site, but we decided to take that risk. Well, maybe we are paying for that risk now, but everything else is working well. And only this issue makes pity.

dldege’s picture

did you check your status report

admin/logs/status

and make sure it says your database schema is up to date - if not, run update.php.

Is this only happing for your 'user_from' profile field or other fields too? Is it just for term "Israel"?

Sorry not being much help.

dLd

yngens’s picture

dildege, as I said above logs do not show anything related to profile or close modules. Yes, I clicked update.php.
as for second question i am not sure. i am clicking profiles at different categories, all seem to work. i do not think that it is only for Israel, i guess other countries listings also missing some users, but we couldn't identify them yet. this i really weird problem i ever met using drupal

VM’s picture

the -dev tarball was rerolled last night, i'd update to it, to see if problem still persists , or if bug was worked out of the -dev of Feb 2.

yngens’s picture

Ok, we will try to upgrade in a week time. Can not sooner. But we have found out that if to go to Personal Information page of the missing a country list) user and without changing anything to update that page (to press send button) then that user appear in a country list. I guess we have real problems with database tables for profile module. Something not being updated.

huizache’s picture

I am having the same problem with users not showing in profile field pages, although they are logging in.

This is with a fresh 5.1 install.

It is affecting other modules i have now disabled: avatar and usernode.

yngens’s picture

huizache, before your post i believed that something went wrong with update. now i am starting to suppose there could be an error in 5.X. After all, it has not been thoroughly tested. If that is the case, we need to find and have it corrected for the benefit of the whole community.

huizache’s picture

what can we do to fid the bug? report it first? I wanted to report it before I found your own post, but did not find where to post the bug for profile. I know where to report bugs for drupal, but no option for plain profile was available.

huizache’s picture

sorry double comment post

VM’s picture

the profile module is listed. to get to it

submit issue
submit against project: Drupal

next form:
choose the component dropdown menu and select profile.module toward the bottom of the list

David N’s picture

For Drupal.org, if I view my profile, I can choose my country and gender, which are then highlighted on my profile page as clickable links that lead to a page with an array of other members who have selected the same state or gender.

I tried creating a dropdown list for my user profile page, titled "instant messenger client" and then populating it with various options, like AIM, MSN, ICQ, etc. If I understand everything correctly, when I choose AIM as my IM client, shouldn't AIM show as a link on my profile page? From reading through this thread, it appears I am having the same issue. (I'm using 5.1, updated from 5.0)

---
David N
http://www.autoconcourse.com (coming soon)

paulcoghlan’s picture

Hi, new Drupal user here so excuse any noob errors. I am pretty sure this is the exact issue though.

When a new user registers they have certain fields which are presented to them at the point of registration, others can be filled in post-registration. This is configurable within Administer/Profiles.

Regardless of what profile fields are filled in at the point of registration all of the data is put into the 'dru_users' table into the 'data' field, much like the example below.

a:13:{s:13:"profile_fname";s:6:"Sharon";s:13:"profile_sname";s:7:"Smith";s:16:"profile_hometown";s:9:"New York";s:13:"profile_state";s:17:"New York";s:15:"profile_country";s:14:"United States";s:16:"profile_homepage";s:0:"";s:11:"profile_dob";a:3:{s:5:"month";s:1:"8";s:3:"day";s:2:"13";s:4:"year";s:4:"1970";}s:17:"profile_pportrait";s:19:"I live in New York City";s:21:"profile_education_era";s:5:"1970s";s:20:"profile_first_school";s:8:"New York College";s:21:"profile_second_school";s:9:"New York Univeristy";s:15:"profile_college";s:4:"No College";s:7:"contact";i:1;}

At this point you can click on domain.com/country to see members living in the United States and this member will NOT be listed. The reason is that the query for domain/country pulls data from dru_profile_values.

However, once Sharon goes to 'My Account' AND Edits/Saves it the data is moved from dru_Users to dru_profile_values, like below.

10 13 New York
12 13 New York
8 13 Smith
7 13 Sharon
11 13 United States
4 13 a:3:{s:5:"month";s:1:"8";s:3:"day";s:2:"13";s:4:"year";s:4:"1970";}
9 13 I live in New York City
13 13 1970s
6 13 New York College
20 13 New York University
21 13 No College

Note that the data is ONLY moved per category saved. So, if she goes into Edit and selects the Education category then when she saves it (the Education category) the data will be moved from the dru_Users to dru_profile_values ONLY for the Education fields. She does NOT have to change any values, the act of saving it moved the data between tables.

I will do a little more testing but I am pretty sure this is the probolem. Unfortunately I am not a coder so I cant help with the solution!

FYI I have posted this to the Core Drupal Development forum at http://drupal.org/node/119067.

Paul

sepeck’s picture

Follow the instructions in this comment rather then the forum. More of the right people will see it in the issue queue then will see it in the forum.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

paulcoghlan’s picture

Thanks Steven, now posted at:

http://drupal.org/node/119114

Paul

yngens’s picture

Dear Paul,

Thank you for figuring out the source of this problem. Now I quit torturing my updated site and wait until Drupal gurus solve this problem.