You’ve posted some serialized arrays.
The first entry, a:1:{s:13:"administrator";s:1;}
is corrupted – that’s not a valid serialized array.
The second entry, a:1:{s:13:"administrator";s:1:"1";}
looks like this when unserialized:
array (
'administrator' => '1',
)
The third entry, a:1:{s:13:"administrator";b:1;}
looks like this when unserialized:
array (
'administrator' => true,
)
In my setup, capabilities are stored like your third example, a:1:{s:13:"administrator";b:1;}
. The underlying cause of your issue is probably related to the code that deals with how the user capabilities are being stored.
Related Posts:
- What’s the most efficient database method to add and query usermeta?
- Extend the wp_users table
- update_user_meta() does not work
- Select Multiple meta_value from WP DB; Single Query
- Is it possible to store visitors IPs in wp_postmeta table?
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- A field with dashes in the slug [closed]
- In what part of the WordPress core does the users table and usermeta table get joined?
- Modify Database in Multi-Site wp_usermeta table
- Best way to tell if a user account is active, using the database only
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- Is it safe to delete unnecessary user metadata?
- How to replicate a user plugin made table value, to this user’s custom meta table value?
- WordPress Database Huge wp_usermeta Table
- How to Access wp_usermeta Data Immediately After a New User is Created
- What can I do when an outside party hacks into my weblog and changes my display name?
- Users table missing from Database [closed]
- Recovering the table wp_usermeta from users
- Buddypress avatar image in database [closed]
- Storing user submitted forms [closed]
- wp_insert_user not creating account correctly when ID is manually set
- Compare User meta_value with Product meta_value
- Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
- Join Query on WP_USERMETA Table
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- generate PDF from member information
- How to get the id of recently registered user from database?
- update multiple user meta field based on another meta field
- get_user_meta and umeta_id
- Preventing concurrent update of data
- Calling update_user_meta inside of another function doesn’t work
- What is best for saving lot of extra detail of user?
- wp_usermeta key problem
- Query a meta key using an array of values where the database value is a string
- What is the difference between an ORM and an ODM?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Keeping WP database synced across multiple developers using git
- How to define composite keys with dbDelta()
- Connect forms in WP to external database
- Hook into $wpdb
- How to get site URL if database is disconnected?
- Is it wise to delete post revisions and autosaves from database?
- Multiple WP install with same users database
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- Can I transfer a mysql database to another site?
- Weird issue with database migration and SSL links
- Merge two databases: OLD SITE -> NEW SITE
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- How to use a different database to list and manage comments in the backend
- Error establishing a database connection on Installation
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- How do I find out the full path of a page’s template?
- Use mulitple usernames?
- Routine to convert custom post meta from old to new value
- “The link you followed has expired” & “Error while saving” messages when adding new post
- input data and output table [closed]
- sanitize POST arrays
- WP character encoding error after sharing post on Facebook �
- Sending data with multi step form to wp database
- WordPress query is not returning proper results
- Localhost to Staging to Development Dynamic WP-CONFIG
- can we add extra table or column in wordpress for adding our data
- Changing root password in PHPMyAdmin for WordPress Database when going live
- How to properly check if a table exists in WordPress Database using Show Tables Query
- multiple wordpress installation with shared usertable on an different database
- Insert Custom Data into wpusers
- Is it good practice to import/export a blog to test a redesign?
- Getting value from database table depending on field value
- Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
- Secure way to use name_save_pre?
- wpdb->insert not inserting first variable
- Database tables for sports betting integrated in WordPress
- change the year on all of my custom post types?
- New installation fatal error in 5.9.3 at edit or create entry
- Storing transients giving database error
- I want to replicate a wordpress website over multiple servers
- Is there anyway to split posts to different databases?
- wp-cli + valet: “Error establishing a database connection”
- local wordpress broke after changing URL
- Unable to login to a https website via the app after changing from http
- Is it safe to add INDEX to a column in WordPress database?
- Restore Old Database Over Newer WP & Plugin Files
- WP website showing blank page after moving from subdomain to main domain
- Database structure for thousands of posts
- How do I find out from my database what version of WordPress I need?
- How to create a database table?
- Extracted CSV as Array for Custom Query Loop
- Hang Up Followed By Can’t select database
- Database error after importing WordPress
- One WP Database outside localhost and two connections
- Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
- Create hundreds of users with just ID in phpMyAdmin
- Insert Extra fields added in the front end registration form to DB
- Cant Connect to Database
- WordPress database connection failed, while mysql client is working [closed]