Skip to content
WJunction - Webmaster Forum

MySQL error

Status
Not open for further replies.
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.

About the author

M
Active Member · Joined
163
Messages
1
Reactions
18
Points

Advertise on WJunction

Reach 1000's of webmasters, hosts & affiliates. Banner & sponsored-thread slots available.

Contact us
Back
Top Bottom