close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Super Admin missing PS4

Thread began 9/28/2010 5:15 am by rmcadams351257 | Last modified 9/30/2010 10:54 am by Ray Borduin | 1953 views | 10 replies |

rmcadams351257

Super Admin missing PS4

I just installed Power store 4. All went well upgrading from 3. Well all went well except my super admin username or password will not work. I have looked in the database and can only find two user groups 1 & 2. I'm kind of new to the whole database thing so I may be looking in the wrong place. can you help me get my Super admin back.
By the way I was happy to see that all my products and other info was transfered with out loss. but I need my Super Admin back
Thanks for all your help
Ron

Sign in to reply to this post

Jason ByrnesWebAssist

the supper admin username and password are stored in the wa_settings table. The super Admin is the username and password you enter during the install process.

Sign in to reply to this post

Ray BorduinWebAssist

Go to your database using phpmyadmin or whatever database utility you are most familiar with and look in the wa_settings table. See if you find two rows with a value for the "name" column of "adminusername" and "adminpassword" respectively.

If they don't exist, run this queries in the database:

INSERT INTO wa_settings (name, type, options, value, grp, subcategory, cond, description, variable, weight, spry_args, spry_error, help_text) VALUES ('admin_username', 'text', '', '[username]', 'Site Settings', null, null, '', 'Admin_Username', '72.00', ', \"none\", {isRequired:true, validateOn:[\"blur\", \"change\"]}', null, 'This is the Administrative Username that should be reserved for the website developer. Only this user will be able to modify the details of the Settings page. Additional administrative accounts can be created under the \'Users\' section of the PowerStore Admin - these users will not be able to modify these settings.');

INSERT INTO wa_settings (name, type, options, value, grp, subcategory, cond, description, variable, weight, spry_args, spry_error, help_text) VALUES ('admin_password', 'text', '', '[password]', 'Site Settings', null, null, '', 'Admin_Password', '73.00', null, null, null);

This will create the two entries and you can either update the [username] and [password] in the script before running it, or log in with those values and update it from the admin.

Sign in to reply to this post

rmcadams351257

both entrys are there but, no go

Both of the entrys are there in the database and look right, but it still will not work.

When I drect my web site to use the folder with Power store3 files in it, the admin pasword works. But if I derct my web site to the folder with the powerstore 4 files it does not. All the other users and products work just fine. just before you hit the enter key both boxes are green like it is going to work but no go.

Thanks for your help
Ron

Sign in to reply to this post

rmcadams351257

Screen shot

Here is a screen shot of the Database page, with admin passwords blurred.
Hope this helps
Ron

Sign in to reply to this post

Ray BorduinWebAssist

I have opened a support incident so that we can contact you and investigate this issue directly. Please update your incident with a good time and phone number to reach you.

Sign in to reply to this post

mick106153

Ray, I have the exact same problem!

Ray

I have the exact same problem so please include me in the discussion.
I'm against the wall right now.

Mick

Sign in to reply to this post

mick106153

Ray, This is urgent!

This is urgent!

Hammer's about to come down on me. I told everyone this would be easy. They keep pokin' their heads in here expecting miracles.

Frantic city

Mick

Sign in to reply to this post

Ray BorduinWebAssist

It was happening because of an upper-cased letter in the database entry. The new installer converts everything to lowercase, so the login has been updated to as well.

The solution is to update the setting to use a username and password in all lower case, or to remove lines 19-24 in the admin/index.php page.

Sign in to reply to this post

mick106153

Thanks Ray.

┬┐Que es "new installer"?
Should I put that in preferentially and does it contain other changes that would be of benefit.?

Mick

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...