PLEASE HELP: Activities not showing on contac's activities tab

[rosvain]

Hi,
first thank you for your help.
I am have a problem that I have can only describe by posting screen shots of the issue.
In the first screenshot it can be seen that there are activities for contact isero but when you go to her summary and click on
the activities tab no activities are shown (the tab itself counts 8 activities).

I have searched online, I upgraded to the latest versions of drupal and civicrm.
I am not sure how to proceed.

Please help.
Thank you

[Kurund Jalmi]

I think upgrading to latest stable 4.0.8 should fix this issue.

Hth
Kurund

[rosvain]

 I did,
I upgraded to the latest version of civi 4.0.8.
you can see it in the second screen shot.

Thank you

[Kurund Jalmi]

Oh then I think it might be related to http://issues.civicrm.org/jira/browse/CRM-9408

Kurund

[rosvain]

Thank you so much. I am going to give this a try.
I have never use a patch, I hope it goes well

I'll let you know how it goes.

[rosvain]

quick question:
how does one apply a patch to civicrm?
could you describe the process?

Thank you

[Kurund Jalmi]

this might help:

http://www.cyberciti.biz/faq/appy-patch-file-using-patch-command/
http://jungels.net/articles/diff-patch-ten-minutes.html

( if above does not work, google is your friend )

Kurund

[andyw]

Hi there,

We managed to fix this issue on a site we have running on 3.4.7 earlier. It turned out to be some sort of weird invisible characters (a 'vertical tab' or \v in our case) in some of the Activity subjects that were getting returned which, in turn, seems to break the jQuery code that builds the table.

It may well be a different character in your case - so it might require some further digging around on your part, but I managed to fix this by by creating a custom template for CRM/Activity/Selector/Selector.tpl

and changing (around line 112):

Code: [Select]

cj.ajax( {
  "dataType": 'json',
  "type": "POST",
  "url": sSource,
  "data": aoData,
  "success": fnCallback
} );
to

Code: [Select]

cj.ajax( {
  "dataType": 'json',
  "type": "POST",
  "url": sSource,
  "data": aoData,
  "success": fnCallback,
  "dataFilter": function(data, type) { return data.replace(/\v/g, ""); }
} );
That should strip out any \v characters before the data is processed - but like I say, it may be a different character in your case - or maybe a different issue altogether, but it sounds very similar, so I'd say that was certainly something to look into.

Also, removing these characters from the data in the database via some sort of query might be a good solution, if they turn out to be the cause.

Hope that helps you in some way!

Andy

[rosvain]

Thank you. that make a lot of sense.

I am going to give it a try.

Thank you again

[marktuma]

I'm having this problem on a 4.08 installation.  I've tried both the suggestions listed here, but unfortunately with no result.  Can anyone suggest any other solutions?

Cheers,
Mark

[andyw]

Hi there,

Well, a colleague of mine fixed this issue on another site last week (a 4.0.8 one) - it turned out to be a newline character (\n) in one of the Activity subjects in that case. We were discussing how these were getting in there and have concluded, in the case of that site, it's down to the fact we've imported the data from another system - but I suppose if people are potentially pasting Activity subjects in from another document, it might occur that way too?

If it helps, we've used Firebug to display the JSON response, then pasted that into JSONLint.

http://jsonlint.com/

That will show you where any invalid characters in the response are, then you'll probably need to paste that section into a text editor that can show invisible characters to find out what they are.

Hope that helps,

Andy

[rosvain]

I have a solution for this problem, thank you Andy,
in the case of this installation the problem was the javascript file that creates the activity table.

solution:
rename jquery.dataTables.min.js.gz to .gz.back
in this location sites/all/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/

Also check the encoding of the files in there.

Thank you for your help.
Ramiro

[sgchan]

I have the same problem with Activities tab too... running 4.1.1 on Drupal 7. Anyone knows how to resolve this? The tab just seems to be forever loading... the spinning wheel goes on and on, but data doesn't load. Also, the data doesn't load on the Dashboard too.

Firebug is showing "Illegal Character" on jquery.DataTable.min.js

The spinning wheel goes on and on for Group and Relationships too but the data gets loaded.

Help please!

[b0b_z]

Try this
http://forum.civicrm.org/index.php/topic,27203.msg116206.html#msg116206

It seemed to take care of the problem and has been working for several day

Do back up the directory first, just in case