sql error #1062 - Duplicate entry '5-2054' for key 1

Started by sarena, November 18, 2005, 06:06:29 AM

Previous topic - Next topic

sarena

im trying to use a sql backup of my live site for my test site, both are 1.1 rc1

the 30th of October one works, the one i tried yesterday doesnt i get the error
#1062 - Duplicate entry '5-2054' for key 1

SQL query:

#
# Dumping data in `smf_log_search_subjects`
#
INSERT INTO `smf_log_search_subjects` (

`word` ,
`ID_TOPIC`
)
VALUES ( 00353879567402, 1321 ) , ( 00353879567402, 1500 ) , ( 05, 2054 ) , ( 07903, 1198 ) , ( 07903, 1436 ) , ( 07903, 1637 ) , ( 07903, 1890 ) , ( 07903, 1919 ) , ( 07903, 2094 ) , ( 07903686136, 1437 ) , ( 07903686136, 1507 ) , ( 07919, 1447 ) , ( 1, 1259 ) , ( 1, 1498 ) , ( 1, 2047 ) , ( 1, 2098 ) , (
'1-2', 1421
), (
'1-2-1', 1260
), (
'1-2-1', 1445
), (
'1-2-1', 1939
), (
'1-2-1\'s', 1492
), (
'1-on-1', 1420
), ( 10, 871 ) , ( 100, 1426 ) , ( 100, 1452 ) , ( 100, 1464 ) , ( 100, 1469 ) , (
'10th', 1243
), ( 11, 2054 ) , ( 11, 2069 ) , (
'11th', 1243
), (
'12-4pm', 1142
), (
'12-4pm', 1433
), (
'12th', 1141
), (
'12th', 1142
), (
'12th', 1214
), (
'12th', 1281
), (
'12th', 1433
), (
'12th', 1447
), (
'12th', 1574
), (
'13-17', 1115
), ( 136, 1198 ) , ( 136, 1637 ) , ( 136, 1890 ) , ( 136, 1919 ) , ( 136, 2094 ) , (
'13th', 1281
), (
'13th', 1509
), ( 14, 1434 ) , ( 14, 1864 ) , (
'14-16th', 2092
), (
'14th', 1128
), (
'14th', 1154
), (
'14th', 1439
), (
'14th', 1447
), (
'14th', 2104
), (
'14th-16th', 2027
), (
'14th-19th', 2007
), (
'15th', 1436
), (
'16-8-05', 1261
), (
'16th', 1435
), (
'16th-18th', 1225
), (
'17-8-05', 1260
), (
'17th', 1282
), (
'17th', 1390
), (
'17th', 2040
), (
'17th', 2041
), ( 18, 864 ) , ( 18, 2009 ) , ( 18, 2069 ) , ( 18, 2070 ) , ( 18, 2104 ) , ( 18, 2119 ) , (
'18-40', 1913
), (
'18-year-old', 1618
), (
'18to25', 1099
), ( 19, 1309 ) , (
'19-20', 1299
), (
'19th-21st', 1103
), (
'19yrold', 1247
), (
'1st', 2022
), ( 2, 518 ) , ( 2, 1128 ) , ( 2, 1258 ) , ( 2, 1261 ) , ( 2, 1446 ) , ( 2, 1498 ) , ( 2, 1509 ) , ( 2, 2063 ) , ( 2, 2103 ) , ( 20, 1948 ) , ( 20, 1949 ) , ( 20, 1999 ) , ( 20, 2048 ) , ( 20, 2049 ) , ( 20, 2050 ) , ( 2005, 1103 ) , ( 2005, 1141 ) , ( 2005, 1234 ) , ( 2005, 1940 ) , ( 2005, 2035 ) , ( 2005, 2069 ) , ( 2005, 2117 ) , (
'20th', 1930
), (
'20yrs', 1906
), (
'20yrs', 1907
), (
'20yrs', 2047
), ( 21, 1339 ) , (
'21-24th', 2092
), (
'21st', 1128
), (
'21st', 1161
), (
'21st', 1532
), (
'21st', 1890
), (
'21st', 1930
), (
'21st', 2099
), (
'22-9-05', 1366
), (
'22nd', 1175
), (
'22nd', 1437
), (
'22nd', 1446
), (
'22nd', 1507
), (
'22nd', 2119
), ( 23, 1297 ) , ( 23, 1378 ) , ( 23, 1386 ) , ( 23, 1506 ) , ( 23, 1600 ) , (
'23rd', 2095
), ( 24, 2094 ) , ( 24, 2103 ) , (
'24th', 2094
), (
'24yrs', 1419
), (
'25th', 1136
), (
'25th', 1199
), (
'25th', 1200
), ( 26, 2113 ) , ( 27, 1198 ) , ( 27, 2123 ) , (
'27th-29th', 1537
), (
'28-9-05', 1364
), (
'28-9-05', 1365
), (
'28th', 1445
), ( 29, 2006 ) , (
'29th', 1637
), (
'29th', 2103
), (
'2hrs', 1285
), (
'2morow', 2024
), (
'2nd', 1520
), (
'2nd', 2008
), (
'2nd', 2024
), ( 3, 1098 ) , ( 3, 1155 ) , ( 3, 1302 ) , ( 3, 1574 ) , ( 3, 2107 ) , ( 30, 2006 ) , (
'30-50', 1909
), (
'30th', 1136
), (
'30th', 2117
), (
'30yr', 1301
), (
'31st', 1940
), ( 35, 1971 ) , ( 36, 1397 ) , ( 36, 1648 ) , ( 37, 2060 ) , (
'38j', 1587
), (
'3rd', 1388
), (
'3sums', 1154
), ( 4, 978 ) , ( 4, 985 ) , ( 4, 1174 ) , ( 4, 1224 ) , ( 4, 1297 ) , ( 4, 1373 ) , ( 4, 1374 ) , ( 4, 1378 ) , ( 4, 1380 ) , ( 4, 1473 ) , ( 4, 1595 ) , ( 4, 1600 ) , ( 4, 1872 ) , ( 40, 1269 ) , ( 40, 1313 ) , (
'40\'s', 1625
), (
'400gbp', 1511
), (
'400gbp', 1512
), (
'40ff', 1624
), ( 46, 1624 ) , (
'48hr', 2102
), (
'4th', 1203
), (
'4th', 1234
), (
'4th', 1240
), ( 5, 1142 ) , ( 5, 1198 ) , ( 5, 1234 ) , ( 5, 1259 ) , ( 5, 1436 ) , ( 5, 2054 ) , ( 5, 2095 ) , ( 50, 919 ) , ( 50, 1201 ) , ( 50, 2074 ) , ( 546273, 1447 ) , (
'5th', 1203
), ( 6, 1174 ) , ( 6, 2054 ) , (
'6-7th', 2048
), (
'6-7th', 2050
), ( 60, 1995 ) , ( 60, 2053 ) , ( 686, 1198 ) , ( 686, 1637 ) , ( 686, 1890 ) , ( 686, 1919 ) , ( 686, 2094 ) , ( 686136, 1436 ) , (
'6ft', 2107
), (
'6th', 1203
), (
'6th-7th', 2047
), ( 7, 1198 ) , ( 70, 1215 ) , (
'7pm-10pm', 1302
), (
'7th', 1363
), (
'8th', 1132
), (
'8th', 1244
), (
'8th', 1375
), (
'8th', 1395
), (
'8th', 1426
), (
'8th', 2028
), (
'8th-9th', 1430
), (
'9th', 2039
), (
'9th', 2063
), (
'a', 595
), (
'a', 1093
), (
'a', 1115
), (
'a', 1142
), (
'a', 1143
), (
'a', 1198
), (
'a', 1207
), (
'a', 1208
), (
'a', 1210
), (
'a', 1216
), (
'a', 1219
), (
'a', 1221
), (
'a', 1228
), (
'a', 1232
), (
'a', 1234
), (
'a', 1237
), (
'a', 1295
), (
'a', 1382
), (
'a', 1420
)


only difference between the two backups that i have done is to install the mysql patch, i have tried removing that but same error
can anybody shed any light on it please?

Advertisement: