Civi breaks Drupal "My Account" page

[bcobin]

Civi 3.1.1
Drupal 6.15

If Civi is installed, the "My Account" link in Drupal no longer works. In fact, going to user/<user ID> just redirects to the home page, so any User Account page is completely unavailable to view. (Account can be edited by sysadmin, but not viewed.)

With Civi disabled, the site behaves as expected.

When users create Drupal accounts without administrative approval (which is usually the case), they are first directed to their account page to change the system-generated password. With Civi installed, clicking the link takes them to the home page instead. So effectively, this makes new registration impossible.

I've checked URL aliases so that user paths are going to the right place, so I don't think this is a configuration issue - looks like a major problem.

I would classify this as critical. Any ideas? Thanks!

[Donald Lobo]

check:

http://drupal.demo.civicrm.org/user/2

logged in as demo/demo. seems to work there?

lobo

[bcobin]

Yup - it sure does. But I also have one user where the User Account works OK. This account was for testing purposes and I'm pretty sure it was created prior to upgrading Civi - I can't be sure.

I should also note here that I have an almost identical deployed installation that works fine with 3.1.beta5, so I believe this problem was introduced in 3.1.1. It's also not a deployment issue; the behavior is the same on both sandbox and production sites.

Perhaps there's something else that's breaking it in conjunction with Civi - all I can tell you is that when Civi is disabled, the "My Account" link (and corresponding User Account view) work fine. But when Civi is enabled, User account page requests are redirected to the front page, without an error. The only way I can verify that the view actually exists is to disable Civi, at which point everything is normal.

UPDATE: OK - there's no way to check on the Civi sandbox without superadmin access to the Drupal side - do you have additional users and can you access their accounts? On my site (which, until this problem was only a few days away from launch), I have one superadmin and two test users - one of the test users is accessible, the superadmin and other test user aren't.

The one thing that's consistent is this: disabling Civi once again allows access to the user account pages.

If you want to look into this on the deployed pre-launch site, I'm happy to furnish you with the required info to poke around. This is a pretty major issue and there are others who have encountered this - at least one has run into the same problem and disabled pretty much everything until he tracked it down to Civi.

See http://drupal.org/node/629456. Any guidance really appreciated - this is now holding up launch of the site.

I'd say this is pretty serious and specific to 3.1.1 - Thanks much for any help!

(Possibly related: When I first go to Civi, I get an "You do not have permission to view this contact record. Contact the site administrator if you need assistance" message twice, which goes away once I reload the page.)

[bcobin]

Further update:

On my development sandbox, I saved the database, deleted Civi 3.1.1 and installed 3.1beta5. User accounts worked OK.

I then successfully imported the 3.1.1 database - User accounts were now broken.

I deleted 3.1beta 5 and installed 3.1.1 - user accounts seem OK.

So this looks like something may have happened in the database while upgrading from beta to 3.1.1.

So I suppose my only solution is to salvage what I can from the production install, wipe the production database and re-enter the data, checking user accounts at every step along the way.

If anybody has any idea what db tables and values to look at, any guidance would be appreciated - I've got about 30,000 records in the production install that I'll need to re-import otherwise. Yikes!

Hope this helps someone... life on the (b)leading edge!

[Donald Lobo]

your best bet would be to hire someone from http://civicrm.org/professional/ and get them to take a look / check the DB. Web Access should be able to do this and will save you the manual process time (which will be time consuming and error prone)

lobo

[bcobin]

Doing so now - thanks, Donald!

[bcobin]

OK - I tracked it down:

SUMMARY: Enabling View/Edit Drupal User Account in Custom Profile conflicts with Drupal User page. When user tries to view his/her account (usually from the "My Account" link), user will be redirected to the front page instead.

RESULT: User is only able to enter Custom Profile information upon registration, or not at all.

I would say this qualifies as a pretty major bug. Yikes!

There's no workaround for this, as far as I can see - but hopefully this will make it easier to track down what's going on here.

 

[Donald Lobo]

can you reproduce this bug on demo?

lobo

[bcobin]

Thank for the response!

I see you have View/Edit Profile enabled for several profiles and it doesn't affect user/2 - there's no authorization from the "demo" login to view other users, though, so if the problem arises with other demo users, there's no way for me to tell. (There was one user who continued to work totally fine in my installation.)

It would be useful on your end to see if this problem arises with other test users on the Drupal side - but why do I get the feeling it will actually work for you?

Let me know if there's anything you'd like me to check on my end - I'll be happy to do so. For the moment at least, I can keep working on getting the site launched.

Thanks again!

[bcobin]

ARRGH!

Looks like this has to do with the "Name and Address" profile fields having a default setting of "User and User Admin Only." Rather than the profile simply not appearing on the Drupal My Account page, Drupal User Account view will redirect to the front page instead, which I would classify as unexpected behavior.

Setting profile fields in question to "Public" seems to solve the issue. Hope this helps some folks out...

[lal2017]

I have this same problem on my Drupal install version: 6.14 using CiviCRM version: 3.0 on our production server too. The My Account link redirects you to the front page domain.

I will follow the advice above and see if I can isolate a pattern. This is a big problem. Will test and return feedback based on the above...

...OK...
(1) Disabling Civi version 3.0: I tested disabling Civi. This works. The 'My Account' link begins working as it should. Re-enable Civi and the link re-directs to base domain URL.

(2) Upgraded Civi to version 3.1.3: completed the upgrade, but still facing the same problem.

(3) Set profile fields to "Public": will test and get back.

(4) CiviCRM Home page error:  "You do not have permission to view this contact record. Contact the site administrator if you need assistance. You do not have permission to view this contact record. Contact the site administrator if you need assistance. "




 

[bcobin]

There are some major issues with user integration that seem (so far) to have been resolved in 3.1.3.

So rather than try to track down what's happening in 3.0, I'd advise you to back up your database and just upgrade to 3.1.3 and save yourself some heartache. Good luck!

[mervan]

I just experienced the same behavior while trying to give authenticated users My Account access so they can edit their CiviCRM profile (Drupal 6.15/CiviCRM 3.1.3). Clicking My Account sent the user to the default page. But My Account worked fine for the drupal admin user, so I assumed the issue was permissions. For me the solution was going to the profiles settings page, opening the Advanced tab near the bottom, and changing 'Limit Listings to a Specific Group'. It was set to Administrators, which explained my problem.

[Donald Lobo]

Hey mervan:

thats great debugging. Can you please file an issue for this: http://issues.civicrm.org/ That behavior is incorrect and should be fixed. We now know the cause Make sure you point to this forum post, so we can reference it etc

thanx

lobo

[mervan]

Will do. Hope this helps some folks.

---
Issue has been created on Issue Tracker.