Issues after upgrade 1.9->2.04 (Activities list and Drupal user)

[Laryn]

I recently upgraded 1.9->2.04 and a few issues have surfaced.

Not Solved
* We're using Drupal and since the upgrade, new registrations no longer create the associated Drupal user (they do create the CiviCRM record, however).
* The "Activities" list that now appears at the front page of Civi is confusing -- how did these activities get scheduled? Can we disable that list?

Solved
* There was an issue with the Admin/Configure/Domain Settings which were all default settings after the upgrade. Can't recall if this was here previously and got wiped by the upgrade or if it's a new area that needed to be filled for the first time...either way, filling that in again seems to have solved the emailing issues.

Anyone have a similar problem or some advice on the unsolved issues?

lpkb

[Deepak Srivastava]

* The "Activities" list that now appears at the front page of Civi is confusing -- how did these activities get scheduled? Can we disable that list?

The reason you see those activities could be -
1. There are already some activities in your activity table (which in v2.0.x are also displayed on dashboard) OR
2. There were some activities in your activity-history table which were moved to activity table during the upgrade process.

In 2.0.x there is no way you can disable them via GUI, but you can disable / remove them by doing a small change in the code by commenting / removing the following line from the file CiviCRM/templates/CRM/Contact/Page/View/DashBoard.tpl (line-4) -

Code: [Select]

{include file="CRM/Activity/Selector/Activity.tpl}


We're using Drupal and since the upgrade, new registrations no longer create the associated Drupal user (they do create the CiviCRM record, however).

I tested this on my local install and found it to be working. Can you replicate this problem on demo (http://drupal.demo.civicrm.org/) ? if yes can you give the steps to replicate the same.

[Laryn]

I will try to test the Drupal user on the demo server. In the meantime, our activities list continues to grow. I can use your fix to hide it but want to be sure it isn't something going wrong before I do that.

Here's a message from a user:

the list of activities on the main Civi Admin screen continues to grow and get longer.  I am really concerned about what is going on with this and need to know why this is happening, and what is generating the content that is showing up here.

[Laryn]

I am trying to create a new user on the demo server by logging out, clicking on "Create a new user" under the login form in the left column, and then adding new info. I am getting this error each time, despite using different information, username and email addresses:

Code: [Select]

    Sorry. A non-recoverable error has occurred.

    DB Error: already exists

    Database Error Code: Duplicate entry '128' for key 4, 1062

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id ) VALUES ( 24 ,  128 ,  1 )  [nativecode=1062 ** Duplicate entry '128' for key 4]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id ) VALUES ( 24 ,  128 ,  1 )  [nativecode=1062 ** Duplicate entry '128' for key 4]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id ) VALUES ( 24 ,  128 ,  1 )  [nativecode=1062 ** Duplicate entry '128' for key 4]"]
)

[/code]

[Deepak Srivastava]

I also tried the same procedure for creating the account and was able to create the account there. The message - "Your password and further instructions have been sent to your e-mail address." confirmed this. Looks like you entered some existing mail-ids which resulted in that error.

In the meantime, our activities list continues to grow. I can use your fix to hide it but want to be sure it isn't something going wrong before I do that.

Well activities them self can give you enough details if you look at type, subject, added by ..etc.

[Laryn]

Yep, this time the demo server worked for me.

However, our server still doesn't work. Is it possible the upgrade wiped out Civi or Drupal settings that are required for this? (I tried to walk through all the relevant settings but didn't see anything glaring).

Also, we haven't been adding activities manually -- do they get added to the list automatically at times?

Thanks for all your help and all your work! It is greatly appreciated (by us, and a host of others in the non-profit world, I'm sure).

[Deepak Srivastava]

Upgrade process can only affect civicrm database and civicrm codebase.

However, our server still doesn't work. Is it possible the upgrade wiped out Civi or Drupal settings that are required for this? (I tried to walk through all the relevant settings but didn't see anything glaring).

You might want to check civicrm.settings.php file for appropriate settings, if you haven't already.
 

Also, we haven't been adding activities manually -- do they get added to the list automatically at times?

Yes they also get added automatically on some occasions/events like - sending a mail, contribution, membership signup ..etc.

[Laryn]

Okay, I think I've narrowed things down a little in regards to the Drupal user.

I re-tested the Drupal user signup from Drupal's own registration system and that works fine (it creates a drupal user and a civicrm contact and they are linked).

However, what may not have been clear from my earlier posts is that I am trying to get this functionality through a contribution form, not through drupal's registration page (so that we can have different people get accounts through different contrib. forms with different profiles on them) and that is not functioning. I have the "Drupal user account registration option?" selected in the profile and it shows up with a checkbox on the contrib page, but it still doesn't create the account in drupal.

HOWEVER, I set up a contrib page in the sandbox and it seems to work like it should. Anybody have any advice for me as this is obviously something specific to my install at this point?

EDIT: I should note again, this was working fine before the update (I updated Drupal and Civi at the same time).

[emccaughrin]

Also, we haven't been adding activities manually -- do they get added to the list automatically at times?

Yes they also get added automatically on some occasions/events like - sending a mail, contribution, membership signup ..etc.

I am also seeing very odd behavior with random activites being added automatically. Moreover, these activity entries have corrupted data -- scheduled dates way in the past, garbled Subject field. It looks like unrelated data from other tables are being copied over at random. I don't know if it is related, but I began seeing this happen when I added the UpdateMembershipRecord.php script to the daily cron job.

BTW, we did not do an upgrade. This is for a fresh install.

[Deepak Srivastava]

UpdateMembershipRecord.php does add activity records on every status update.
You can disable the record creation by commenting the lines 508 to 522 in the file CiviCRM/api/Membership.php (no way via GUI).

[Laryn]

NOTE: for 2.0.5 and the Drupal user issue (user not created -- for free memberships specifically), see this thread.