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)

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 20, 2012, 08:24:11 am
Would it be too much trouble to ask if you could check out the site? The URL is http://cms.iriturkey.org using admin/password. It has the sample data only.

This is really really puzzling. I have re-installed EVERYTHING but the problem still persists.

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: Contact Activity Tab Shows Correct Count But Table Empty
March 20, 2012, 08:54:23 am

did a quick check of the site. Seems like in some urls u are using

http://

and in some other urls u r using https://

I would not mix the two. either keep all http:// or all https://

check your civicrm.settings.php and the URL settings in the administrator screen

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

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 20, 2012, 04:41:46 pm
Hi Lobo,
Thanks for replying. The system was originally setup to run on https until I hit this problem. I thought removing the https might help but it didn't. Nonetheless, I have ensure the civicrm.settings.php file and Resources URL are using http, not https. However, the problem still persists.

Firebug is giving "Illegal Character: ��nMjquery.dataTables.min.js" even when I load the CiviCRM homepage.

It is weird that everything works in Safari but not the other browsers (e.g. Firefox or Chrome). The same version of everything works in my MacBook Pro. Do you think it has something to do with the service provider? Would it help if I update DataTables plug-in to 1.9? I am considering even downgrading CiviCRM just so I can get it working.

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: Contact Activity Tab Shows Correct Count But Table Empty
March 20, 2012, 08:11:57 pm

Seems like it is either a webserver config issue and/or a corrupted file. Check the output of:

http://civicrm.org/sites/civicrm.org/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js?m17ljq

VS

http://cms.iriturkey.org/sites/all/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js?m17ljq

I would try to figure out and ensure that file downloads properly (as a js file similar to civicrm.org) before trying it on civicrm.org again. Might want to ensure that file is fine and valid on the file system

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

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 20, 2012, 08:37:53 pm
It looks like jquery.dataTables.min.js is gz compressed file. You might want to replace it with simple js file.

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 20, 2012, 09:13:16 pm
Hi Kurund
Thank you so much for replying. If you look at the first screen shot, it shows both a JS and GZ file in the folder. Both files are there and intact. I have not changed anything from since I reinstalled CiviCRM. Shall I delete the GZ file?

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 20, 2012, 09:23:44 pm
Quote from: Donald Lobo on March 20, 2012, 08:11:57 pm

Seems like it is either a webserver config issue and/or a corrupted file. Check the output of:

http://civicrm.org/sites/civicrm.org/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js?m17ljq

VS

http://cms.iriturkey.org/sites/all/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js?m17ljq

I would try to figure out and ensure that file downloads properly (as a js file similar to civicrm.org) before trying it on civicrm.org again. Might want to ensure that file is fine and valid on the file system

lobo


Hi Lobo,
Thanks for responding again. I got into the hosting CPanel and opened up the jquery.dataTables.min.js file to view and edit. The content does not appear gibberish at all.

I can see if you access the file via the URL (as you have provided) it appears to be corrupted but not via CPanel. Also, I am able to view and download the file without any corruption via Safari but it becomes corrupted with Chrome and Firefox.  Pardon my ignorance, what sort of webserver config would mess up a JS file in that way?

Thank you so much for your help.

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 20, 2012, 09:33:35 pm
Quote
http://cms.iriturkey.org/sites/all/modules/civicrm/packages/jquery/plugins/DataTables-1.7.6/media/js/jquery.dataTables.min.js?m17ljq

If you open above url, it is gz file and not simple js. Can you try replacing "jquery.dataTables.min.js" with the one in CiviCRM tarball.

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 20, 2012, 09:49:02 pm
Hi Kurund,
Yes, I have done that but it still appears corrupted. ??? I also downloaded dataTables 1.7.6 from the developer's website and use that too. Also the same result. I think Lobo is correct, something in the web server is making it "corrupted" but I don't know what. Could it be encoding? CPanel opens it as utf-8. Is that correct?

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 20, 2012, 10:00:07 pm
I am not sure, may be check with your server support.

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 20, 2012, 11:41:50 pm
Hi Kurund and Lobo,
This problem should go down as an X-file! I renamed the GZ file so it is non-GZ. That seems to force the system to look for the JS file instead. Problem is not resolved.

Thank you so much for your assistance.

drikc

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Drupal 6.24
  • MySQL version: 5.5.16
  • PHP version: 5.3.8
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 23, 2012, 02:38:48 am
Hello,

I encounter this problem when I upgrade from civicrm 3.3.6 to 3.4.8 version.

Here is what we find in templates/CRM/Event/Form/ManageEvent/Tab.tpl :
Quote
{if $action eq 1 or $action eq 2 or $action eq 8 or $action eq 4 or $action eq 32768} {* add, edit, delete or view or detach*}
    {include file="CRM/Activity/Form/Activity.tpl"}
{else}
    {*include file="CRM/Activity/Selector/Activity.tpl"*}
    {include file="CRM/Activity/Selector/Selector.tpl"}
{/if}

So  the $action variable in this context is set to 16 (browse) so it fall in the else case where we can see the commented include of the Activity.tpl file.
I've uncommented this but the result return:
Quote
There are no Activites to display. You can use the links above to schedule or record an activity.

So at the moment I'm stuck with this! Any Idea why the above include is commented (it is not in civicrm 3.3.6)?

Thanks

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 23, 2012, 05:50:00 am
Thanks for the reply. I am glad to let everyone know problem is resolved. It seems like renaming it did work after all. For a while the browser was using cache until later. I still don't know what causes it but situation is evolved.

Thanks for everyone's help

sgchan

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 0
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 23, 2012, 05:52:55 am
Quote from: drikc on March 23, 2012, 02:38:48 am
Hello,

I encounter this problem when I upgrade from civicrm 3.3.6 to 3.4.8 version.

Here is what we find in templates/CRM/Event/Form/ManageEvent/Tab.tpl :
Quote
{if $action eq 1 or $action eq 2 or $action eq 8 or $action eq 4 or $action eq 32768} {* add, edit, delete or view or detach*}
    {include file="CRM/Activity/Form/Activity.tpl"}
{else}
    {*include file="CRM/Activity/Selector/Activity.tpl"*}
    {include file="CRM/Activity/Selector/Selector.tpl"}
{/if}

So  the $action variable in this context is set to 16 (browse) so it fall in the else case where we can see the commented include of the Activity.tpl file.
I've uncommented this but the result return:
Quote
There are no Activites to display. You can use the links above to schedule or record an activity.

So at the moment I'm stuck with this! Any Idea why the above include is commented (it is not in civicrm 3.3.6)?

Thanks

Drickc,
I'd advice u to use Firefox and install an add-on called Firebug. Then go to console and watch for any errors. I think that would help  narrow the prob.

drikc

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.8
  • CMS version: Drupal 6.24
  • MySQL version: 5.5.16
  • PHP version: 5.3.8
Re: Contact Activity Tab Shows Correct Count But Table Empty
March 23, 2012, 07:36:23 am
Firebug doesn't reveal any javascript error.

But I can see there is an ajax post query with this path /civicrm/ajax/contactactivity?snippet=4&context=activity&cid=60504 which look to return something weird; if I load this path in the url input of my browser a page load with all the site layout structure and cicivrm menu with the following message into the content place:

Quote
Sorry. A non-recoverable error has occurred.
is not of the type Integer

This ajax is triggered in the templates/CRM/Activity/Selector/Selector.tpl file which is included in the templates/CRM/Event/Form/ManageEvent/Tab.tpl template.

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.