PriMoThemes — now s2Member® (official notice)

This is now a very OLD forum system. It's in READ-ONLY mode.
All community interaction now occurs at WP Sharks™. See: new forums @ WP Sharks™

Admin status lost

s2Member Plugin. A Membership plugin for WordPress®.

Admin status lost

Postby Nige » May 11th, 2010, 5:22 am

Nice pluggin - very nice!

Just one comment:

If you test the system from being logged in as admin, when you are redirected back from paypal you have lost your admin status. I setup a second admin beforehand so was lucky. Is this worth a look at?
Nige
Guest User
Guest User
 

Re: Admin status lost

Postby rossagrant » May 11th, 2010, 9:19 am

This is because you ran the transaction whilst being logged in as admin. Make sure you arren't logged in before going through Paypal.
User avatar
rossagrant
Experienced User
Experienced User
 
Posts: 127
Joined: May 5, 2010

Re: Admin status lost

Postby Jason Caldwell » May 13th, 2010, 12:39 am

Ross is correct.
We are going to make this impossible in the next release.
Thanks for reporting this important issue.
~ Jason Caldwell / Lead Developer
& Zeitgeist Movie Advocate: http://www.zeitgeistmovie.com/

Is the s2Member plugin working for you? Please rate s2Member at WordPress.org.
You'll need a WordPress.org account ( comes in handy ). Then rate s2Member here Image
.
User avatar
Jason Caldwell
Lead Developer
Lead Developer
 
Posts: 4045
Joined: May 3, 2010
Location: Georgia / USA

Re: Admin status lost

Postby JanM » May 14th, 2010, 1:18 am

I have the same problem but I have no 2nd administrator now I cannot access my blog anymore I need this fixed urgently please any help
JanM
Guest User
Guest User
 

Re: Admin status lost

Postby HTMwebrat » May 14th, 2010, 1:48 am

Can you go into phpmyadmin and bring back the admin status that way?
Back up your database before making any changes, however!

Look under wp_usermeta, find the user_id column with 1 (there are a few entries with this) and see what it says under column meta_key wp_capabilities. If it has something like s2member_level1, try changing it to -

a:1:{s:13:"administrator";b:1;}

(note that this is my setting and I'm not sure what the other things in there mean, I'm new to Wordpress myself, t his is also assuming that your admin account was the default first user).
Last edited by HTMwebrat on May 14th, 2010, 2:02 am, edited 1 time in total.
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby JanMetten » May 14th, 2010, 2:02 am

Yes this solved the problem thank you so much
User avatar
JanMetten
Registered User
Registered User
 
Posts: 1
Joined: May 14, 2010

Re: Admin status lost

Postby HTMwebrat » May 14th, 2010, 2:03 am

Excellent, glad it worked!
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby fasterpc » May 14th, 2010, 4:08 am

I have the same problem, but cannot understand what I need to do to log in as admin. Can you pleaes explain in laymen terms?

I'm not sure where to find phpmyadmin?

Thanks,

Stewart
fasterpc
Guest User
Guest User
 

Re: Admin status lost

Postby HTMwebrat » May 14th, 2010, 4:51 am

Who is your web host? If you log into your hosting account's control panel, there should be an area where it talks about MySQL databases and phpmyadmin will be under there. If your account doesn't have a control panel, you might have to ask them for the link and login info to phpmyadmin.
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby fasterpc » May 15th, 2010, 4:16 am

I use Host Gator and can acces my PHP admin ok. I changed id 1 wp_capabilities to: a:1:{s:13:"administrator";b:1;} as suggested but still i cannot log in as admin.

Is there a way to set up a new admin username and password from here?

Thanks.
User avatar
fasterpc
Registered User
Registered User
 
Posts: 5
Joined: May 15, 2010

Re: Admin status lost

Postby fasterpc » May 15th, 2010, 4:21 am

I actually changed wp_capabilities under user_id column with 4 by mistake, and of course I did not back up that original info so i cannot change it back to what it should be. Will this cause a problem?
User avatar
fasterpc
Registered User
Registered User
 
Posts: 5
Joined: May 15, 2010

Re: Admin status lost

Postby HTMwebrat » May 15th, 2010, 5:55 am

I would suggest changing it to something like -
a:1:{s:10:"subscriber";b:1;}

(this was a test subscriber account I made with no privileges)

so they're a subscriber without admin status. Look at the nickname for that ID, is that an account you made, or one of your users? If it's left as administer, that means that person will have admin privileges.
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby fasterpc » May 15th, 2010, 9:46 am

Ok thanks, I changed that back.

Does anyone know if I can create a new admin username and password so i can log in to my site? Steps to do this would be a great help.

Thanks again.
User avatar
fasterpc
Registered User
Registered User
 
Posts: 5
Joined: May 15, 2010

Re: Admin status lost

Postby HTMwebrat » May 15th, 2010, 11:33 am

SQL query to run in phpmyadmin, when you go into your database, there's a tab says SQL, you can enter this there -

http://wordpress.org/support/topic/209856?replies=5
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby fasterpc » May 16th, 2010, 6:18 am

Thanks for this info. But as someone that's new to PHP can anyone tell me how to insert this information so that it actually works.

I have tried every way I can think of without success. I need the actual steps to insert the info once logged into my PHP admin, selecting wp_usermeta, then clicking on the SQL tab...

This is where I need help, on how to insert the following... What goes where? What needs to be removed (commas, brackets, etc), what's stays?

INSERT INTO 'wp_usermeta'('umeta_id','user_id','meta_key','meta_value') VALUES
(1, 1, 'nickname', 'admin'),
(2, 1, 'rich_editing', 'true'),
(3, 1, 'admin_color', 'fresh'),
(4, 1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(5, 1, 'wp_user_level', '10');

Step by step help would be greatly appreciated.
User avatar
fasterpc
Registered User
Registered User
 
Posts: 5
Joined: May 15, 2010

Re: Admin status lost

Postby HTMwebrat » May 16th, 2010, 6:41 am

This link is more in-depth, hope it helps -
http://www.dnawebagency.com/how-to-add- ... s-database
User avatar
HTMwebrat
Registered User
Registered User
 
Posts: 23
Joined: May 5, 2010
Location: Gettysburg, PA, USA

Re: Admin status lost

Postby fasterpc » May 16th, 2010, 10:41 am

Many thanks for that step by step help. I finally got it.

See it's easy when you know how!

Regards,

Stewart
User avatar
fasterpc
Registered User
Registered User
 
Posts: 5
Joined: May 15, 2010

Re: Admin status lost

Postby Jason Caldwell » May 19th, 2010, 5:31 am

Jason Caldwell wrote:Ross is correct.
We are going to make this impossible in the next release.
Thanks for reporting this important issue.


Starting with s2Member v3.0. It is now impossible to lock yourself out.
Thanks to everyone that helped with this.
~ Jason Caldwell / Lead Developer
& Zeitgeist Movie Advocate: http://www.zeitgeistmovie.com/

Is the s2Member plugin working for you? Please rate s2Member at WordPress.org.
You'll need a WordPress.org account ( comes in handy ). Then rate s2Member here Image
.
User avatar
Jason Caldwell
Lead Developer
Lead Developer
 
Posts: 4045
Joined: May 3, 2010
Location: Georgia / USA


Return to s2Member Plugin

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 0 guests

cron