About: Rick Hardman

Update Monday morning:

Hi Bruce,

I went to GoDaddy asking what is going on. They sent a link to sign directly into WordPress which returns a screen saying that I don’t have permissions to go any further. Then they disconnected the S2-Pro plugin files and I tried to sign into WordPress directly and received the same message.

They tell me that S2 has changed the user profile in the data base and moved line 0 so now to find and decipher the permissions will be very difficult to do.

We’re way over my head at this point so they recommend I shut everything down and start my site over from the beginning.

He said that most security programs have a back door so I don’t know if that can help in this situation…

Can you tell me what your view of the situation is?

Thanks,

Rick

WAIT…i found Godaddy instructions to do this….I’ll be right back….R

Hi Bruce,

Calling Godaddy we changed the password and the Log in doesn’t recognize the username as verified (by godaddy).

They said that they don’t know how to manually install WordPress.

Can you tell me where to find instructions….?

Rick

• This reply was modified 4 years, 1 month ago by  Rick Hardman.

Thank you Sir,

I’ve gone in several times first making the alterations to the original user and then I tried by creating new users. The login still brings me to the home page with a Log in / Register option at the top left of the screen.

I did notice something I hadn’t seen before, on the wp_user page there is a warning in yellow with a red border that says, “The following indexes appear to be equal and one of them should be removed: user_login, user_login_key”

I’ve made a screen print of each step (and the yellow warning) if you would like to see them.

I also called GoDaddy about the yellow warning and they said that they cannot help with that. They also told me that their system only has the capability of using one admin and that all other users will have a lower level of access. He also said that he doesn’t have the experience needed and that whoever I’m dealing with (i.e. you) knows much more than he does….

In addition to the account I created, it does show an “admin” user but I don’t have that password information.

Rick

• This reply was modified 4 years, 1 month ago by  Rick Hardman.
• This reply was modified 4 years, 1 month ago by  Rick Hardman.

Hi Bruce,

Godaddy walked me through the process (specifically listed below). I added a new user (Rick) and password and then went in and listed the privileges (’10’ as specified). I can login and now we get through the login screen but only end up on the generic home page (subdomain.whydoidate.com) without any admin (or subscriber) capabilities.

As specified in the instructions, I enter through subdomain.whydoidate.com/wp-admin. It then forwards me to the S2 Login screen (as I believe is appropriate).

I don’t see anywhere to attach a graphic so I’ll email you a screen print of the recorded alterations from the SQL pages.

FYI: The login I had for “Connie” still flickers and remains on the Login screen.

Whatcha think?

Thanks,

Rick

Specific instructions you provided:
We will need to insert a row into the database with our admin users information. Click on the “Insert” tab in order to bring up the phpMyAdmin insert form. Insert the following information:

user_login – this is the username you want to use to access WordPress
user_pass – this is the password you want to use to access WordPress (be sure to select MD5 from the phpMyAdmin Function menu – WordPress stores passwords with MD5 encryption)
user_nicename – put whatever you would like to refer to yourself as in here (not your username)
user_email – this is the email account associated with this user
user_url – the url to your website like – http://www.dnawebagency.com
user_registered – when was this user registered – just select a date with the date selector
user_activation_key – you can leave this blank
user_status – leave this set to 0
display_name – usually I set this to whatever my user_nicename is

Ok now that you have got all of that information entered you will need to hit the “Go” button at the bottom of the phpMyAdmin window. You should be redirected to a page that shows the results of your query. If there are no errors continue with editing the wp_usermeta table.
Editing the wp_usermeta table

So now that we have inserted our user we will need to give it privileges to access the WordPress Admin seciton. This is done through the wp_usermeta table. You will need to know the id of the user you just created. If you don’t know the id now would be a good time to check the wp_users table for it. We will need to insert two rows into the wp_usermeta table, wp_capabilities and wp_user_level. Here are the steps you will need to follow to give your user privileges.

Click on the wp_usermeta table to bring up the entries.
Click on the “Insert” tab to insert a new row.
Fill in the following information
umeta_id – leave this blank it is automatically generated
user_id – this is the id of the user you created in the previous steps
meta_key – for this step insert wp_capabilities
meta_value – insert exactly this – a:1:{s:13:”administrator”;b:1;}
Insert another row with this information
umeta_id – leave this blank it is automatically generated
user_id – this is the id of the user you created in the previous steps
meta_key – for this step insert wp_user_level
meta_value – insert 10
Click the “Go” button in phpMyAdmin to insert the row.

Now you should be able to login to your wp-admin page with the username and password you specified for this user. After logged in I would visit the Users section within WordPress, click edit on the user I just added, and click the Update Profile button at the bottom of the screen. This will allow WordPress to go through and add some more information and “clean up” the user we just added.

• This reply was modified 4 years, 1 month ago by  Rick Hardman.
• This reply was modified 4 years, 1 month ago by  Rick Hardman.
• This reply was modified 4 years, 1 month ago by  Rick Hardman.
• This reply was modified 4 years, 1 month ago by  Rick Hardman.
• This reply was modified 4 years, 1 month ago by  Rick Hardman.

I went to Godaddy (since my theme runs on their copy of WordPress) to make your revisions and they said that their version of WP may not be compatible with my theme which was just released 5 days ago. I’ve gone back to Elegant themes to download a copy that was available after the copy I had been using and the version I downloaded today. This “2.9” is out there so I’ll give it a go to see if the login issue remains.

I’ll let you know how it goes.

Thanks again,

Rick

Thank you Bruce,

I tried the http://yoursite.com/wp-login.php (http://subdomain.whydoidate.com/wp-login.php) with the same result. We have a temp page at http://www.whydoidate.com while I work on the theme over at subdomain.whydoidate.com. I’ve always logged into the S2 page at subdomain.whydoidate.com/wp-login.php.

Reading the article you provided was very helpful. Thanks.

Do you have any other idea what I might try?

Rick