Magento Forum

How do I recover my admin access? 
 
kashi6699
Jr. Member
 
Total Posts:  1
Joined:  2012-09-20
 

My intension was to block visiters from my own country, so I just chose it in configuration in restrict country, which is below the default country tab. Now I can not log into admin panel, even not the store page access is denied.  the error message is as below: Exception printing is disabled by default for security reasons.
My questions is: how can I recover and erase the restriction on countries?

Thank you very much.

Mark

 
Magento Community Magento Community
Magento Community
Magento Community
 
chiefair
Mentor
 
Avatar
Total Posts:  1848
Joined:  2009-06-04
 

These configuration entries are stored in the core_config_data table with the following paths: general/country/allow and general/country/default

For example if you decided to exclude US for a default country of US, it would look something like the following:

general/country/default US

general/country/allow AF,AL,DZ,AS,AD,AO,AI,AQ,AG,AR,AM,AW,AU,AT,AZ,BS,BH,BD,BB,BY,BE,BZ,BJ,BM,BT,BO,BA,BW,BV,BR,IO,VG,BN,BG,BF,BI,KH,CM,
CA,CV,KY,CF,TD,CL,CN,CX,CC,CO,KM,CG,CD,CK,CR,HR,CU,CY,CZ,CI,DK,DJ,DM,DO,EC,EG,SV,GQ,ER,EE,ET,FK,FO,FJ,FI,FR,GF,PF,
TF,GA,GM,GE,DE,GH,GI,GR,GL,GD,GP,GU,GT,GG,GN,GW,GY,HT,HM,HN,HK,HU,IS,IN,IQ,IE,IM,IL,IT,JM,JP,JE,JO,KZ,KE,KI,KW,KG,LA,
LV,LB,LS,LR,LY,LI,LT,LU,MO,MK,MG,MW,MY,MV,ML,MT,MH,MQ,MR,MU,YT,MX,FM,MD,MC,MN,ME,MS,MA,MZ,NA,NR,NP,NL,AN,NC,
NZ,NI,NE,NG,NU,NF,MP,NO,OM,PK,PW,PA,PG,PY,PE,PH,PN,PL,PT,PR,QA,RO,RU,RW,RE,BL,SH,KN,LC,MF,PM,VC,WS,SM,SA,SN,
RS,SC,SL,SG,SK,SI,SB,ZA,GS,KR,ES,LK,SD,SR,SJ,SZ,SE,CH,SY,ST,TW,TJ,TZ,TH,TL,TG,TK,TO,TT,TN,TR,TM,TC,TV,UM,VI,UG,UA,
AE,GB,UY,UZ,VU,VA,VE,VN,WF,EH,YE,ZM,ZW,AX

Supposing that there is an error in the logic that causes Magento to die because the default country (bad error handling) isn’t in the allowed country list, use phpMyAdmin to set the following:

general/country/default US

general/country/allow US

And recover from there.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top