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 (Moderator: Dave Greenberg) »
  • myrelationships and mysecundaryrelationships tables
Pages: [1]

Author Topic: myrelationships and mysecundaryrelationships tables  (Read 880 times)

MarcL

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.4.11
  • CMS version: 7.34
  • MySQL version: 5.5
  • PHP version: 5.3
myrelationships and mysecundaryrelationships tables
May 03, 2014, 01:07:03 pm
Hello

since version 4.4 I see a lot of tables like myrelationships976660 and mysecundaryrelationships0702104563224

It looks to me as those are temporary tables which are not cleaned up by the "Clean-up Temporary Data and Files"

Is that correct ? or should they be cleaned up by hand ?

Marc

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: myrelationships and mysecundaryrelationships tables
May 03, 2014, 07:05:10 pm

pretty sure those tables are not created by any of the core civicrm code

we typically will use a _temp_ prefix on all temp tables

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

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: myrelationships and mysecundaryrelationships tables
May 03, 2014, 09:12:10 pm
i would be guessing these are coming in from an extension - and guessing one of eileen's eg Related Permissions Module
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

MarcL

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.4.11
  • CMS version: 7.34
  • MySQL version: 5.5
  • PHP version: 5.3
Re: myrelationships and mysecundaryrelationships tables
May 06, 2014, 01:59:52 pm
Quote from: petednz on May 03, 2014, 09:12:10 pm
i would be guessing these are coming in from an extension - and guessing one of eileen's eg Related Permissions Module

right guess,
I'm using Related Permissions Module v 1.1

Should/could I remove savely the table ?

Marc

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: myrelationships and mysecundaryrelationships tables
May 06, 2014, 02:25:34 pm
I will nudge eileen to comment when she is back in NZ after the code sprint
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: myrelationships and mysecundaryrelationships tables
May 07, 2014, 12:09:38 am
You can pretty much delete them. The latest version on github doesn't create them - but it has a dependency on the entity setting extension & also requires CiviCRM to generate valid html on specific pages (which is doesn't prior to 4.4.6 - as I recently discovered). All of which is manageable but because of those it is not set up for automatic deployment
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: myrelationships and mysecundaryrelationships tables
May 07, 2014, 12:27:00 am
In CiviCRM there is an option to enable second degree relationships. Which could do the same as the extension from Eileen.
Maybe someone can explain the difference between this option in civicrm and the extension from Eileen?
Developer at Edeveloper / CiviCoop

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: myrelationships and mysecundaryrelationships tables
May 07, 2014, 02:35:06 am
AFAIK the CiviCRM one is not a 'true' acl - rather it provides specific & limited access from the dashboard. I did discuss this with Coleman & we both thought the one in the dashboard should be a true ACL in core (although not sure anyone is doing anything about it).

If anyone wants to test & confirm a true ACL will filter the contact.get results whereas if the contact.get results don't accurately reflect second degree permissioned relationships then that is not a true ACL.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • myrelationships and mysecundaryrelationships tables

This forum was archived on 2017-11-26.