CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contacts: Activity table empty but Processing...
Pages: [1] 2

Author Topic: Contacts: Activity table empty but Processing...  (Read 1867 times)

fuerst

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Contacts: Activity table empty but Processing...
June 29, 2011, 06:51:00 am
I'm running CiviCRM 3.4.4 (Drupal). At some of the contact detail pages the following is happen: Although the Activity tab title indicates activities by showing a number greater zero there is no data shown at the Activity tab table. Instead the text "Processing..." will be shown above the table header.

Anyone has an idea about this? Note: There is no Email Processing used.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contacts: Activity table empty but Processing...
June 29, 2011, 11:27:07 am
Try using Firebug to debug this. Open the Firebug console first and then load the tab. You should see the URL that is 'trying' to load the list of activities. Open that URL in a new tab to see if any errors are displayed from the data request.
Protect your investment in CiviCRM by  becoming a Member!

fuerst

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Contacts: Activity table empty but Processing...
June 30, 2011, 08:34:16 am
It's that URL: http://server/civicrm/ajax/contactactivity?snippet=4&context=activity&cid=71
When trying to load I get: Entschuldigung. Ein nicht behebbarer Fehler ist aufgetreten. is not of the type Integer
Same error appears when calling the URL of another contact which has a working Activity table.

Interestingly it's not the data which is missing because in the Firebug console I can see the JSON encoded activity data starting with
Code: [Select]
{"sEcho": 1, "iTotalRecords": 2, . Looks like the processing of that data is not working.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contacts: Activity table empty but Processing...
June 30, 2011, 11:06:05 am
Might be an issue with special characters in the JSON encoded data messing up the dataTables widget. I'd check for differences between the two data sets (one that works and one that doesn't). If that's the issue, would be great if you could investigate a solution - that page uses the jQuery dataTables widget.
Protect your investment in CiviCRM by  becoming a Member!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Contacts: Activity table empty but Processing...
August 08, 2011, 10:16:44 pm
Dave - getting same problem - i get this "Uncaught TypeError: Object [object Object] has no method 'once'" - any clues?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Contacts: Activity table empty but Processing...
August 08, 2011, 10:18:50 pm
and in case it was something peculiar with custom activities i just created a new Individual and logged a Phone Call activity - and bingo same problem - on 4.0,5
« Last Edit: August 08, 2011, 11:20:08 pm by petednz »
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Contacts: Activity table empty but Processing...
August 09, 2011, 03:15:16 am
Peter:

Do you have js / css compression on? If yes can you clear drupal caching. Can you also try clearing files/civicrm/templates_c folder and finally your clear your browser cache.

HTh
Kurund
Found this reply helpful? Support CiviCRM

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Contacts: Activity table empty but Processing...
August 09, 2011, 03:36:44 am
Hi Kurund - site is under development so we do not have either of the below on.
  • Aggregate and compress CSS files
    Aggregate JavaScript files
I have double flushed drupal caches - and tried in an used browser - i can't clear the c_templates due to some permission issue which I will sort tomorrow.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Contacts: Activity table empty but Processing...
August 09, 2011, 03:56:31 am
Ok, if the issue persist ping me on irc

Kurund
Found this reply helpful? Support CiviCRM

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Contacts: Activity table empty but Processing...
August 09, 2011, 07:32:06 pm
Thanks K

Problem was that we had Devel module set to
Display page timer
Display memory usage

And the output from this was somehow stopping the processing - i have turned them off now and it works fine - not sure if this is something that can be avoided or just needs to be recorded some how as a HINT to others.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

ctaylor

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 1.6
  • MySQL version: 5.5.12-log
  • PHP version: 5.3.3
Re: Contacts: Activity table empty but Processing...
August 10, 2011, 01:47:30 pm
I'm having the same problem, but mine seems to be a sql issue. There are no javascript errors but when I check the response in firebug I get the error:

Code: [Select]
[code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_temp_target_contact_f26fe332ba27c1d55f8e54f95c295940 ( activity_id, target_contact_id, target_contact_name )
                  SELECT at.activity_id,
                  at.target_contact_id ,
                  c.sort_name
                  FROM civicrm_activity_target at
                  INNER JOIN civicrm_temp_activity_details_f26fe332ba27c1d55f8e54f95c295940 ON ( at.activity_id = civicrm_temp_activity_details_f26fe332ba27c1d55f8e54f95c295940.activity_id
                    AND civicrm_temp_activity_details_f26fe332ba27c1d55f8e54f95c295940.activity_type_id <>  )
                  INNER JOIN civicrm_contact c ON c.id = at.target_contact_id
                  WHERE c.is_deleted = 0 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
                  INNER JOIN civicrm_contact c ON c.id = at.target_contact_id
' at line 7]

It looks like the error is caused by checking  civicrm_temp_activity_details_f26fe332ba27c1d55f8e54f95c295940.activity_type_id against nothing. Not sure why that would happen though?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Contacts: Activity table empty but Processing...
August 10, 2011, 04:14:56 pm

Can you check your "Activity Type" table for an entry for "Bulk Email"

http://drupal.demo.civicrm.org/civicrm/admin/options/activity_type?reset=1&group=activity_type

Seems like it is missing in your install and hence the bad sql. Can you add an entry for it and see if that fixes the issue

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Contacts: Activity table empty but Processing...
August 24, 2011, 09:36:02 pm
A missing "Bulk Email" caused the same problem for me as @ctaylor experienced. It seems suspicious that such a random event would happen twice, unless there were an underlying bug. <scratch style="head"/>

Ken

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contacts: Activity table empty but Processing...
August 25, 2011, 03:55:19 am
Ken - Sounds like something went amiss during an upgrade. 'Bulk Email' activity type insert was handled in 3.0.alpha1.mysql.tpl - so not sure why it would be missing from some sites ???

A fairly recent "fix" to exclude Bulk Email activities in Activities listings is dependent on that activity type existing (see CRM/Activity/BAO/Activity.php getActivities() from line 758) - hence the missing type is now causing this problem.

I've posted an issue to skip this part of the query if Bulk Email activity type isn't found (and to check for it / insert it in next upgrade if it doesn't exist).

http://issues.civicrm.org/jira/browse/CRM-8728
Protect your investment in CiviCRM by  becoming a Member!

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Contacts: Activity table empty but Processing...
August 25, 2011, 05:39:33 am
Dave,

It's not an upgrade issue for us. It became apparent in a copy of our production data, but not in production.

It may have been that the developer accidentally deleted it, but that seems unlikely.

<shrug/>

Ken

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contacts: Activity table empty but Processing...

This forum was archived on 2017-11-26.