なんらかの原因で管理者ＩＤが使えなくなってしまった時はデータベースへ直接ＩＤを生成する必要があります。そんなときはこちらのクエリーを実行してください。
まずは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
バイアグラ 薬局で買える - シアリス おすすめ シアリス おすすめ
гѓ—гѓ¬гѓ‰гѓ‹гѓі гЃЇйЂљиІ©гЃ§гЃ®иіј - гѓ—гѓ¬гѓ‰гѓ‹гѓійЂљиІ© г‚ўг‚ёг‚№гѓгѓћг‚¤г‚·гѓігЃ®йЈІгЃїж–№гЃЁеЉ№жћњ
eriacta sparkle - sildigra fang forzest hedge
buy indinavir online cheap - purchase voltaren gel buy voltaren gel for sale
valif lunch - sustiva over the counter sinemet ca
ivermectine online - buy atacand cheap order tegretol 400mg online cheap
phenergan price - buy cheap generic lincomycin buy lincomycin
order prednisone 40mg pill - deltasone 5mg uk order capoten 25 mg
isotretinoin 20mg ca - zyvox 600mg over the counter where to buy zyvox without a prescription
oral amoxil - order valsartan 80mg pill order combivent pills
order zithromax generic - tindamax price order nebivolol 20mg online
oral omnacortil - order omnacortil 5mg online cheap buy prometrium medication
neurontin 100mg drug - order generic gabapentin 100mg itraconazole 100 mg generic
purchase lasix - piracetam 800mg without prescription betnovate without prescription
order augmentin pill - cymbalta 40mg cost brand cymbalta 20mg
order monodox online - oral glucotrol 10mg order glipizide 10mg online
rybelsus 14 mg brand - cyproheptadine pills buy cyproheptadine sale
order tizanidine online cheap - plaquenil uk microzide 25mg pill
order cialis 5mg - oral viagra 50mg order generic viagra 50mg
viagra sildenafil - cialis for daily use tadalafil 5mg cost
lipitor for sale online - lisinopril over the counter buy zestril 10mg without prescription
brand cenforce 100mg - glucophage 1000mg usa oral glycomet
buy prilosec 10mg without prescription - where can i buy prilosec buy atenolol no prescription
depo-medrol pill - lyrica 75mg oral order aristocort 10mg online
buy clarinex sale - clarinex 5mg usa purchase priligy online cheap
cytotec brand - diltiazem oral buy diltiazem 180mg without prescription
generic zovirax 800mg - order crestor 20mg online rosuvastatin 20mg us
order domperidone without prescription - buy motilium buy flexeril medication
motilium buy online - buy sumycin buy cyclobenzaprine online
purchase medex pills - purchase metoclopramide pills cheap losartan 25mg
levofloxacin over the counter - zantac cost how to buy zantac
buy nexium generic - generic topamax 200mg order sumatriptan 50mg for sale
valtrex drug - valtrex 500mg sale diflucan 200mg brand
provigil for sale order provigil 100mg online cheap provigil cost purchase modafinil generic buy modafinil cheap modafinil 100mg for sale provigil usa
clomiphene without dr prescription clomiphene only cycle clomid rx where can i get clomiphene tablets can i order clomiphene online where to buy clomiphene without prescription where to get clomid without prescription
More content pieces like this would insinuate the интернет better.
buy propranolol for sale - oral methotrexate methotrexate 2.5mg uk
buy cheap generic amoxil - amoxil online order buy ipratropium no prescription
order zithromax 250mg pill - buy bystolic 5mg online cheap buy nebivolol 5mg online
augmentin 1000mg over the counter - atbioinfo acillin oral
order nexium pill - anexamate.com where to buy nexium without a prescription
buy medex tablets - https://coumamide.com/ order cozaar
meloxicam 7.5mg drug - https://moboxsin.com/ how to buy mobic
deltasone canada - https://apreplson.com/ prednisone 10mg drug
buy ed pills sale - https://fastedtotake.com/ medication for ed dysfunction
buy fluconazole 100mg for sale - buy diflucan paypal buy diflucan 200mg
cenforce online buy - cenforce over the counter cheap cenforce 50mg
best place to buy liquid tadalafil - this buy cialis online free shipping
where to buy liquid cialis - https://strongtadafl.com/# cialis online reviews
buy zantac no prescription - click zantac online buy
buy in real viagra - https://strongvpls.com/# order viagra online illegal
This is the tolerant of advise I unearth helpful. como se toma el clomid
Greetings! Extremely productive advice within this article! It’s the petty changes which choice obtain the largest changes. Thanks a portion towards sharing! https://buyfastonl.com/
With thanks. Loads of knowledge! https://prohnrg.com/product/acyclovir-pills/
Good blog you possess here.. It’s severely to on great worth article like yours these days. I honestly respect individuals like you! Take guardianship!! https://ondactone.com/simvastatin/
This is the make of post I unearth helpful.
metoclopramide 20mg sale
This is the description of glad I have reading. http://bbs.51pinzhi.cn/home.php?mod=space&uid=7053893
order dapagliflozin 10mg - order dapagliflozin without prescription order dapagliflozin 10 mg sale
Thanks on putting this up. It’s understandably done. http://zqykj.cn/bbs/home.php?mod=space&uid=303418