Fix an MySQL issue: auto increment values gone
€8-40 EUR
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
Project ID: #18616277
About the project
Awarded to:
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
23 freelancers are bidding on average €30 for this job
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
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
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
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
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 ...
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
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
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
I am available now and I can start it immediately and will fix this asap. I have good experience with mysql.
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
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
Hello, Good day. I guess your are facing an error in your mysql database. I am interested to solve this issue. Thanks Mahmudul Hasan
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
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
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 .
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.
Hello I am interested to do that project let's start to chat with me...................................................................................................................................................... More