Activities not showing on contact's activities tab

[b0b_z]

Good Morning All

Running Drupal 7.14 with Civicrm 4.1.5

We just noticed the activities under the contact view will no longer populate the table civicrm/contact/view?reset=1&cid=#####

This used to work and now the jquery loading icon spins but nothing else (see screen cap)

We also tried IE and get a jquery error

Webpage error details

Message: Object doesn't support this property or method
Line: 28
Char: 5
Code: 0
URI: http://www.our-site.org/civicrm/contact/view?reset=1&cid=#####


Message: Could not complete the operation due to error 80020101.
Line: 2
Char: 11364
Code: 0
URI: http://www.our-site.org/sites/all/modules/civicrm/packages/jquery/jquery.min.js?mezzgy

We found a couple older threads but the suggestions there did not work

Anyone else with this issue?

[Hershel]

Can you try with Firefox with the Firebug extension installed and look at the Net and/or Console tabs and look for errors or not loaded URLs there?

[b0b_z]

From the console tab (errors) after selecting activities tab

No information is displayed

TypeError: cj("#contact-activity-selector-" + context).dataTable is not a function
[Break On This Error]    

(65 out of range 46)

After selecting other tabs ( Relationships   Groups    Notes    Tags   Change Log )

Information IS displayed with error

TypeError: s is undefined
[Break On This Error]    

(83 out of range 32)

TypeError: cj.fn.dataTableExt is undefined
[Break On This Error]    

(183 out of range 32)

[Hershel]

This used to work

Until when? What changed?

Can you try with a different theme? I think some JS code in your theme or another module is conflicting with CiviCRM's.

[b0b_z]

About a couple weeks ago...
Nothing had been altered.
It simply ceased functioning
I tried a different theme to no avail

There are no other plugins installed other than Civicrm

[Hershel]

I'm not sure. Something must have changed, otherwise it couldn't just stop working. Can you upgrade CiviCRM? Perhaps that would help.

[b0b_z]

I know, it's an odd one...

I tried to upgrade a couple times to no avail

The data import/conversion stalls on upgrade so I did not try again

The database is fairly large but that should not make any difference I would think

Thanks

[Hershel]

The database is fairly large but that should not make any difference I would think

Actually for CiviCRM upgrades before they added the batch upgrade feature, large DBs require a large amount of CPU processing to convert and many times that causes an error server side. In such cases, the upgrade may need to be run offline.

But if you use the latest CiviCRM to upgrade, it should run everything in batches and then this should not be a problem.

[b0b_z]

I tried on 11/1 the Drupal version 4.2.6 and it failed

It's a huge hassle to restore after a failure especially while trying to keep a site online and functioning

Perhaps we'll try one more time during the holidays while things are slow

As an aside, what should the permissions be for the jquery directory?

Maybe during a restore that borked the permissions...

[Hershel]

jQuery files need only to have read access.

It is recommended to run upgrades on a test site, thus obviating the need to restore a site after a failure.

[b0b_z]

Yes, I know I should have done that...

I backed everything up and have recovered in the past

This time is a bit more problematic

[b0b_z]

Has anyone else had a similar problem and found a solution?

I looked at Firebug to check for errors and found these three:

"NetworkError: 403 Forbidden - http://www.my-site.org/sites/all/modules/civicrm/packages/jquery/css/images/arrow.png"

"NetworkError: 403 Forbidden - http://www.my-site.org/sites/all/modules/civicrm/packages/jquery/jquery-ui-1.8.16/css/smoothness/images/ui-bg_flat_75_ffffff_40x100.png"

TypeError: cj("#contact-activity-selector-" + context).dataTable is not a function
(65 out of range 46)

Thanks!

[Hershel]

The first two are not important. The last one is the problem. Same issue reported here http://forum.civicrm.org/index.php/topic,20847.msg100489.html#msg100489 with no resolution.

[b0b_z]

Well that's OK and yet again not so much

I'd upgrade to 4.2+ BUT every time I've done so the database import/update borks

Any suggestions on that?

Maybe I can go from 4.1.5 to 4.1.6 and so forth

This error is a real pain

[b0b_z]

Not sure if this is a fix BUT I dumped the contents of  templates_c folder and all is now working

/sites/default/files/civicrm/templates_c

I'll try it again if the issue persists