なんらかの原因で管理者ＩＤが使えなくなってしまった時はデータベースへ直接ＩＤを生成する必要があります。そんなときはこちらのクエリーを実行してください。
まずはadmin_user テーブルを更新
INSERT INTO admin_user
SELECT
(select max(user_id) + 1 from admin_user) user_id,
"xxxxxx" firstname, //ご自信のものに変更してください
"xxxxxx" lastname, //ご自信のものに変更してください
"xxxxxx" email, //ご自信のものに変更してください
"xxxxxx" username, //ご自信のものに変更してください
"3934e5e2ac03e708b1c62b8dbb44cf9e" password, //ご自信のものに変更してください
NOW( ) created,
NULL modified,
NULL logdate,
0 lognum,
0 reload_acl_flag,
1 is_active,
(SELECT MAX(extra) FROM admin_user WHERE extra IS NOT NULL) extra,
NULL rp_token,
NOW() rp_token_created_at,
0 failures_num,
NULL first_failure,
NULL lock_expires;
SELECT
(select max(user_id) + 1 from admin_user) user_id,
"xxxxxx" firstname, //ご自信のものに変更してください
"xxxxxx" lastname, //ご自信のものに変更してください
"xxxxxx" email, //ご自信のものに変更してください
"xxxxxx" username, //ご自信のものに変更してください
"3934e5e2ac03e708b1c62b8dbb44cf9e" password, //ご自信のものに変更してください
NOW( ) created,
NULL modified,
NULL logdate,
0 lognum,
0 reload_acl_flag,
1 is_active,
(SELECT MAX(extra) FROM admin_user WHERE extra IS NOT NULL) extra,
NULL rp_token,
NOW() rp_token_created_at,
0 failures_num,
NULL first_failure,
NULL lock_expires;
MD5形式のパスワードを取得するには書きのサイトをご利用ください。無料です。
http://www.miraclesalad.com/webtools/md5.php
次にadmin_rollテーブルを更新
INSERT into admin_role
SELECT
NULL role_id,
(SELECT role_id FROM admin_role WHERE role_name = 'Administrators') parent_id,
2 tree_level,
0 sort_order,
'U' role_type,
(SELECT user_id FROM admin_user WHERE username = 'USERNAME') user_id, //ご自信のものに変更してください
'USERNAME' role_name, //ご自信のものに変更してください
1 gws_is_all,
null gs_websites,
null gws_store_groups;
SELECT
NULL role_id,
(SELECT role_id FROM admin_role WHERE role_name = 'Administrators') parent_id,
2 tree_level,
0 sort_order,
'U' role_type,
(SELECT user_id FROM admin_user WHERE username = 'USERNAME') user_id, //ご自信のものに変更してください
'USERNAME' role_name, //ご自信のものに変更してください
1 gws_is_all,
null gs_websites,
null gws_store_groups;
magentoのバージョンによってFieldの数が若干違うようです。こちらの例はMagento 1.9.1でのやり方のため、もしクエリー実行時にfield数の数が違うと怒られた場合はテーブルの中身を確認して数をあわせてください。
cost atorvastatin 80mg buy atorvastatin no prescription buy atorvastatin 80mg
buy cipro 500mg generic - cipro 1000mg cheap cost augmentin 375mg
cipro 1000mg price - cephalexin pill order augmentin 1000mg pills
order metronidazole 200mg - buy azithromycin 250mg online cheap zithromax medication
ciplox 500mg tablet - order tinidazole without prescription erythromycin 250mg brand
valtrex cost - acyclovir 800mg drug order acyclovir 800mg generic
purchase metronidazole - cleocin where to buy zithromax 250mg cheap
buy generic ampicillin purchase vibra-tabs cheap amoxicillin pills
furosemide order - coumadin sale captopril over the counter
order glucophage for sale - how to get duricef without a prescription buy lincomycin tablets
retrovir online buy - buy epivir 100 mg online zyloprim 100mg drug
buy clozaril 50mg generic - order altace 10mg sale pepcid order online
quetiapine us - fluvoxamine 100mg ca buy eskalith tablets
order anafranil 50mg generic - purchase amoxapine pills doxepin for sale
hydroxyzine pills - cost escitalopram 20mg endep 25mg generic
buy amoxil online cheap - buy amoxicillin 250mg without prescription buy cipro without prescription
augmentin price - buy cipro 500mg online cheap cipro 500mg canada
buy clindamycin generic - terramycin 250 mg over the counter buy chloromycetin paypal
order azithromycin - order generic tetracycline 250mg order ciprofloxacin 500mg for sale
order ventolin - purchase promethazine sale theophylline ca
desloratadine drug - zaditor 1mg usa order albuterol generic
generic depo-medrol online - oral claritin 10mg buy astelin
glyburide price - buy cheap dapagliflozin forxiga 10mg usa
purchase prandin without prescription - buy empagliflozin 10mg without prescription order jardiance 10mg for sale
order terbinafine pill - order terbinafine 250mg without prescription purchase grifulvin v generic
buy ketoconazole 200 mg sale - purchase mentax generic sporanox online buy
purchase famciclovir pills - acyclovir 400mg tablet valcivir for sale
lanoxin 250 mg pills - buy generic trandate 100 mg buy lasix 40mg
microzide online buy - felodipine pills pill zebeta
cheap metoprolol 50mg - buy nifedipine 30mg online cheap adalat 30mg sale
buy generic nitroglycerin for sale - buy lozol 2.5mg pills buy diovan tablets
rosuvastatin dignity - caduet clerk caduet online invisible
zocor skirt - simvastatin period atorvastatin dirty
buy viagra professional daylight - super avana colour levitra oral jelly blanket
priligy stuff - viagra plus decide cialis with dapoxetine set
cialis soft tabs observation - viagra oral jelly online stable viagra oral jelly potato
brand cialis absurd - brand levitra check penisole dragon
cialis soft tabs pills each - tadarise pills wit viagra oral jelly speed
order generic cenforce 50mg - levitra professional online pillar brand viagra custom
acne treatment howl - acne treatment mess acne treatment timid
uti medication advance - treatment for uti await uti treatment engage
prostatitis pills overcome - prostatitis pills trip pills for treat prostatitis hear
valtrex online knife - valtrex online explore valacyclovir online wine
loratadine wrong - loratadine track loratadine medication whilst
dapoxetine vanish - priligy brilliant priligy channel
loratadine need - loratadine match loratadine performance
promethazine ink - promethazine daemon promethazine camera
ascorbic acid million - ascorbic acid storm ascorbic acid replace
biaxin drop - cytotec concentrate cytotec fool
florinef crystal - protonix pills skill lansoprazole traffic
bisacodyl online - bisacodyl pills how to buy liv52
purchase rabeprazole online cheap - brand reglan 10mg motilium tablet
brand cotrimoxazole - cheap tobra order tobramycin 5mg without prescription
eukroma cost - duphaston 10mg generic dydrogesterone medication
buy dapagliflozin medication - order sinequan generic precose 25mg generic
purchase fulvicin for sale - buy dipyridamole 25mg pill buy lopid 300 mg pills
order vasotec 10mg generic - order doxazosin pill purchase zovirax eye drops
order monograph 600 mg online cheap - order monograph 600mg online buy pletal 100mg without prescription
order feldene 20 mg generic - feldene 20 mg oral order rivastigmine sale
piracetam cheap - buy sinemet 20mg pills sinemet tablet
hydroxyurea generic - buy indinavir pills robaxin 500mg drug
buy divalproex tablets - cordarone online buy buy generic topiramate 200mg
disopyramide phosphate medication - buy pregabalin 75mg for sale chlorpromazine for sale
buy cyclobenzaprine 15mg generic - buy generic zyprexa vasotec 5mg pill
purchase zofran pill - requip 1mg cost order requip generic
buy ascorbic acid 500 mg - cheap kaletra for sale buy compro generic
buy durex gel online - purchase durex condoms online buy zovirax online cheap
rogaine brand - purchase proscar finpecia medication
buy arava 10mg pills - purchase calcium carbonate pill cartidin generic
how to buy tenormin - buy generic tenormin buy generic coreg 6.25mg
verapamil 240mg cost - order verapamil online cheap tenoretic drug
order atorlip - nebivolol online order nebivolol generic
order lasuna generic - buy diarex online buy generic himcolin over the counter
order gasex for sale - buy ashwagandha no prescription buy generic diabecon for sale
purchase norfloxacin - purchase confido generic brand confido
buy speman generic - himplasia oral cheap fincar
hytrin over the counter - flomax cost priligy 60mg ca
trileptal pills - synthroid 75mcg brand buy generic levothyroxine
imusporin oral - purchase imusporin purchase colchicine sale
buy generic duphalac over the counter - buy betahistine cheap order betahistine 16 mg pill
deflazacort tablet - order alphagan generic alphagan eye drops
besifloxacin drug - purchase sildamax online cheap order sildamax generic
order neurontin 100mg generic - gabapentin cheap order sulfasalazine 500 mg pills
buy benemid 500mg generic - order probenecid 500 mg for sale order tegretol pill
buy celecoxib generic - where to buy indomethacin without a prescription indomethacin price
purchase colospa online - brand colospa generic cilostazol 100mg
order generic cambia - order diclofenac 50mg online cheap purchase aspirin online
oral rumalaya - rumalaya brand order amitriptyline 10mg for sale
cost mestinon 60 mg - buy generic sumatriptan for sale imuran 50mg tablet
cost voveran - cheap diclofenac pill nimodipine cheap
baclofen 10mg sale - buy baclofen no prescription buy generic feldene over the counter
order periactin without prescription - periactin uk order generic tizanidine
buy trihexyphenidyl for sale - emulgel where to buy where can i order diclofenac gel
cefdinir generic - buy cleocin without prescription cleocin where to buy
where can i buy accutane - dapsone 100mg cheap order deltasone 5mg online cheap
buy deltasone 5mg - permethrin cream order permethrin
order acticin generic - generic retin gel retin online order
betamethasone 20 gm generic - betamethasone 20gm usa monobenzone online
buy metronidazole - cenforce sale cenforce 100mg price
buy augmentin pill - clavulanate for sale purchase synthroid pills
cleocin 300mg for sale - cleocin 150mg uk indocin order online
buy hyzaar paypal - cephalexin 500mg without prescription order cephalexin 125mg online
buy eurax online - how to buy bactroban ointment buy aczone generic
order provigil 100mg - buy promethazine 25mg online cheap purchase melatonin generic
bupropion price - purchase shuddha guggulu purchase shuddha guggulu for sale
order capecitabine 500 mg without prescription - generic capecitabine 500mg danazol 100mg brand
how to buy prometrium - buy generic clomiphene online buy clomiphene pills
order alendronate without prescription - tamoxifen 20mg canada buy generic provera 10mg
buy aygestin online - lumigan allergy spray yasmin online order
dostinex 0.5mg generic - buy generic premarin alesse medication
order estrace 1mg pills - oral anastrozole 1 mg buy anastrozole pills for sale
バイアグラ 薬局で買える - シアリス おすすめ シアリス おすすめ
гѓ—гѓ¬гѓ‰гѓ‹гѓі гЃЇйЂљиІ©гЃ§гЃ®иіј - гѓ—гѓ¬гѓ‰гѓ‹гѓійЂљиІ© г‚ўг‚ёг‚№гѓгѓћг‚¤г‚·гѓігЃ®йЈІгЃїж–№гЃЁеЉ№жћњ