duplicate entries on required SQL updates

[chrsschb]

Updating my source finally to bring bots back and add in queryserv, I'm updating from 2136. I made it all the way to 2176_required_aa_updates.sql. Every line is giving me a 1062 - Duplicate entry '1587-1' for key 'NewIndex' error (obviously the number changes, but still).

I'm under the impression I shouldn't be receiving these errors for this update since I'm updating from a vastly older version.

Should I ignore it and press on or alter it some how?

[sorvani]

there were a few things redone on the AA updates as I recall. something might just be in there twice.

[chrsschb]

Originally Posted by sorvani

there were a few things redone on the AA updates as I recall. something might just be in there twice.

I figured as much, just skipped the duplicates and moved on.

[wolfwalkereci]

from 2176 to 2188 there are a few conflicts but a quick edit of the .sql will take care of that for you. Cant find my notes on it but didnt take but a minute to manually edit.

[chrsschb]

Originally Posted by wolfwalkereci

from 2176 to 2188 there are a few conflicts but a quick edit of the .sql will take care of that for you. Cant find my notes on it but didnt take but a minute to manually edit.

Yeah I know. I edited out the duplicates. There was another sql file around the 2180 range that was erroring out due to bad syntax so had to edit that one too.

[wolfwalkereci]

Yeah it happens I guess. Tbh that was the first time I think I had to edit the sql other then as instructed on the changelog. Hows your project coming along?

[chrsschb]

Originally Posted by wolfwalkereci

Yeah it happens I guess. Tbh that was the first time I think I had to edit the sql other then as instructed on the changelog. Hows your project coming along?

My project has been live for 4 years. The population on the other hand has it's ups and downs

[Kayen]

There shouldn't be too many duplicates with the AA sql's, maybe a handful in the early ones for a few redundancies.

Almost everything in those files are new entries for the aa_effects table for AA's that are now handled via the table and not the source.

Take a look at your table and make sure it is filled with what is in those sql's, obviously if you ran it twice by accident you would be getting those errors that is really the only way I could see that occurring. If you think something else is going on, feel free to send me a dump of your table and I will check it out.

Without those SQL your AA's will not be working correctly.

Kayen

[chrsschb]

Originally Posted by Kayen

There shouldn't be too many duplicates with the AA sql's, maybe a handful in the early ones for a few redundancies.

Almost everything in those files are new entries for the aa_effects table for AA's that are now handled via the table and not the source.

Take a look at your table and make sure it is filled with what is in those sql's, obviously if you ran it twice by accident you would be getting those errors that is really the only way I could see that occurring. If you think something else is going on, feel free to send me a dump of your table and I will check it out.

Without those SQL your AA's will not be working correctly.

Kayen

My server doesn't use AA's (yet) so it's a minor inconvenience.

This is what I see and I got duplicate entries the very first time I ran the sql updates:

