Fix an MySQL issue: auto increment values gone

완료 등록 시간: 5년 전 착불
완료 착불

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

프로젝트 ID: #18616277

프로젝트 소개

23 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

수상자:

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 (1일 이내)
(15건의 리뷰)
5.9

이 일자리에 대한 프리랜서 23 명의 평균 입찰가: €30

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. 기타

€39 EUR (1일 이내)
(448 리뷰)
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 기타

€28 EUR (10일 이내)
(68 리뷰)
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 기타

€40 EUR (10일 이내)
(105 리뷰)
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 (1일 이내)
(29 리뷰)
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 (0일 이내)
(58 리뷰)
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 (101일 이내)
(23 리뷰)
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 (0일 이내)
(33 리뷰)
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 기타

€19 EUR (2일 이내)
(19 리뷰)
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 (2일 이내)
(16 리뷰)
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 기타

€24 EUR (10일 이내)
(6 리뷰)
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 (1일 이내)
(14 리뷰)
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 (1일 이내)
(2 리뷰)
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 (10일 이내)
(5 리뷰)
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 (1일 이내)
(1 리뷰)
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 (10일 이내)
(1 리뷰)
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 (0일 이내)
(0 리뷰)
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 (3일 이내)
(0 리뷰)
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 기타

€28 EUR (10일 이내)
(0 리뷰)
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 (1일 이내)
(0 리뷰)
0.0
sufyansiddiqui

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

€12 EUR (1일 이내)
(0 리뷰)
0.0