Fix an MySQL issue: auto increment values gone

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Hi,

I have an issue on a Wordpress site because of a DB issue. Various errors like:

[Duplicate entry '0' for key 'PRIMARY'] INSERT INTO wp_aiowps_login_activity (user_id, user_login, login_date, login_ip) VALUES ('2', 'michelp', '2019-01-21 16:38:59', 'xxx')

I took a look at the database, and I noticed that a lot of tables don't have AUTO_INCREMENT enabled anymore, and also the next AUTO_INCREMENT value is 0.

I all ready repaired a couple of tables like this:

ALTER TABLE wp_aiowps_login_activity AUTO_INCREMENT = 58, CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT

I have 114 tables. I need you to check each table and repair the AUTO_INCREMENT value where needed. I will provide you a copy of the DB so you can work on it locally. You probably need to compare with a fresh Wordpress DB (and plugins) to know which field should be auto increment.

Once the repair its done, I will import it in my installation and check if everything works and release the milestone if everything is ok.

Thanks

MySQL

Project ID: #18616277

About the project

23 proposals Remote project Active 5 years ago

Awarded to:

fadata

Hi I have 14 years of database design experience. I can fix your table auto increment problem in 1 hours Lets talk about the details Regards

€29 EUR in 1 day
(15 Reviews)
5.9

23 freelancers are bidding on average €30 for this job

mahamadali

I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,WordPress,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. More

€39 EUR in 1 day
(448 Reviews)
7.9
ankitbagre2000

Hey, employer. I already have read your description carefully. I have 5+ years enough experience in website development. My major skill is PHP. I am reliable freelancer you want. Now I am free, I will start More

€28 EUR in 10 days
(68 Reviews)
6.8
phpprogramming

hi there. I have faced similar problem for one of my employer. I have solved it for him. can you please send me your db backup. I will do it for you. did you installed a lot of plugins? let me know. I am re More

€40 EUR in 10 days
(105 Reviews)
6.2
akgarg007

Hi I am a php and mysql developer. I can fix your issue. I'll try my best to solve your issues as soon as possible. Please come in the chat box for more discussion. Thanks

€19 EUR in 1 day
(29 Reviews)
5.8
muhamed3uda

Hi, and now start fixing ..thanks you ...Hi, and now start fixing ..thanks you ...Hi, and now start fixing ..thanks you ...Hi, and now start fixing ..thanks you ...

€37 EUR in 0 days
(58 Reviews)
5.4
leemilun

I can fix your issue. I'll try my best to solve your issues as soon as possible. Please come in the chat box for more discussion. Thanks

€40 EUR in 101 days
(23 Reviews)
5.6
paid1234

Hi i can complete your project and can begin right now i am a fulltime freelance developer with 8 years experience and have completed similar projects in the past feel free to contact me thanks

€14 EUR in 0 days
(33 Reviews)
4.6
WCTech

Hi, Please share us existing site link and detail , i have all perfect skill for this project as well Will able to fix all bugs and do required updates. Share website link and credentials. Thanks:) Relevant More

€19 EUR in 2 days
(19 Reviews)
4.8
poojamishra13

Hi there, i am professional developer have 5+ years of experience in php mysql. I am ready to repair mysql tables auto increment issue right now please provide me database file. Thanks

€34 EUR in 2 days
(16 Reviews)
4.1
atulamol

Hello, lets start to solve your issues. I have More than Five years (5+ years) of experience in Professional Software Development. Seeking for a challenging position as a Java Developer with the strong working exp More

€24 EUR in 10 days
(6 Reviews)
3.7
nagendragoud999

I am available now and I can start it immediately and will fix this asap. I have good experience with mysql.

€20 EUR in 1 day
(14 Reviews)
3.7
MoustafaS

Hello, I can do this for you and deliver today. Available to start now, I am an expert in mysql. All I need is the mysql dump

€50 EUR in 1 day
(2 Reviews)
2.7
kdwebsolution9

Hello sir, Hope you are doing well. i have 6+ years of experience in WordPress php codeigniter html css mysql javascript bootstrap etc. these job suitable for me Kind Regards, purvi

€50 EUR in 10 days
(5 Reviews)
3.2
salimsrj

Hello, Good day. I guess your are facing an error in your mysql database. I am interested to solve this issue. Thanks Mahmudul Hasan

€24 EUR in 1 day
(1 Review)
2.4
anshsparkle

HELLO I CAN START RIGHT NOW - I AM EXPERT IN MySQL and I BET YOU CANNOT FIND BETTER FREELANCER THAN ME ... pLEASE MESSEGE ME AND LETS DISCUSS THE THINGS THANKS

€28 EUR in 10 days
(1 Review)
0.4
ersonaldeveloper

Hello there, Please share with me wp-admin, database details and FTP. It would be my pleasure to work with you. Thank You. Regards Sonal

€10 EUR in 0 days
(0 Reviews)
0.0
MadhaviRathore

I am an experienced professional in R programming language , predictive analytics ,SQL and statistics . I am also proficient in visualization dashboards using various tools like tableau , power bi .

€50 EUR in 3 days
(0 Reviews)
0.0
warvinder

Respected Hiring Manager, Thank you for this wonderful opportunity. I have extensive knowledge of Wordpress. I am able to do Website Design & Development. I’m ready to START RIGHT NOW. I have excellent experience in More

€28 EUR in 10 days
(0 Reviews)
0.0
fatemaqutbi

i have done Db administration certification. have expertise of more than 12 yrs in mysql send across the db to me, ill insert the auto increments and then send it across to u.

€40 EUR in 1 day
(0 Reviews)
0.0
sufyansiddiqui

Hello I am interested to do that project let's start to chat with me...................................................................................................................................................... More

€12 EUR in 1 day
(0 Reviews)
0.0