Author Topic: Not allowed to login (Read 5576 times)

dcraftinc · December 19, 2009, 12:37:25 pm

I am a newbie to Civicrm and a programming light weight.

I've been playing around with standalone ver 3.0 trying to get a feel for CiviCRM. I did the install so I am the first user entered and am the administrator. I've been adding records and custom fields, etc for the last few weeks.

This week, I went into the configuration page, Viewing and Editing Contacts, Address Settings, Address Editing Fields and unchecked the OpenID box (I don't want to have OpenIDs for contacts). Then I logged out.

Later I tried to login, entered my openid as usual and got the following error message:

You are not allowed to login. Login failed. Contact your Administrator.

From a few issues I found in the forum I decided to Use phpmyadmin and open some of the tables. The Civicrm_opendid table is empty, the Civicrm_openid_associations table has two records that I have no idea what they are for and the Civicrm_nonces table has 29 records and I have no idea what these are for either.

It seems to me that I should have been able to find some kind of openid entry that ties back to me but I couldn't find anything. Could my unchecking the openid box in the config have dumped my openid and that is why I can't login?

If that is the problem, can I manually add the needed information into the table(s)?

Thanks,
Steve

Kurund Jalmi · December 20, 2009, 12:46:17 am

This might help: http://forum.civicrm.org/index.php/topic,8296.msg35889.html#msg35889

Kurund

dcraftinc · December 28, 2009, 04:20:17 pm

Thanks, it looks like the civicrm.settings.php is not in my root directory.

How do I recreate it?

Thanks,
Steve

Kurund Jalmi · December 28, 2009, 06:20:27 pm

You can copy templates/CRM/common/civicrm.settings.php.tpl to civicrm.settings.php and update DNS etc.

Kurund

dcraftinc · December 30, 2009, 06:54:27 pm

Thanks! I'll give that a try.
Steve

dcraftinc · January 05, 2010, 10:40:57 am

Okay, I re-created the missing file. It took a while for me to get the mysql information but I finally got that in.

Now when I enter my openid it does log me in and Civicrm starts. However, I get an error that sounds like one of the tables is missing a field. However, when I open the table it seems to have the field. Following is the error message. I have included the structure and index information in-case that helps.

Thanks, Steve
*********************************************************

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Return to home page.

Error Details:

Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 

 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]
)

************************************************************************************
STRUCTURE OF CiviCRM_Preferences

	Field 			Type 		Collation 	Attributes 	Null 	Default 	Extra 	Action
	id 			int(10) 			UNSIGNED 	No 		auto_increment 	Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	domain_id 		int(10) 			UNSIGNED 	No 				Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	contact_id 		int(10) 			UNSIGNED 	Yes 	NULL	 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	is_domain 		tinyint(4) 					Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	contact_view_options 	varchar(128) 	utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	contact_edit_options 	varchar(128) 	utf8_unicode_ci 		Yes 	NULL	 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	advanced_search_options varchar(128) 	utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	user_dashboard_options 	varchar(128) 	utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	address_options 	varchar(128) 	utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	address_format 	text 			utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	mailing_format 	text 			utf8_unicode_ci 		Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	address_standardization_provider varchar(64) 	utf8_unicode_ci 	Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	address_standardization_userid 	varchar(64) 	utf8_unicode_ci 	Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	address_standardization_url 	varchar(255) 	utf8_unicode_ci 	Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	editor_id 		int(10) 			UNSIGNED 	Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	mailing_backend 	text 	utf8_unicode_ci 			Yes 	NULL 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
	navigation


**************************************************************************************************
Indexes: 
Documentation 
Keyname 			Type 	Cardinality 	Action 	Field
PRIMARY 			PRIMARY 1  	Edit 	Drop 	id
index_contact_view_options 	INDEX 	1  	Edit 	Drop 	contact_view_options
index_contact_edit_options 	INDEX 	1  	Edit 	Drop 	contact_edit_options
index_advanced_search_options 	INDEX 	1  	Edit 	Drop 	advanced_search_options
index_user_dashboard_options 	INDEX 	1  	Edit 	Drop 	user_dashboard_options
index_address_options 	INDEX 		1  	Edit 	Drop 	address_options
FK_civicrm_preferences_domain_id INDEX 	1  	Edit 	Drop 	domain_id
FK_civicrm_preferences_contact_idINDEX 	1  	Edit 	Drop 	contact_id

Create an index on  columns

Space usage Type 	Usage
Data 	32,768 		B
Index 	112.0 		KiB
Total 	144.0 		KiB

Row Statistics Statements 	Value
Format 				Compact
Collation	 	utf8_unicode_ci
Next Autoindex 			3
Creation	 	Nov 28, 2009 at 04:42 PM

Kurund Jalmi · January 05, 2010, 08:19:38 pm

Did you try upgrade? You code base seems to be of v3.1

Kurund

dcraftinc · January 05, 2010, 11:51:14 pm

That's odd, no I did not upgrade. Not consciously anyway, it should be 3.0.

Is there a file I can open that will tell me the version?

And if it is 3.1, is that somehow the reason for my problem?

Thanks,
Steve

Kurund Jalmi · January 06, 2010, 01:57:25 am

Can you check your if your civicrm_preferences table contains domain_id column.

Kurund

dcraftinc · January 07, 2010, 11:52:44 am

Yes, the civicrm.preferences table does contain a domainid field. It contains a value of 1.

I have attached an text file showing the table contents and fields.

Thanks,
Steve

dcraftinc · January 07, 2010, 12:05:49 pm

Sorry, I attached a text file of the table to my earlier post but when I downloaded my attachment to check it, it doesn't look like my original.

Here's another one that I think should work.

Thanks,
Steve

Kurund Jalmi · January 08, 2010, 01:23:39 am

Sorry can't think of any other idea. May be you should try to contact someone from http://civicrm.org/professional

Kurund

conductorchris · January 08, 2010, 08:52:19 pm

Might be easier just to reinstall, as you haven't done much yet, right?

dcraftinc · January 13, 2010, 12:47:09 pm

Yes, I think I'll just re-install. I wanted to figure this out in case it happened again and I had a lot of work invested. I guess I'll cross that road if I get to it.

Thanks for your help,
Steve

CiviCRM Community Forums (archive)

News:

Author Topic: Not allowed to login (Read 5576 times)

dcraftinc

Not allowed to login

Kurund Jalmi

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

Kurund Jalmi

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

Kurund Jalmi

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

Kurund Jalmi

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

dcraftinc

Re: Not allowed to login

Kurund Jalmi

Re: Not allowed to login

conductorchris

Re: Not allowed to login

dcraftinc

Re: Not allowed to login