1	2	1	4	2	0
2	3	1	4	4	0
3	4	1	4	6	0
4	5	1	4	8	0
5	6	1	4	10	0
6	7	1	7	2	0
7	8	1	7	4	0
8	9	1	7	6	0
9	10	1	7	8	0
10	11	1	7	10	0
11	12	1	6	2	0
12	13	1	6	4	0
13	14	1	6	6	0
14	15	1	6	8	0
15	16	1	6	10	0
16	17	1	5	2	0
17	18	1	5	4	0
18	19	1	5	6	0
19	20	1	5	8	0
20	21	1	5	10	0
21	22	1	8	2	0
22	23	1	8	4	0
23	24	1	8	6	0
24	25	1	8	8	0
25	26	1	8	10	0
26	27	1	9	2	0
27	28	1	9	4	0
28	29	1	9	6	0
29	30	1	9	8	0
30	31	1	9	10	0
31	32	1	10	2	0
32	33	1	10	4	0
33	34	1	10	6	0
34	35	1	10	8	0
35	36	1	10	10	0
36	37	1	46	2	0
37	38	1	46	4	0
38	39	1	46	6	0
39	40	1	46	8	0
40	41	1	46	10	0
41	42	1	47	2	0
42	43	1	47	4	0
43	44	1	47	6	0
44	45	1	47	8	0
45	46	1	47	10	0
46	47	1	50	2	0
47	48	1	50	4	0
48	49	1	50	6	0
49	50	1	50	8	0
50	51	1	50	10	0
51	52	1	48	2	0
52	53	1	48	4	0
53	54	1	48	6	0
54	55	1	48	8	0
55	56	1	48	10	0
56	57	1	49	2	0
57	58	1	49	4	0
58	59	1	49	6	0
59	60	1	49	8	0
60	61	1	49	10	0
61	62	1	271	8	0
62	63	1	271	14	0
63	64	1	271	21	0
64	65	1	0	1	0
65	66	1	0	2	0
66	67	1	0	3	0
67	71	1	246	110	0
68	72	1	246	125	0
69	73	1	246	150	0
70	89	1	15	1	0
71	90	1	15	2	0
72	91	1	15	3	0
73	104	1	127	5	0
74	104	2	140	1	0
75	104	3	143	4000	0
76	104	4	138	1	0
77	105	1	127	10	0
78	105	2	140	1	0
79	105	3	143	4000	0
80	105	4	138	1	0
81	106	1	127	15	0
82	106	2	140	1	0
83	106	3	143	4000	0
84	106	4	138	1	0
1101	107	1	214	200	0
1102	108	1	214	500	0
1103	109	1	214	1000	0
88	110	1	0	1	0
89	111	1	0	2	0
90	112	1	0	3	0
91	137	1	127	10	0
92	137	2	137	88	0
93	138	1	127	25	0
94	138	2	137	88	0
95	139	1	127	50	0
96	139	2	137	88	0
97	141	1	127	2	0
98	141	2	137	0	0
99	141	3	138	0	0
100	141	4	141	1	0
101	141	5	143	4000	0
102	142	1	127	5	0
103	142	2	137	0	0
104	142	3	138	0	0
105	142	4	141	1	0
106	142	5	143	4000	0
107	143	1	127	10	0
108	143	2	137	0	0
109	143	3	138	0	0
110	143	4	141	1	0
111	143	5	143	4000	0
112	147	1	127	10	0
113	147	2	138	1	0
114	147	3	143	4000	0
115	147	4	140	12	0
116	148	1	127	25	0
117	148	2	138	1	0
118	148	3	143	4000	0
119	148	4	140	12	0
120	149	1	127	50	0
121	149	2	138	1	0
122	149	3	143	4000	0
123	149	4	140	12	0
124	164	1	127	10	0
125	164	2	137	33	0
126	164	3	137	32	0
127	164	4	137	109	0
128	165	1	127	25	0
129	165	2	137	33	0
130	165	3	137	32	0
131	165	4	137	109	0
132	166	1	127	50	0
134	166	2	137	33	0
135	166	3	137	32	0
136	166	4	137	109	0
137	196	1	226	1	0
138	237	1	227	1	25
139	238	1	227	3	25
140	239	1	227	5	25
1268	270	1	270	10	0
1269	271	1	270	15	0
1270	272	1	270	25	0
144	278	1	0	1	0
145	278	2	15	1	0
1098	279	1	214	200	0
147	280	1	227	1	62
148	280	2	227	1	17
149	281	1	227	3	62
150	281	2	227	3	17
151	282	1	227	5	62
152	282	2	227	5	17
153	292	1	4	2	0
154	293	1	4	4	0
155	294	1	4	6	0
156	295	1	4	8	0
157	296	1	4	10	0
158	297	1	4	12	0
159	298	1	4	14	0
160	299	1	4	16	0
161	300	1	4	18	0
162	301	1	4	20	0
163	302	1	7	2	0
164	303	1	7	4	0
165	304	1	7	6	0
166	305	1	7	8	0
167	306	1	7	10	0
168	307	1	7	12	0
169	308	1	7	14	0
170	309	1	7	16	0
171	310	1	7	18	0
172	311	1	7	20	0
173	312	1	6	2	0
174	313	1	6	4	0
175	314	1	6	6	0
176	315	1	6	8	0
177	316	1	6	10	0
178	317	1	6	12	0
179	318	1	6	14	0
180	319	1	6	16	0
181	320	1	6	18	0
182	321	1	6	20	0
183	322	1	5	2	0
184	323	1	5	4	0
185	324	1	5	6	0
186	325	1	5	8	0
187	326	1	5	10	0
188	327	1	5	12	0
189	328	1	5	14	0
190	329	1	5	16	0
191	330	1	5	18	0
192	331	1	5	20	0
193	332	1	8	2	0
194	333	1	8	4	0
195	334	1	8	6	0
196	335	1	8	8	0
197	336	1	8	10	0
198	337	1	8	12	0
199	338	1	8	14	0
200	339	1	8	16	0
201	340	1	8	18	0
202	341	1	8	20	0
203	342	1	9	2	0
204	343	1	9	4	0
205	344	1	9	6	0
206	345	1	9	8	0
207	346	1	9	10	0
208	347	1	9	12	0
209	348	1	9	14	0
210	349	1	9	16	0
211	350	1	9	18	0
212	351	1	9	20	0
213	352	1	10	2	0
214	353	1	10	4	0
215	354	1	10	6	0
216	355	1	10	8	0
217	356	1	10	10	0
218	357	1	10	12	0
219	358	1	10	14	0
220	359	1	10	16	0
221	360	1	10	18	0
222	361	1	10	20	0
223	362	1	46	2	0
224	363	1	46	4	0
225	364	1	46	6	0
226	365	1	46	8	0
227	366	1	46	10	0
229	368	1	46	14	0
230	369	1	46	16	0
231	370	1	46	18	0
232	371	1	46	20	0
233	372	1	47	2	0
234	373	1	47	4	0
235	374	1	47	6	0
236	375	1	47	8	0
237	376	1	47	10	0
238	377	1	47	12	0
239	378	1	47	14	0
240	379	1	47	16	0
241	380	1	47	18	0
242	381	1	47	20	0
243	382	1	50	2	0
244	383	1	50	4	0
245	384	1	50	6	0
246	385	1	50	8	0
247	386	1	50	10	0
248	387	1	50	12	0
249	388	1	50	14	0
250	389	1	50	16	0
251	390	1	50	18	0
252	391	1	50	20	0
253	392	1	48	2	0
254	393	1	48	4	0
255	394	1	48	6	0
256	395	1	48	8	0
257	396	1	48	10	0
258	397	1	48	12	0
259	398	1	48	14	0
260	399	1	48	16	0
261	400	1	48	18	0
262	401	1	48	20	0
263	402	1	49	2	0
264	403	1	49	4	0
265	404	1	49	6	0
266	405	1	49	8	0
267	406	1	49	10	0
268	407	1	49	12	0
269	408	1	49	14	0
270	409	1	49	16	0
271	410	1	49	18	0
272	411	1	49	20	0
273	418	1	262	5	0
274	418	2	262	5	1
275	418	3	262	5	2
276	418	4	262	5	3
277	418	5	262	5	4
278	418	6	262	5	5
279	418	7	262	5	6
280	419	1	262	10	0
281	419	2	262	10	1
282	419	3	262	10	2
283	419	4	262	10	3
284	419	5	262	10	4
285	419	6	262	10	5
286	419	7	262	10	6
287	420	1	262	15	0
288	420	2	262	15	1
289	420	3	262	15	2
290	420	4	262	15	3
291	420	5	262	15	4
292	420	6	262	15	5
293	420	7	262	15	6
294	421	1	262	20	0
295	421	2	262	20	1
296	421	3	262	20	2
297	421	4	262	20	3
298	421	5	262	20	4
299	421	6	262	20	5
300	421	7	262	20	6
301	422	1	262	25	0
302	422	2	262	25	1
303	422	3	262	25	2
304	422	4	262	25	3
305	422	5	262	25	4
306	422	6	262	25	5
307	422	7	262	25	6
308	423	1	214	150	0
309	424	1	214	300	0
310	425	1	214	450	0
311	426	1	262	10	4
312	426	2	262	10	5
313	427	1	262	20	4
314	427	2	262	20	5
315	428	1	262	30	4
316	428	2	262	30	5
317	429	1	262	40	4
318	429	2	262	40	5
319	430	1	262	50	4
320	430	2	262	50	5
1271	568	1	270	30	0
1272	569	1	270	35	0
1273	570	1	270	40	0
324	622	1	227	1	29
325	623	1	227	2	29
326	624	1	227	3	29
327	628	1	290	5	0
328	629	1	290	15	0
329	672	1	271	7	0
330	673	1	271	14	0
331	676	1	246	125	0
332	677	1	246	150	0
333	978	1	14	1	0
334	1001	1	262	5	0
335	1001	2	262	5	1
336	1001	3	262	5	2
337	1001	4	262	5	3
338	1001	5	262	5	4
339	1001	6	262	5	5
340	1001	7	262	5	6
341	1002	1	262	10	0
342	1002	2	262	10	1
343	1002	3	262	10	2
344	1002	4	262	10	3
345	1002	5	262	10	4
346	1002	6	262	10	5
347	1002	7	262	10	6
348	1003	1	262	15	0
349	1003	2	262	15	1
350	1003	3	262	15	2
351	1003	4	262	15	3
352	1003	5	262	15	4
353	1003	6	262	15	5
354	1003	7	262	15	6
355	1004	1	262	20	0
356	1004	2	262	20	1
357	1004	3	262	20	2
358	1004	4	262	20	3
359	1004	5	262	20	4
360	1004	6	262	20	5
361	1004	7	262	20	6
362	1005	1	262	25	0
363	1005	2	262	25	1
364	1005	3	262	25	2
365	1005	4	262	25	3
366	1005	5	262	25	4
367	1005	6	262	25	5
368	1005	7	262	25	6
369	1006	1	262	5	7
370	1006	2	262	5	8
371	1006	3	262	5	9
372	1006	4	262	5	10
373	1006	5	262	5	11
374	1007	1	262	10	7
375	1007	2	262	10	8
376	1007	3	262	10	9
377	1007	4	262	10	10
378	1007	5	262	10	11
379	1008	1	262	15	7
380	1008	2	262	15	8
381	1008	3	262	15	9
382	1008	4	262	15	10
383	1008	5	262	15	11
384	1009	1	262	20	7
385	1009	2	262	20	8
386	1009	3	262	20	9
387	1009	4	262	20	10
388	1009	5	262	20	11
389	1010	1	262	25	7
390	1010	2	262	25	8
391	1010	3	262	25	9
392	1010	4	262	25	10
393	1010	5	262	25	11
394	1021	1	327	1	0
395	1022	1	327	2	0
396	1023	1	327	3	0
397	1024	1	327	4	0
398	1025	1	327	5	0
399	1071	1	326	1	0
400	1129	1	267	1	0
401	1130	1	267	2	0
402	678	1	221	1	0
403	679	1	221	2	0
404	680	1	221	3	0
405	681	1	221	4	0
406	682	1	221	5	0
407	807	1	292	5	0
408	808	1	292	10	0
409	809	1	292	15	0
1104	864	1	216	10	0
1112	865	1	216	20	0
1120	866	1	216	30	0
413	907	1	69	100	0
414	908	1	69	200	0
415	909	1	69	300	0
416	910	1	69	400	0
417	911	1	69	500	0
418	580	1	267	1	5
419	580	2	267	1	8
420	580	3	267	1	29
421	581	1	267	1	5
422	581	2	267	1	8
423	581	3	267	1	7
424	582	1	267	1	5
425	582	2	267	1	7
426	582	3	267	1	9
427	1435	1	339	8105	2
428	1435	2	134	70	0
429	1435	3	142	65	0
430	1435	4	137	0	0
431	1436	1	339	8105	4
432	1436	2	134	70	0
433	1436	3	142	65	0
434	1436	4	137	0	0
435	1437	1	339	8105	6
436	1437	2	134	70	0
437	1437	3	142	65	0
438	1437	4	137	0	0
439	1486	1	339	8165	2
440	1486	2	134	75	0
441	1486	3	142	60	0
442	1486	4	137	0	0
443	1486	5	141	0	0
444	1486	6	138	1	0
445	1487	1	339	8166	4
446	1487	2	134	75	0
447	1487	3	142	60	0
448	1487	4	137	0	0
449	1487	5	141	0	0
450	1487	6	138	1	0
451	1488	1	339	8167	6
452	1488	2	134	75	0
453	1488	3	142	60	0
454	1488	4	137	0	0
455	1488	5	141	0	0
456	1488	6	138	1	0
457	1489	1	339	8168	8
458	1489	2	134	75	0
459	1489	3	142	60	0
460	1489	4	137	0	0
461	1489	5	141	0	0
462	1489	6	138	1	0
463	1490	1	339	8169	10
464	1490	2	134	75	0
465	1490	3	142	60	0
466	1490	4	137	0	0
467	1490	5	141	0	0
468	1490	6	138	1	0
469	625	1	294	1	0
470	626	1	294	2	0
471	627	1	294	3	0
472	92	1	294	2	0
473	93	1	294	4	0
474	94	1	294	7	0
475	267	1	294	3	0
476	268	1	294	5	0
477	269	1	294	7	0
478	637	1	294	2	0
479	638	1	294	4	0
480	639	1	294	6	0
481	640	1	294	2	0
482	641	1	294	4	0
483	642	1	294	6	0
484	770	1	294	2	0
485	771	1	294	4	0
486	772	1	294	6	0
487	1107	1	294	2	0
488	1108	1	294	4	0
489	1109	1	294	6	0
490	924	1	294	2	0
491	925	1	294	4	0
492	1210	1	155	4	0
493	1211	1	155	8	0
494	1212	1	155	16	0
495	77	1	125	2	0
496	77	2	141	0	0
497	78	1	125	5	0
498	78	2	141	0	0
499	79	1	125	10	0
500	79	2	141	0	0
501	434	1	125	13	0
502	435	1	125	16	0
503	436	1	125	19	0
504	434	2	141	0	0
505	435	2	141	0	0
506	436	2	141	0	0
507	80	1	274	3	0
508	80	2	141	0	0
509	81	2	141	0	0
510	81	1	274	6	0
511	82	1	274	10	0
512	82	2	141	0	0
513	437	1	274	2	0
514	437	2	141	0	0
515	438	1	274	4	0
516	438	2	141	0	0
517	439	1	274	6	0
518	439	2	141	0	0
833	113	1	169	15	-1
834	114	1	169	30	-1
835	115	1	169	45	-1
836	443	1	169	50	-1
837	444	1	169	100	-1
838	445	1	169	153	-1
525	767	1	273	3	0
526	768	1	273	6	0
527	769	1	273	10	0
528	1099	1	273	3	0
529	1100	1	273	6	0
530	1101	1	273	10	0
531	1011	1	262	8	7
532	1011	2	262	8	8
533	1011	3	262	8	9
534	1011	4	262	8	10
535	1011	5	262	8	11
536	1012	1	262	16	7
537	1012	2	262	16	8
538	1012	3	262	16	9
539	1012	4	262	16	10
540	1012	5	262	16	11
541	1013	1	262	24	7
542	1013	2	262	24	8
543	1013	3	262	24	9
544	1013	4	262	24	10
545	1013	5	262	24	11
546	1014	1	262	32	7
547	1014	2	262	32	8
548	1014	3	262	32	9
549	1014	4	262	32	10
550	1014	5	262	32	11
551	1015	1	262	40	7
552	1015	2	262	40	8
553	1015	3	262	40	9
554	1015	4	262	40	10
555	1015	5	262	40	11
556	1016	1	262	50	7
557	1016	2	262	50	8
558	1016	3	262	50	9
559	1016	4	262	50	10
560	1016	5	262	50	11
561	1361	1	262	10	0
562	1361	2	262	10	1
563	1361	3	262	10	2
564	1361	4	262	10	3
565	1361	5	262	10	4
566	1361	6	262	10	5
567	1361	7	262	10	6
568	1362	1	69	250	0
569	1362	2	97	250	0
570	1362	3	190	250	0
571	1363	1	327	1	0
572	1364	1	273	3	0
573	1364	2	274	3	0
574	1364	3	294	3	0
575	1364	4	319	3	0
576	1364	5	169	3	0
577	1365	1	180	3	0
578	1366	1	262	10	0
579	1366	2	262	10	1
580	1366	3	262	10	2
581	1366	4	262	10	3
582	1366	5	262	10	4
583	1366	6	262	10	5
584	1366	7	262	10	6
585	1367	1	69	250	0
586	1367	2	97	250	0
587	1367	3	190	250	0
588	1368	1	327	1	0
589	1369	1	273	3	0
590	1369	2	274	3	0
591	1369	3	294	3	0
592	1369	4	319	3	0
593	1369	5	169	3	0
594	1370	1	180	3	0
595	116	1	181	5	0
596	117	1	181	15	0
597	118	1	181	25	0
598	195	1	181	100	0
599	683	1	189	1	0
600	684	1	189	2	0
601	685	1	189	3	0
602	674	1	0	1	0
603	675	1	0	2	0
604	1031	1	0	1	0
605	1032	1	0	2	0
606	1033	1	0	3	0
607	1034	1	0	4	0
608	1035	1	0	5	0
609	1072	1	318	1	0
610	1073	1	318	2	0
611	1074	1	318	3	0
612	1075	1	318	4	0
613	1076	1	318	5	0
614	692	1	229	5	0
615	693	1	229	12	0
616	694	1	229	25	0
617	288	1	257	1	0
618	288	2	267	1	31
619	288	3	267	1	32
620	288	4	267	1	33
621	288	5	267	1	15
622	288	6	267	1	16
623	288	7	267	1	17
624	288	8	267	1	18
625	288	9	267	1	19
626	288	10	267	1	20
627	1026	1	328	50	0
628	1027	1	328	100	0
629	1028	1	328	150	0
630	1029	1	328	200	0
631	1030	1	328	250	0
632	1587	1	344	50	0
633	1588	1	344	55	0
634	1589	1	344	60	0
635	652	1	293	25	0
636	653	1	293	50	0
637	654	1	293	75	0
638	1586	1	293	25	0
639	74	1	269	10	0
640	75	1	269	20	0
641	76	1	269	30	0
642	263	1	282	10	0
643	264	1	282	25	0
644	265	1	282	50	0
645	537	1	282	60	0
646	538	1	282	70	0
647	1611	1	282	4	0
648	1612	1	282	8	0
649	1613	1	282	12	0
650	1614	1	282	16	0
651	1615	1	282	20	0
652	5136	1	282	4	0
653	5137	1	282	8	0
654	5138	1	282	12	0
655	5139	1	282	16	0
656	5140	1	282	20	0
657	1621	1	177	14	0
658	1622	1	177	19	0
659	1623	1	177	24	0
660	599	1	266	2	0
661	600	1	266	4	0
662	601	1	266	8	0
663	1536	1	266	11	0
664	1537	1	266	14	0
665	1538	1	266	17	0
666	602	1	266	2	0
667	603	1	266	4	0
668	604	1	266	8	0
669	1388	2	13	1	0
670	1627	1	271	5	0
671	1628	1	271	10	0
672	1629	1	271	15	0
673	855	1	220	5	10
674	856	1	220	15	10
675	857	1	220	30	10
676	820	1	220	10	26
677	820	2	220	10	30
678	820	3	220	10	38
679	821	1	220	20	26
680	821	2	220	20	30
681	821	3	220	20	38
682	822	1	220	30	26
683	822	2	220	30	30
684	822	3	220	30	38
685	915	1	220	5	10
686	915	2	220	5	30
687	916	1	220	15	10
688	916	2	220	15	30
689	917	1	220	30	10
690	917	2	220	30	30
691	1287	1	320	1	0
692	1288	2	320	3	0
693	1289	3	320	5	0
694	1134	1	220	32	74
695	1135	1	220	64	74
696	1136	1	220	96	74
697	1158	1	220	128	74
698	1159	1	220	192	74
699	1160	1	220	224	74
700	1161	1	220	256	74
701	1162	1	220	288	74
702	846	1	258	5	0
703	847	1	258	10	0
704	848	1	258	15	0
705	1301	1	258	20	0
706	1302	1	258	25	0
707	1303	1	258	30	0
708	287	1	253	1	0
709	205	1	251	100	0
710	199	1	301	30	0
711	200	1	301	60	0
712	201	1	301	100	0
713	1131	1	185	10	51
714	1132	1	185	20	51
715	1133	1	185	30	51
716	806	1	249	1	0
717	823	1	222	20	0
718	824	1	222	25	0
719	825	1	222	30	0
720	826	1	222	35	0
721	827	1	222	40	0
722	631	1	292	15	0
723	632	1	292	30	0
724	633	1	292	45	0
725	564	1	177	3	0
726	565	1	177	6	0
727	566	1	177	9	0
728	561	1	177	3	0
729	562	1	177	6	0
730	563	1	177	9	0
731	1624	1	177	14	0
732	1625	1	177	19	0
733	1626	1	177	24	0
734	551	1	225	3	0
735	552	1	225	6	0
736	553	1	225	9	0
737	554	1	225	12	0
738	555	1	225	15	0
739	556	1	225	3	0
740	557	1	225	6	0
741	558	1	225	9	0
742	559	1	225	12	0
743	560	1	225	15	0
744	686	1	200	10	0
745	687	1	200	20	0
746	688	1	200	30	0
747	689	1	200	40	0
748	690	1	200	50	0
749	273	1	288	100	21
750	611	1	283	20	0
751	612	1	283	40	0
752	613	1	283	60	0
753	614	1	283	80	0
754	615	1	283	100	0
755	878	1	252	10	0
756	879	1	252	20	0
757	880	1	252	30	0
758	1539	1	252	35	0
759	1540	1	252	40	0
760	1541	1	252	45	0
761	1041	1	330	25	0
762	1041	2	330	25	1
763	1041	3	330	25	2
764	1041	4	330	25	3
765	1041	5	330	25	28
766	1041	6	330	25	36
767	1042	1	330	30	0
768	1042	2	330	30	1
769	1042	3	330	30	2
770	1042	4	330	30	3
771	1042	5	330	30	28
772	1042	6	330	30	36
773	1043	1	330	35	0
774	1043	2	330	35	1
775	1043	3	330	35	2
776	1043	4	330	35	3
777	1043	5	330	35	28
778	1043	6	330	35	36
779	1044	1	330	25	0
780	1044	2	330	25	1
781	1044	3	330	25	2
782	1044	4	330	25	3
783	1044	5	330	25	28
784	1044	6	330	25	36
785	1045	1	330	30	0
786	1045	2	330	30	1
787	1045	3	330	30	2
788	1045	4	330	30	3
789	1045	5	330	30	28
790	1045	6	330	30	36
791	1046	1	330	35	0
792	1046	2	330	35	1
793	1046	3	330	35	2
794	1046	4	330	35	3
795	1046	5	330	35	28
796	1046	6	330	35	36
797	1047	1	330	25	0
798	1047	2	330	25	1
799	1047	3	330	25	2
800	1047	4	330	25	3
801	1047	5	330	25	28
802	1047	6	330	25	36
803	1048	1	330	30	0
804	1048	2	330	30	1
805	1048	3	330	30	2
806	1048	4	330	30	3
807	1048	5	330	30	28
808	1048	6	330	30	36
809	1049	1	330	35	0
810	1049	2	330	35	1
811	1049	3	330	35	2
812	1049	4	330	35	3
813	1049	5	330	35	28
814	1049	6	330	35	36
815	1050	1	330	15	0
816	1050	2	330	15	1
817	1050	3	330	15	2
818	1050	4	330	15	3
819	1050	5	330	15	28
820	1050	6	330	15	36
821	1051	1	330	20	0
822	1051	2	330	20	1
823	1051	3	330	20	2
824	1051	4	330	20	3
825	1051	5	330	20	28
826	1051	6	330	20	36
827	1052	1	330	25	0
828	1052	2	330	25	1
829	1052	3	330	25	2
830	1052	4	330	25	3
831	1052	5	330	25	28
832	1052	6	330	25	36
839	190	1	219	225	680
840	191	1	219	235	725
841	192	1	219	245	770
842	1524	1	219	485	815
843	1525	1	219	495	860
844	1526	1	219	515	905
845	790	1	218	1	0
846	791	1	218	2	0
847	792	1	218	3	0
848	793	1	218	4	0
849	794	1	218	5	0
850	834	1	218	1	0
851	835	1	218	2	0
852	836	1	218	3	0
853	837	1	218	4	0
854	838	1	218	5	0
855	724	1	218	1	0
856	725	1	218	2	0
857	726	1	218	3	0
858	727	1	218	4	0
859	728	1	218	5	0
860	8201	1	218	1	0
861	8202	1	218	2	0
862	8203	1	218	3	0
1054	795	1	280	2	0
1055	796	1	280	4	0
1056	797	1	280	6	0
1057	798	1	280	8	0
1058	799	1	280	10	0
1059	839	1	280	2	0
1060	840	1	280	4	0
1061	841	1	280	6	0
1062	842	1	280	8	0
1063	843	1	280	10	0
1064	729	1	280	2	0
1065	730	1	280	4	0
1066	731	1	280	6	0
1067	732	1	280	8	0
1068	733	1	280	10	0
1069	803	1	213	2	0
1070	804	1	213	5	0
1071	805	1	213	10	0
1072	800	1	215	2	0
1073	801	1	215	5	0
1074	802	1	215	10	0
1075	125	1	172	2	0
1076	126	1	172	5	0
1077	127	1	172	10	0
1078	449	1	172	3	0
1079	450	1	172	6	0
1080	451	1	172	9	0
1081	452	1	172	12	0
1082	453	1	172	15	0
1083	1061	1	172	2	0
1084	1062	1	172	4	0
1085	1063	1	172	6	0
1086	1064	1	172	8	0
1087	1065	1	172	10	0
1088	1394	1	172	1	0
1089	1395	1	172	2	0
1090	1396	1	172	3	0
1091	1397	1	172	4	0
1092	1398	1	172	5	0
1093	5519	1	172	1	0
1094	5520	1	172	2	0
1095	5521	1	172	3	0
1096	5522	1	172	4	0
1097	5523	1	172	5	0
1099	279	2	259	2	0
1100	279	3	172	2	0
1105	864	2	216	10	1
1106	864	3	216	10	2
1107	864	4	216	10	3
1108	864	5	216	10	10
1109	864	6	216	10	28
1110	864	7	216	10	30
1111	864	8	216	10	36
1113	865	2	216	20	1
1114	865	3	216	20	2
1115	865	4	216	20	3
1116	865	5	216	20	10
1117	865	6	216	20	28
1118	865	7	216	20	30
1119	865	8	216	20	36
1121	866	2	216	30	1
1122	866	3	216	30	2
1123	866	4	216	30	3
1124	866	5	216	30	10
1125	866	6	216	30	28
1126	866	7	216	30	30
1127	866	8	216	30	36
1128	1290	1	216	40	0
1129	1290	2	216	40	1
1130	1290	3	216	40	2
1131	1290	4	216	40	3
1132	1290	5	216	40	10
1133	1290	6	216	40	28
1134	1290	7	216	40	30
1135	1290	8	216	40	36
1136	1291	1	216	50	0
1137	1291	2	216	50	1
1138	1291	3	216	50	2
1139	1291	4	216	50	3
1140	1291	5	216	50	10
1141	1291	6	216	50	28
1142	1291	7	216	50	30
1143	1291	8	216	50	36
1144	1292	1	216	60	0
1145	1292	2	216	60	1
1146	1292	3	216	60	2
1147	1292	4	216	60	3
1148	1292	5	216	60	10
1149	1292	6	216	60	28
1150	1292	7	216	60	30
1151	1292	8	216	60	36
1152	1140	1	216	10	51
1154	1141	1	216	30	51
1155	122	1	259	2	0
1156	123	1	259	5	0
1157	124	1	259	10	0
1158	454	1	259	3	0
1159	455	1	259	3	0
1160	456	1	259	3	0
1161	457	1	259	3	0
1162	458	1	259	3	0
1163	1066	1	259	2	0
1164	1067	1	259	2	0
1165	1068	1	259	2	0
1166	1069	1	259	2	0
1167	1070	1	259	2	0
1168	1399	1	259	2	0
1169	1400	1	259	2	0
1170	1401	1	259	2	0
1171	1402	1	259	2	0
1172	1403	1	259	2	0
1173	5524	1	259	1	0
1174	5525	1	259	1	0
1175	5526	1	259	1	0
1176	5527	1	259	1	0
1177	5528	1	259	1	0
1178	247	1	224	15	0
1179	248	1	224	35	0
1180	249	1	224	50	0
1181	504	1	224	60	0
1182	505	1	224	70	0
1183	506	1	224	80	0
1184	240	1	224	20	26
1185	240	2	173	1	0
1186	241	1	224	40	26
1187	241	2	173	2	0
1188	242	1	224	60	26
1189	242	2	173	3	0
1190	6287	1	224	20	30
1191	6287	2	173	1	0
1192	6288	1	224	40	30
1193	6288	2	173	2	0
1194	6289	1	224	60	30
1195	6289	2	173	3	0
1196	7106	1	224	20	30
1197	7106	2	173	1	0
1198	7107	1	224	40	30
1199	7107	2	173	2	0
1200	7108	1	224	60	30
1201	7108	2	173	3	0
1202	6269	1	224	20	30
1203	6269	2	173	1	0
1204	6270	1	224	40	30
1205	6270	2	173	2	0
1206	6271	1	224	60	30
1207	6271	2	173	3	0
1208	6266	1	224	20	10
1209	6266	2	173	1	0
1210	6267	1	224	40	10
1211	6267	2	173	2	0
1212	6268	1	224	60	10
1213	6268	2	173	3	0
1214	1143	1	224	20	74
1215	1143	2	173	1	0
1216	1144	1	224	40	74
1217	1144	2	173	2	0
1218	1145	1	224	60	74
1219	1145	2	173	3	0
1220	6275	1	224	20	8
1221	6275	2	173	1	0
1222	6276	1	224	40	8
1223	6276	2	173	2	0
1224	6277	1	224	60	8
1225	6277	2	173	3	0
1226	255	1	279	7	0
1227	256	1	279	11	0
1228	257	1	279	15	0
1229	542	1	279	17	0
1230	543	1	279	19	0
1231	544	1	279	21	0
1232	1163	1	279	23	0
1233	1164	1	279	25	0
1234	1165	1	279	27	0
1235	4795	1	279	28	0
1236	4796	1	279	29	0
1237	4797	1	279	30	0
1238	815	1	279	7	0
1239	816	1	279	11	0
1240	817	1	279	15	0
1241	1616	1	279	7	0
1242	1617	1	279	11	0
1243	1618	1	279	15	0
1244	198	1	276	32	0
1245	741	1	232	2	4544
1246	742	1	232	4	4545
1247	743	1	232	6	4546
1248	744	1	232	8	4547
1249	745	1	232	10	4548
1250	577	1	277	20	0
1251	578	1	277	40	0
1252	579	1	277	60	0
1253	95	1	235	5	0
1254	96	1	235	10	0
1255	97	1	235	15	0
1256	710	1	235	5	0
1257	711	1	235	10	0
1258	712	1	235	15	0
1259	713	1	235	20	0
1260	714	1	235	25	0
1261	144	1	244	50	0
1262	567	1	244	62	0
1263	5061	1	244	73	0
1264	734	1	237	1	0
1267	225	1	272	3	0
1274	101	1	265	20	0
1275	102	1	265	35	0
1276	103	1	265	52	0
1277	446	1	265	54	0
1278	447	1	265	56	0
1279	448	1	265	58	0
1280	735	1	265	54	0
1281	736	1	265	56	0
1282	737	1	265	58	0
1283	7056	1	265	62	0
1284	7057	1	265	64	0
1285	7058	1	265	66	0
1286	7059	1	265	67	0
1287	7060	1	265	68	0
1288	7061	1	265	69	0
1291	7066	1	265	72	0

[pfyon]

I thought I'd chime in, I've found multiple of the AA sql updates to give me warnings about duplicate entries (I didn't check to see if anything was actually inserted twice).