From: Etienne H. <hi...@ar...> - 2010-07-18 10:03:20
|
After having more and more duplicate entries I had a look into the database and found that in table smw_ids the string ids of the SIO objects are multiple with other than namespace 0. (BTW Where can I find the database scheme of SMW?). I cleaned the duplicate entries by deleting them from the tables smw_rels2, smw_atts2 and removed also the string from the smw_ids table. However, I had an Data repair and upgrade running (and also forced cache purge with http://192.168.0.100/mediawiki/index.php/LMkey?action=purge) Doing so this leads to double entries shown in smw_ids table as follows: mysql> select * from smw_ids where smw_title like 'LMkey#%'; +--------+---------------+-----------+--------+-------------+ | smw_id | smw_namespace | smw_title | smw_iw | smw_sortkey | +--------+---------------+-----------+--------+-------------+ | 637 | 0 | LMkey#1 | | LMkey#1 | | 750 | 0 | LMkey#10 | | LMkey#10 | | 804 | 0 | LMkey#11 | | LMkey#11 | | 643 | 0 | LMkey#2 | | LMkey#2 | | 645 | 0 | LMkey#3 | | LMkey#3 | | 664 | 0 | LMkey#4 | | LMkey#4 | | 730 | 0 | LMkey#5 | | LMkey#5 | | 737 | 0 | LMkey#6 | | LMkey#6 | | 741 | 0 | LMkey#7 | | LMkey#7 | | 743 | 0 | LMkey#8 | | LMkey#8 | | 747 | 0 | LMkey#9 | | LMkey#9 | +--------+---------------+-----------+--------+-------------+ 11 rows in set (0.00 sec) mysql> select * from smw_ids where smw_title like 'LMkey#%'; +--------+---------------+-----------+--------+-------------+ | smw_id | smw_namespace | smw_title | smw_iw | smw_sortkey | +--------+---------------+-----------+--------+-------------+ | 637 | 0 | LMkey#1 | | LMkey#1 | | 835 | 14 | LMkey#1 | | LMkey#1 | | 750 | 0 | LMkey#10 | | LMkey#10 | | 844 | 14 | LMkey#10 | | LMkey#10 | | 804 | 0 | LMkey#11 | | LMkey#11 | | 845 | 14 | LMkey#11 | | LMkey#11 | | 643 | 0 | LMkey#2 | | LMkey#2 | | 836 | 14 | LMkey#2 | | LMkey#2 | | 645 | 0 | LMkey#3 | | LMkey#3 | | 837 | 14 | LMkey#3 | | LMkey#3 | | 664 | 0 | LMkey#4 | | LMkey#4 | | 838 | 14 | LMkey#4 | | LMkey#4 | | 730 | 0 | LMkey#5 | | LMkey#5 | | 839 | 14 | LMkey#5 | | LMkey#5 | | 737 | 0 | LMkey#6 | | LMkey#6 | | 840 | 14 | LMkey#6 | | LMkey#6 | | 741 | 0 | LMkey#7 | | LMkey#7 | | 841 | 14 | LMkey#7 | | LMkey#7 | | 743 | 0 | LMkey#8 | | LMkey#8 | | 842 | 14 | LMkey#8 | | LMkey#8 | | 747 | 0 | LMkey#9 | | LMkey#9 | | 843 | 14 | LMkey#9 | | LMkey#9 | +--------+---------------+-----------+--------+-------------+ 22 rows in set (0.00 sec) mysql> select * from smw_ids where smw_title like 'LMkey#%'; +--------+---------------+-----------+--------+-------------+ | smw_id | smw_namespace | smw_title | smw_iw | smw_sortkey | +--------+---------------+-----------+--------+-------------+ | 637 | 0 | LMkey#1 | | LMkey#1 | | 846 | 12 | LMkey#1 | | LMkey#1 | | 835 | 14 | LMkey#1 | | LMkey#1 | | 750 | 0 | LMkey#10 | | LMkey#10 | | 855 | 12 | LMkey#10 | | LMkey#10 | | 844 | 14 | LMkey#10 | | LMkey#10 | | 804 | 0 | LMkey#11 | | LMkey#11 | | 856 | 12 | LMkey#11 | | LMkey#11 | | 845 | 14 | LMkey#11 | | LMkey#11 | | 643 | 0 | LMkey#2 | | LMkey#2 | | 847 | 12 | LMkey#2 | | LMkey#2 | | 836 | 14 | LMkey#2 | | LMkey#2 | | 645 | 0 | LMkey#3 | | LMkey#3 | | 848 | 12 | LMkey#3 | | LMkey#3 | | 837 | 14 | LMkey#3 | | LMkey#3 | | 664 | 0 | LMkey#4 | | LMkey#4 | | 849 | 12 | LMkey#4 | | LMkey#4 | | 838 | 14 | LMkey#4 | | LMkey#4 | | 730 | 0 | LMkey#5 | | LMkey#5 | | 850 | 12 | LMkey#5 | | LMkey#5 | | 839 | 14 | LMkey#5 | | LMkey#5 | | 737 | 0 | LMkey#6 | | LMkey#6 | | 851 | 12 | LMkey#6 | | LMkey#6 | | 840 | 14 | LMkey#6 | | LMkey#6 | | 741 | 0 | LMkey#7 | | LMkey#7 | | 852 | 12 | LMkey#7 | | LMkey#7 | | 841 | 14 | LMkey#7 | | LMkey#7 | | 743 | 0 | LMkey#8 | | LMkey#8 | | 853 | 12 | LMkey#8 | | LMkey#8 | | 842 | 14 | LMkey#8 | | LMkey#8 | | 747 | 0 | LMkey#9 | | LMkey#9 | | 854 | 12 | LMkey#9 | | LMkey#9 | | 843 | 14 | LMkey#9 | | LMkey#9 | +--------+---------------+-----------+--------+-------------+ 33 rows in set (0.00 sec) This happens with SemanticInternalObjects_0.6_r69352 semediawiki-1.5.1_r67599 mediawiki-1.15.4 After stopping the data update/repair the problem was not found again. Etienne Hirt Art of Technology AG |