Sounds like the auto increment handling is not setup correctly.
Go into phpMyAdmin and make sure that the PRIMARY KEY is set to AUTO_INCREMENT
You can also run this SQL command:
ALTER TABLE wp_users AUTO_INCREMENT = 1
The 1 above you need to make sure the auto increment value is set to the highest number +1 in that table under id, see here for specifics on that:
Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
You could also try starting from a fresh install and on import make sure you set it to update, as well as making sure when the db was exported by that person, under Structure that they select Add AUTO_INCREMENT values before exporting
Related Posts:
- MySQL Database User: Which Privileges are needed?
- Use mulitple usernames?
- Adding prefix to WordPress database tables breaks admin capabilities?
- A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- Correct permissions for SQLite database
- MySQL Database User: Which Privileges are needed?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Why is my database import losing text widget data?
- Get error messages when $wpdb->insert() returns false?
- Does dbDelta delete columns as well?
- Insert data in database using form
- how can get database name in wordpress?
- Special characters in WordPress UTF-8 [closed]
- Long option names fail silently?
- Upload files – total size limit – WordPress/Contact Form 7
- Extend the wp_users table
- Relationship between performance and database size
- Database sync between local and production
- WordPress and automated MySQL backups to a different host
- Scheduling posts in database
- Size article thumbnails and retrieve them directly from database
- Should I be able to run two different “close” code versions of wordpress with the same DB
- Query from a different database than the default
- Need of separate security plugins for both root and subfolder sites WordPress?
- Escaping / encoding data before insert into a database?
- how to store arrays into a database
- Error: SELECT SQL_CALC_FOUND_ROWS
- Where are WP_Errors Saved
- Get all images from this database table
- Delete transients in website
- Error establishing database connection – high traffic?
- Switching database on the fly
- Replace/Mute/Stop Search Query
- Populate dropdown from database
- How to merge two WordPress databases with the same structure?
- Finding the original login information in the database
- wordpress ‘database update required’ loop after update
- Database Table for customer user
- Is there a solution to auto-post data to a WP post from a database
- How to Access wp_usermeta Data Immediately After a New User is Created
- Cleanup: best way to remove WooCommerce comments from the wp_comments table
- How to prevent/delay MySQL connections when an object cache is used?
- How to paginate information obtained from a query to a custom table?
- How can I show related posts from multiple separate installations
- Uknown meta entries in wp_postmeta
- WordPress site URL changed; how to fix it without database access?
- Error establishing a database connection,
- Create table with dbDelta,can’t put any DEFAULT data
- Post Views / Hit Counter Problem?
- Trying to create a custom meta table for working with a custom table
- Connecting to a different database
- What is the purpose of the “term_id” column in the “wp_term_taxonomy” table?
- Link image with data from the wpdb
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Regenerate user_nicename column
- Create Pages for database content
- Should I use an additional column in the DB?
- Storing user submitted forms [closed]
- User Tracking for Custom Post Type “Lesson”. Database Queries and Performance
- How to add checkbox with multiple values in table?
- Re-creating a WordPress database
- Can’t log into wordpress site – I have made a new user and still cant access
- How to save EXIF metadata in WordPress database?
- Export WP Subsite DB Fully Ready for Import Elsewhere
- Sed Command Not Writing Changes to SQL file
- Realtime database update from 3rd party apps (notion, airtable, sheet, etc)
- Join Query on WP_USERMETA Table
- Recurring 502 Bad Gateway issue
- Error during installation (DB)
- WordPress Settings API Overrides My Previous Value
- Move Non-WordPress users table to WordPress database
- Is there an actual way to synchronize ‘production’ and ‘develop’ WordPress databases?
- Lost database connection
- is it possible to install new WordPress in an old WordPress folder?
- Can someoene please help with customization of a post?
- Duplicate database to roll back theme & content changes
- Character encoding issue – black diamond question marks on imported post excerpts
- WordPress Migration – Issue with admin panel changes
- mySQL database size large, but tables size less
- Error establishing database connection error during first WordPress run
- Reinstall wordpress/mySQL caused database problem
- How To connect to the same WordPress database with different database user
- How much post meta data is too much?
- I have include wp-config, should I add global $wpdb also?
- Localize strings from db
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- version control for wordpress? (wordpress folder and database at same time)
- How to have WP Search widget index dynamically generated content?
- Preventing concurrent update of data
- Redirect Issue: WordPress database
- Category not displaying in add post, edit post, and categories page.
- Install WordPress with SQL database
- Creating Job Tickets
- Best db table structure for users with many records
- Prevent creation of unused database tables?
- How to store a plain password in WordPress database in another field
- How to stop WordPress from using utf8mb4_unicode_ci collation
- WP Multisite Users Not Linking