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) »
  • Contact Activity Tab Shows Correct Count But Table Empty
Pages: [1] 2 3

Author Topic: Contact Activity Tab Shows Correct Count But Table Empty  (Read 6246 times)

crotech

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.04
  • CMS version: Drupal 7.4
  • MySQL version: 5.02
  • PHP version: 5.3.2
Contact Activity Tab Shows Correct Count But Table Empty
July 22, 2011, 12:45:30 pm
When I view a contact (doesn't matter what contact type), the table on the Activities tab is empty. It doesn't appear to matter what contact type or activity type. Firebug gives an illegal character error in jquery.dataTables.min.js?lndg11

Pics of activities screen and firebug error attached.

Thanks for any help.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contact Activity Tab Shows Correct Count But Table Empty
July 22, 2011, 03:35:00 pm
If you use the Firebug Console tab - you'll see the ajax request URL - and clicking on that should give you the data returned by the ajax request which MIGHT give a clue. I did some searching on that error and seems like it might be character encoding related ?? The table is rendered using the jquery DataTables plugin - so you might also research more with that project (they have a forum at http://www.datatables.net/forums/).
Protect your investment in CiviCRM by  becoming a Member!

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: Contact Activity Tab Shows Correct Count But Table Empty
July 25, 2011, 03:34:00 am
Can you also try clearing browser cache and deleting templates_c directory.

Hth
Kurund
Found this reply helpful? Support CiviCRM

crotech

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.04
  • CMS version: Drupal 7.4
  • MySQL version: 5.02
  • PHP version: 5.3.2
Re: Contact Activity Tab Shows Correct Count But Table Empty
July 26, 2011, 12:51:37 pm
More information:

The illegal character error occurs on loading the contact view page and before accessing the Activities tab. According to Firefox, the page is utf-8 but the js file is ISO-8859-1. A second error occurs when trying to view the Activities tab:

cj("contact-activity-selector-" + context).dataTable is not a function. This same error was reported and fixed for dashlets in another thread on the forum but that post doesn't contain any details of the fix. http://forum.civicrm.org/index.php?topic=19538.0

As a test, I set the character set of js files in my .htaccess file:


Firefox reports the file is utf-8 but the error still persists. I have attached a screen shot of the first couple of lines of the file with the encoding shown in Firefox.
 
I have deleted the c_tempates directory and cleared the cache with no change.

crotech

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.04
  • CMS version: Drupal 7.4
  • MySQL version: 5.02
  • PHP version: 5.3.2
Re: Contact Activity Tab Shows Correct Count But Table Empty
July 26, 2011, 02:29:01 pm
More info:
It has something to do with the gzipped file. If I rename jquery.dataTables.min.js.gz to .gz.back, the page loads the .min.js file instead and all is well with the world again.

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: Contact Activity Tab Shows Correct Count But Table Empty
July 27, 2011, 04:00:12 am
Can you change your theme to garland and check if it works?

Kurund
Found this reply helpful? Support CiviCRM

ouyang1512

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.12
  • MySQL version: MySQL 5.1.52
  • PHP version: 5.3.6
Re: Contact Activity Tab Shows Correct Count But Table Empty
February 15, 2012, 08:16:18 am
I am having the same issue here. The activities table in "View Contact" has no any records show.
And the other issue is the "activity report" throws me a "Fatal error: Call to undefined function cal_days_in_month() in /usr/local/apache2/htdocs/mysite/sites/all/modules/civicrm/CRM/Utils/Date.php on line 1056"

Any suggestions/work around would be really appreciated!

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: Contact Activity Tab Shows Correct Count But Table Empty
February 15, 2012, 11:33:36 am
Quote
I am having the same issue here. The activities table in "View Contact" has no any records show.
And the other issue is the "activity report" throws me a "Fatal error: Call to undefined function cal_days_in_month() in /usr/local/apache2/htdocs/mysite/sites/all/modules/civicrm/CRM/Utils/Date.php on line 1056"

This error might be related to php version / settings. May be google for "Fatal error: Call to undefined function cal_days_in_month()"

HTh
Kurund
Found this reply helpful? Support CiviCRM

ouyang1512

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.12
  • MySQL version: MySQL 5.1.52
  • PHP version: 5.3.6
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 08, 2012, 02:44:12 pm
Thanks much for your advice! I am going to check with my admin for the calendar issue.

Can you help me with the empty activity issue? I could not get the contacts' acivities listed when I view the contact's summary and could not figure out what's wrong. The log messages in drupal report are:
Quote
/usr/local/apache2/htdocs/citymatch_drupal7/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 296
/usr/local/apache2/htdocs/citymatch_drupal7/sites/all/modules/civicrm/CRM/Utils/Type.php, fatal, 193
/usr/local/apache2/htdocs/citymatch_drupal7/sites/all/modules/civicrm/CRM/Activity/Page/AJAX.php, escape, 186
, getContactActivity,
/usr/local/apache2/htdocs/citymatch_drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php, call_user_func, 194
/usr/local/apache2/htdocs/citymatch_drupal7/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 454
, civicrm_invoke,
/usr/local/apache2/htdocs/citymatch_drupal7/includes/menu.inc, call_user_func_array, 517
/usr/local/apache2/htdocs/citymatch_drupal7/index.php, menu_execute_active_handler, 21

Thanks much!

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 17, 2012, 09:44:31 am
Quote from: crotech on July 26, 2011, 12:51:37 pm
More information:

The illegal character error occurs on loading the contact view page and before accessing the Activities tab. According to Firefox, the page is utf-8 but the js file is ISO-8859-1. A second error occurs when trying to view the Activities tab:

cj("contact-activity-selector-" + context).dataTable is not a function. This same error was reported and fixed for dashlets in another thread on the forum but that post doesn't contain any details of the fix. http://forum.civicrm.org/index.php?topic=19538.0

As a test, I set the character set of js files in my .htaccess file:


Firefox reports the file is utf-8 but the error still persists. I have attached a screen shot of the first couple of lines of the file with the encoding shown in Firefox.
 
I have deleted the c_tempates directory and cleared the cache with no change.



I have the exact same problem on my Civi 4.1.1. What's frustrating is it works on my MACBook/MAMP (running latest Drupal) but not on my production server. Even more weird, it works on Safari but not on Chrome nor Firefox!

I have cleared the cache and template_c but that didn't work. Also changed the gz file to .gz.back but that too didn't work.

Desperate need of help please??
« Last Edit: March 18, 2012, 09:01:01 pm by sgchan »

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 18, 2012, 09:11:01 pm
Could someone advice on how to trouble shoot missing data in Activity tab please?

Firebug is giving "Illegal Character: ��nMjquery.dataTables.min.js" even when I do a "Find Contact". Ironically, it works find on my local machine but not the production server.

Any help is much appreciated.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 19, 2012, 03:49:22 pm
Have you tried doing a Google search on that error message, and also searching the forum for the dataTable plugin?
Protect your investment in CiviCRM by  becoming a Member!

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 19, 2012, 04:42:01 pm
Quote from: Dave Greenberg on March 19, 2012, 03:49:22 pm
Have you tried doing a Google search on that error message, and also searching the forum for the dataTable plugin?

Yes, I even downloaded the plugin to overwrite the existing (the same version) in the system. The weird thing is it works on my MAC laptop. Even weirder is it works on Safari but not Firefox and Chrome. Anyone with hints on how to troubleshoot this?

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: Contact Activity Tab Shows Correct Count But Table Empty
March 19, 2012, 07:12:49 pm
Can you confirm your local and production CiviCRM versions are same.

Kurund
Found this reply helpful? Support CiviCRM

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 19, 2012, 09:04:55 pm
Both are 4.1.1. Both on same Drupal 7.12 version. Only difference is localhost is a MAMP and production is a Linux CentOS.

Would it be too much trouble to ask if you could look at the site? It is http://cms.iriturkey.org using admin/password. It has sample data only.

Incidentally, the sandbox does not have that problem too. So I am puzzled.
« Last Edit: March 20, 2012, 08:28:21 am by sgchan »
Pages: [1] 2 3
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contact Activity Tab Shows Correct Count But Table Empty

This forum was archived on 2017-11-26.