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) »
  • civicrm_acl_contact_cache Errors
Pages: [1]

Author Topic: civicrm_acl_contact_cache Errors  (Read 527 times)

VRAZER

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 1
civicrm_acl_contact_cache Errors
January 02, 2014, 02:54:36 pm
On our site, we keep seeing the civicrm_acl_contact_cache.ibd file disappear.  This is the only table that is suffering from this and is on a server with several other CiviCRM installs that are not having this problem currently (possibly due to the way this client is using CiviCRM).

In our error logs, I see this:

[25-Dec-2013 08:21:54 UTC] PHP Warning:  session_start(): The session id is too long or contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,' in /home/socwomen/public_html/wp-content/plugins/civicrm/civicrm.php on line 170
[26-Dec-2013 08:23:23 UTC] PHP Warning:  mysqli_error() expects parameter 1 to be mysqli, resource given in /home/socwomen/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php on line 182

That if followed by a bunch more of the mysqli errors.

What could be causing the IBD file to go missing and require a manual reconstruction of the cache tables to fix this?  Right now since this table keeps going corrupt, it prevents people from processing events, contributions, memberships, etc on the front end.

We are using WordPress 3.8 and CiviCRM 4.4.3.

Please help.

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: civicrm_acl_contact_cache Errors
January 02, 2014, 08:55:11 pm

1. i'm assuming this site is using acl's a fair bit?

2. might want to put a cron job and check the # of rows on the table periodically. this might give u an idea as to when the table gets corrupt

3. how many acls / users / contacts are there in the 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

VRAZER

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 1
Re: civicrm_acl_contact_cache Errors
January 03, 2014, 06:16:55 am
Hi Lobo,

We actually aren't using ACL's that much.  The only piece of the site that is is the memberships area which we do use pretty heavily.  I believe there are something like 800 contacts in CiviCRM so it is a small installation.  Those 800 are primarily members, though.

As for how many ACL's, there shouldn't be any.  This is a fresh CiviCRM install and all we have done with it is wire up some events, contributions, and membership sign up pages.

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: civicrm_acl_contact_cache Errors
January 03, 2014, 08:26:15 am

hmm, in that case i dont think it should be using that table at all. Sorry no idea whats happening on your site or why :(

please update this topic once u figure it out. seems a bit wierd

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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • civicrm_acl_contact_cache Errors

This forum was archived on 2017-11-26.