MySQL error

Status
Not open for further replies.

mash-e1

Active Member
163
2009
1
0
i tried to restore my data base thorugh myPHPAdmin and i got this erro after i upload my mySQL files

Code:
Error

SQL query:

# # Dumping data in `smf_log_search_subjects` # INSERT INTO `smf_log_search_subjects` (`word`, `ID_TOPIC`) VALUES (0, 12), (0, 31), (0, 165), (0, 244), (0, 245), (0, 557), (01, 470), (01, 522), (02, 430), (02, 486), (02, 519), (0207, 310), (03, 406), (09, 32), (09, 279), (09, 406), ('0a31', 558), (1, 34), (1, 37), (1, 244), (1, 522), (1, 548), (1, 557), (10, 222), (10, 307), (10, 385), (10, 461), (10, 494), (10, 522), (1000, 210), ('1080p', 136), ('1080p', 151), ('1080p', 277), ('1080p', 285), ('1080p', 286), ('1080p', 287), ('1080p', 371), ('1080p', 389), ('1080p', 390), ('1080p', 413), ('1080p', 425), ('1080p', 473), ('1080p', 488), ('1080p', 489), ('1080p', 504), ('1080p', 535), ('1080p', 548), (13, 223), ('13th', 373), ('13th', 464), (15, 32), (15, 59), (15, 195), (17, 279), (1977, 195), (1988, 155), (1990, 228), (1991, 371), (1995, 197), (1995, 286), [...]

MySQL said: Documentation
#1062 - Duplicate entry '1-522' for key 1

any one know to fix it or why i am getting this
 
2 comments
Your system trying to input something that is already in the database! IE user id 1 and not auto incrementing correctly


try empty the database and re-import again
when done , repair the database
Try that it should resolve the issue.
 
Status
Not open for further replies.
Back
Top