Forums › Forums › OroCRM › OroCRM – Installation/Technical Issues or Problems › How to install OroCRM
This topic contains 39 replies, has 14 voices, and was last updated by submission.10seos 7 years, 5 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- October 13, 2013 at 2:29 am #25785
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 - CreatorTopic
- AuthorReplies
- May 27, 2016 at 6:47 am #25816
Simply select the records you want to delete with checkboxes, then click Delete in the mass action selector like this.
May 27, 2016 at 6:53 am #25817yup, 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..
May 31, 2016 at 12:47 am #25818can 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…
May 31, 2016 at 5:23 am #25819this 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>
June 1, 2016 at 9:37 am #25820Hi,
Only inactive users can be deleted. Can you please try to deactivate them first and check if the problem persists?
Thank you.
June 1, 2016 at 9:52 am #25821A 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.
June 2, 2016 at 2:27 am #25822I 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!
June 2, 2016 at 9:06 am #25823This 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.
November 8, 2016 at 1:01 am #25824 - AuthorReplies
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.