New Strange Problems with Roles

Posts: 21
Joined: 01/12/2008

Hi there,

I'm having some new strange issues with role assignments, and I can't figure out what's happening here.

I did have a working test setup with role as product in Ubercart, which has stopped working yesterday
(I'm not sure why) and I've lost user role assignments.

I've updated Ubercart and dependencies to the latest, but am still having issues.

One strange thing that's happening now is that when logged in as admin, I cannot assign roles or
change a role on an existing user account, or assign a recurring role manually.

It will update the status, but not actually assign the role.

The only way I can get any role assigned is to manually create a new user with a selected role.
Once that is done, if I change that user role to a different type, the account loses all custom
roles (I assume it still has authenticated user status).

I know this may not be an Ubercart problem, but I'm wondering if anyone else has ever experienced this?

My Workflow-ng rules have also stopped working, and my test orders get stuck on pending as well.
I'm trying to get the roles problem sorted first to see if this is causing the workflow problem.

If I manually update the Ubercart order status, the role still does not get assigned.

If anyone can point me in the right direction it would be appreciated.

Cheers,

TC44

(Drupal 5.7)

Posts: 5269
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Can you confirm your Ubercart version? I know we had to fix a bug related to early expirations a while back... Puzzled

Posts: 21
Joined: 01/12/2008

Hi Ryan,

It's the 5.x-1.0 release from the project page, updated today.

I had the same problem though before updating Ubercart, and I had noticed the lost roles yesterday.

Thanks for your help.

Posts: 21
Joined: 01/12/2008

I've done some testing, and found that the drupal users_roles table is not updating properly when changing or adding a user role from the admin backend
(if the role is assigned when a new user is created manually, it shows up, but disappears once you add or reassign the role for that user).

If I add the entry manually into the uid and rid columns in the users_roles table, it will show the assigned role in admin in the users list (admin/user/user).

I realize that this isn't an Ubercart issue, but it probably would explain why my workflow rules for product roles stopped working.

I'm at a bit of a loss as to what to try in order to fix this. Does anyone have any suggestions?

Cheers,

TC

Posts: 1293
Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

There's nothing in Watchdog? Perhaps some error messages from Roles or something that might be helpful?

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

Posts: 5269
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Yeah, that is curious... I don't have any experience w/ that not working as expected. Do you have any steps I can follow to reproduce, and/or are there any related issues in the d.o issue tracker for Drupal?

Posts: 21
Joined: 01/12/2008

Hi guys,

There's no indication in watchdog that anything is wrong. The only message is

content (date) usernode: updated (Username).

According to watchdog everything looks fine, but it doesn't take the changes.

I spent the day yesterday rebuilding everything on a clean database, and exported views, etc. from the problem site, and basically have things where they were, and everything works fine on the rebuilt site.

I haven't enabled and configured Ubercart yet, so that's the next thing on my list.

I've been doing db backups at every stage, so I should be able to track down where the problem started if it happens again this time.

Cheers