I installed the Site Site User List module and now user data is not being written to the to the profile_data table and is being written to the user table in a serialized format instead. Additionally, new user data (users who signed up after the module was installed) do not show any profile field data on the Site User List page, but they do show the data in their account pages.

I have 2 questions:

1.) Is there a way to get data missing from the profile_data table back into it? Perhaps move it over from the user tabel?
2.) Can I get new user data to go into the profile_data table?

Thanks, Moses

Comments

pukku’s picture

pukku commented

Hi! Does it look like http://drupal.org/node/119114 might be the source of your problem? Site User List can't really cause these problems — in order to affect the data saved, I would need to implement hook_user, and I don't...

Ricky

flamingvan’s picture

flamingvan commented

I saw that node. The problem occurred the same day I installed the Site User List module, which seems like an unlikely coincidence. But maybe...

flamingvan’s picture

flamingvan commented

I applied the patch from that page. Now data is going into the profile_values table, which is great! But new users still don't show the values on the Site User List page.

pukku’s picture

pukku commented

Hi! If you are using MySQL < 5.0, or have selected to use a table rather than a view (not refering to the Views module, but an SQL view) for some reason, you will need to regenerate the table every time any changes (such as new users or changes in data) are made. This is why, if you have MySQL >= 5.0 (or PostgreSQL), I suggest using a view.

Ricky

Microbar’s picture

Microbar commented

Hi, I'm not a developer but I hope this observaetion will be of use to one.

I also have had this problem, I found purely by accident that if one goes to the view personal data page and clicks submit then when site user is run again the dat is now there. Please help!

pukku’s picture

pukku commented
Assigned: Unassigned » pukku

Hi! This is because of the issue at http://drupal.org/node/119114. You need to apply the patch located there, which will fix the problem with profile.module. Then data will properly get put into place for site_user_list to be able to use it.

pukku’s picture

pukku commented
Status: Active » Closed (fixed)

This isn't really a problem with Site User List...