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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Civicrm Standalone 2.1 access permission error
Pages: [1]

Author Topic: Civicrm Standalone 2.1 access permission error  (Read 4419 times)

drewaharris

  • Guest
Civicrm Standalone 2.1 access permission error
September 15, 2008, 08:06:02 am
Hi,

I get the following error immediately after entering the myopenid on Civicrm Standalone 2.1 beta 4.

Sorry. A non-recoverable error has occurred.
You do not have permission to access this page

I migrated the data from an existing Joomla 2.1 installation, but it was working until I tried to add another contact.

Any thoughts? Which table should I empty to get past this?

Thanks.

Drew

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Civicrm Standalone 2.1 access permission error
September 15, 2008, 08:27:50 am
If it's an added contact that you trying to login with, its due to limited permissions for authenticated users - which admin can change using ACL.

Or if its the admin account (first user) something went wrong with, empty your civicrm_uf_match table and it should allow you setup admin account again. 
« Last Edit: September 15, 2008, 08:30:57 am by Deepak Srivastava »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

drewaharris

  • Guest
Re: Civicrm Standalone 2.1 access permission error
September 15, 2008, 08:49:16 am
I tried to log in with my usual account. I emptied the UF_match table and now get this error:


Sorry. A non-recoverable error has occurred.
is not of the type Integer

Return to home page.

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Civicrm Standalone 2.1 access permission error
September 15, 2008, 09:04:39 am
Didn't it take you through first user setup process ?

Try clearing your session and check.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

drewaharris

  • Guest
Re: Civicrm Standalone 2.1 access permission error
September 15, 2008, 11:04:00 pm
No go. I tried a clean install and got it to run if I dropped all the tables. It then ran first user.

Then, I dropped the tables in phpmyadmin and imported my old Joomla tables (2.1 beta). It wouldn't let me log in because there was no entry in the openid table. I manually edited the openid table to match the new install version. It then gave me the permissions error. I purged the uf_match table and got the integer error.

I only want to migrate my data from the Joomla version to the Standalone. What tables from the new install should I keep? And what needs to be fixed in the original tables? It seems like there should be a script that can handle this conversion. Unfortunately, it's beyond my skillset.

Thanks.

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Civicrm Standalone 2.1 access permission error
September 16, 2008, 12:12:32 am
Ok here are the exact steps (just verified on my machine) :

After you have dropped tables from standalone db and imported joomla tables:
1. Empty civicrm_menu, civicrm_uf_match table

2. Make sure all openId_* tables are empty

3. Run all the queries of the file - http://svn.civicrm.org/civicrm/branches/v2.1/xml/templates/civicrm_uf.tpl on the db. Alternatively you may copy the content and and save as some sql/mysql file, which you can import.

Before running above queries make sure the all tables mentioned in the queries are empty (civicrm_uf_group, civicrm_uf_join, civicrm_uf_field). If they aren't, take the backup (which you can later use/add) and empty them.

4. Import the file civicrm/sql/civicrm_acl.mysql (you can find in v2.1 tarball) in the db.

5. To be safe clear your session
« Last Edit: September 16, 2008, 12:28:52 am by Deepak Srivastava »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

drewaharris

  • Guest
Re: Civicrm Standalone 2.1 access permission error
September 16, 2008, 05:33:58 am
I got the following error when importing civicrm_acl.mysql

SQL query:

-- Create default Groups for User Permissioning
INSERT INTO civicrm_group( `id` , `name` , `title` , `description` , `source` , `saved_search_id` , `is_active` , `visibility` , `group_type` )
VALUES ( 1, 'Administrators', 'Administrators', 'Contacts in this group are assigned Administrator role permissions.', NULL , NULL , 1, 'User and User Admin Only', '1' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

--------
I tried changing the ID to '100' in the import. It ran without error, but I still get the permission error. I do have a group with ID '1' already. Should I change the ID on this record? If so, should I change it anywhere else?

Thanks for all the great help.

Drew

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Civicrm Standalone 2.1 access permission error
September 16, 2008, 05:51:44 am
civicrm_acl.mysql also had another query -
Code: [Select]
INSERT INTO civicrm_acl_entity_role
    (`acl_role_id`, `entity_table`, `entity_id`, `is_active`)
VALUES
    (1, 'civicrm_group', 1, 1);

And since you changed the id (of administrators group to 100) the entry in your "civicrm_acl_entity_role" table should reflect:
Code: [Select]
INSERT INTO civicrm_acl_entity_role
    (`acl_role_id`, `entity_table`, `entity_id`, `is_active`)
VALUES
    (1, 'civicrm_group', 100, 1);

You can empty civicrm_acl_entity_role table and re-run this new query OR update the entry itself in the table.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

drewaharris

  • Guest
Re: Civicrm Standalone 2.1 access permission error
September 16, 2008, 06:37:52 am
Thank you! That worked.

I hope this thread helps others who are trying to convert from Joomla to standalone.

Drew
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Civicrm Standalone 2.1 access permission error

This forum was archived on 2017-11-26.