OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

This topic contains 39 replies, has 14 voices, and was last updated by submission.10seos submission.10seos 2 years, 7 months ago.

  • Creator
    Topic
  • #25785

    Sublab
    Participant

    Hello,
    I’d like to know how to install OroCRM.
    I’m a newbie with SSH.
    For the instant Iupload everyfile orocrm-application on a subdomain.
    I’ve asked for a ssh access and i can now connect with ssh.
    But after ?
    There ‘s install.sh but i don’t know how to reach and navigate with SSH.
    Can someone help me ?
    Merci

Viewing 9 replies - 31 through 39 (of 39 total)
  • Author
    Replies
  • #25816
    Artem Liubeznyi
    Artem Liubeznyi
    Keymaster

    Simply select the records you want to delete with checkboxes, then click Delete in the mass action selector like this.


    #25817

    baronn
    Participant

    yup, doing that bit by bit HOWEVER having some issues.

    When going to activities > calls and mass selecting it doesn’t delete anything. It says loading BUT unlike other sections where there is a success message presented on this section nothing happens. No message AND nothing deleted.

    Also, trying to remove users. I have made sure I am an admin with system settings AND also removed all other users from any business unit etc BUT on mass delete again nothing is done it shows loading and then simply disappears with no success message presented OR users deleted. Trying to delete 1 user I am simply presented with: You do not have permission to perform this action.

    Still tearing my hair out..

    #25818

    baronn
    Participant

    can anyone confirm how I can delete users? I get the permission errors message indication i don’t have permissions to delete users BUT I am the only admin on my system…

    #25819

    baronn
    Participant

    this may be of help from prod log file (it shows same error again and again):

    [2016-05-31 08:57:02] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: "An exception occurred while executing 'DELETE FROM oro_user WHERE id = ?' with params [30]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>))" at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ForeignKeyConstraintViolationException: An exception occurred while executing 'DELETE FROM oro_user WHERE id = ?' with params [30]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []<br />[2016-05-31 08:57:02] request.CRITICAL: Exception thrown when handling an exception (Oro\Bundle\SecurityBundle\Exception\OrganizationAccessDeniedException:  at /home/visionssco/public_html/ocm/app/cache/prod/classes.php line 8350) {"exception":"[object] (Oro\\Bundle\\SecurityBundle\\Exception\\OrganizationAccessDeniedException:  at /home/visionssco/public_html/ocm/app/cache/prod/classes.php:8350)"} []<br />[2016-05-31 08:57:22] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: "An exception occurred while executing 'DELETE FROM oro_user WHERE id = ?' with params [44]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>))" at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ForeignKeyConstraintViolationException: An exception occurred while executing 'DELETE FROM oro_user WHERE id = ?' with params [44]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (<code>visionssco_viscrm</code>.<code>oro_activity_owner</code>, CONSTRAINT <code>fk_oro_activity_owner_user_id</code> FOREIGN KEY (<code>user_id</code>) REFERENCES <code>oro_user</code> (<code>id</code>)) at /home/visionssco/public_html/ocm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []</p><p>

    #25820
    Artem Liubeznyi
    Artem Liubeznyi
    Keymaster

    Hi,

    Only inactive users can be deleted. Can you please try to deactivate them first and check if the problem persists?

    Thank you.


    #25821
    Artem Liubeznyi
    Artem Liubeznyi
    Keymaster

    A correction: the user record cannot be deleted if it has any relations to OroCRM records, even if it’s inactive. So in order to delete a user you have to make sure they are not set as owner to any record, nor they have any activities assigned to them.


    #25822

    baronn
    Participant

    I have made the users inactive. Ensured that they have no ownership to any type of record.

    been through all the demo data and removed everything (activities,calls,orders anything that was present. Totally stripped the demo data out. All that exists is the users which i cannot seem to delete. so there also wouldn’t be anything that they are connected/related too HOWEVER still get the same error!

    #25823
    Artem Liubeznyi
    Artem Liubeznyi
    Keymaster

    This is strange. We will check if we can reproduce this issue.

    We will also analyze how we can improve user deletion so that pre-stripping of record ownership won’t be necessary. Can’t promise it in the nearest release but we will work on it in the future.


    #25824
    submission.10seos
    submission.10seos
    Participant

    Thanks .. I was searching for the same


Viewing 9 replies - 31 through 39 (of 39 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No