| Index: trunk/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php |
| — | — | @@ -1277,7 +1277,6 @@ |
| 1278 | 1278 | $db->query("INSERT INTO $tablename (title) VALUES " . $sqlvalues, 'SMW::getCategoryTable'); |
| 1279 | 1279 | $db->query("INSERT INTO $tmpnew (title) VALUES " . $sqlvalues, 'SMW::getCategoryTable'); |
| 1280 | 1280 | |
| 1281 | | - /// TODO: avoid duplicate results? |
| 1282 | 1281 | for ($i=0; $i<$smwgQSubcategoryDepth; $i++) { |
| 1283 | 1282 | $db->query("INSERT INTO $tmpres (title) SELECT $pagetable.page_title |
| 1284 | 1283 | FROM $cltable,$pagetable,$tmpnew WHERE |
| — | — | @@ -1339,7 +1338,6 @@ |
| 1340 | 1339 | $db->query("INSERT INTO $tablename (title) VALUES (" . $db->addQuotes($propname) . ')', 'SMW::getPropertyTable'); |
| 1341 | 1340 | $db->query("INSERT INTO $tmpnew (title) VALUES (" . $db->addQuotes($propname) . ')', 'SMW::getPropertyTable'); |
| 1342 | 1341 | |
| 1343 | | - /// TODO: avoid duplicate results? |
| 1344 | 1342 | for ($i=0; $i<$smwgQSubpropertyDepth; $i++) { |
| 1345 | 1343 | $db->query("INSERT INTO $tmpres (title) SELECT $sptable.subject_title |
| 1346 | 1344 | FROM $sptable,$tmpnew WHERE |
| — | — | @@ -1348,7 +1346,7 @@ |
| 1349 | 1347 | continue; |
| 1350 | 1348 | } |
| 1351 | 1349 | $db->query("INSERT IGNORE INTO $tablename (title) SELECT $tmpres.title |
| 1352 | | - FROM $tmpres", 'SMW::getCategoryTable'); |
| | 1350 | + FROM $tmpres", 'SMW::getPropertyTable'); |
| 1353 | 1351 | if ($db->affectedRows() == 0) { // no change, exit loop |
| 1354 | 1352 | continue; |
| 1355 | 1353 | } |