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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Strange: Default organization is deleted and cannot be removed from trash
Pages: [1]

Author Topic: Strange: Default organization is deleted and cannot be removed from trash  (Read 1140 times)

Detlev

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
    • Software für Engagierte e.V.
  • CiviCRM version: 4.5
  • CMS version: Drupal
Strange: Default organization is deleted and cannot be removed from trash
November 07, 2013, 11:46:35 am
For some reason, the default organization became deleted and now resides in the "trash". This should not happen - but it did though.

When I try to undelete it, I get the following message:
Quote
Sorry but we are not able to provide this at the moment.
This contact is a special one for the contact information associated with the CiviCRM installation for this domain. No one is allowed to delete it because the information is used for special system purposes.

I found the error, because the organization moved to a new location, and it was "impossible" to change the address...
After looking around, I discovered the contact in the trashbin, and changed the address there - which solved the actual problem with the wrong results from the domain-address-token.

But, I think we should find a better and lasting solution. Any ideas?


Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Strange: Default organization is deleted and cannot be removed from trash
November 08, 2013, 03:41:24 am
Prevent the default organization from being trashed sounds like a logical solution?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Detlev

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
    • Software für Engagierte e.V.
  • CiviCRM version: 4.5
  • CMS version: Drupal
Re: Strange: Default organization is deleted and cannot be removed from trash
November 08, 2013, 06:49:36 am
Ah sorry, I did not explain the complete thing:

Currently, the default organisation resides in the Trash. And when I try to "undelete" it, I receive the error message mentioned above.

I could imagine, that it were no good idea to leave this as-is - one time in the future somebody will complete the deletion by accident, or other evil things might happen.

Therefore my question: Is it possible to undelete the contact by patching the "is deleted" field via SQL? How exactly would I have to do that? Or any other idea?


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: Strange: Default organization is deleted and cannot be removed from trash
November 08, 2013, 06:55:13 am

there is an 'is_deleted' column in civicrm_contact table. can u flip that and see

also, also check if we can delete the default org via UI? If so, please file an issue and we should ensure that this is not allowed :)

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

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Strange: Default organization is deleted and cannot be removed from trash
November 09, 2013, 03:58:40 am
That is what I meant Detlef, that if we can trash/delete the default org a fix should make sure we can not.
and try this:

UPDATE civicrm_contact SET is_deleted = 0 WHERE id = 1
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Strange: Default organization is deleted and cannot be removed from trash

This forum was archived on 2017-11-26.