Task #1677
Updated by Lukas Vonlanthen about 8 years ago
Bei folgenden QAs ist bei main_contributor eine gültige User ID eingetragen (nicht 661 "Not registered"). Allerdings existiert dieser User in der Typo3 DB nicht. <pre> +------+------------+--------------------+------------+ | id | code | main_contributor | owner_id | |------+------------+--------------------+------------| | 43 | A_BEL001en | 460 | 974 | | 44 | A_BOL001es | 382 | 382 | | 45 | A_BOL002en | 382 | 382 | | 46 | A_BOL002es | 382 | 382 | | 47 | A_BRK010en | 1773 | 974 | | 49 | A_CHN001en | 1775 | 974 | | 50 | A_CHN002en | 1776 | 974 | | 52 | A_CHN012en | 1774 | 974 | | 57 | A_CHN021en | 1778 | 974 | | 173 | A_COL001es | 1780 | 974 | | 171 | A_COL002es | 1779 | 974 | | 170 | A_COS001es | 1781 | 974 | | 166 | A_ETH005en | 1782 | 974 | | 147 | A_ETH046en | 890 | 890 | | 139 | A_IND011en | 117 | 117 | | 138 | A_IND013en | 694 | 694 | | 131 | A_KAZ003en | 366 | 366 | | 130 | A_KAZ004en | 274 | 274 | | 128 | A_KAZ007en | 366 | 366 | | 125 | A_KEN007en | 621 | 621 | | 107 | A_NIG001fr | 632 | 632 | | 106 | A_NIG005fr | 633 | 633 | | 276 | A_NIG011en | 14 | 313 | | 102 | A_PHI004en | 32 | 32 | | 89 | A_RSA027en | 281 | 281 | | 84 | A_RSA039en | 770 | 770 | | 82 | A_RSA042en | 81 | 81 | | 78 | A_RSA056en | 394 | 394 | | 195 | A_SWI003en | 1397 | 1397 | | 76 | A_SYR001en | 319 | 319 | | 72 | A_TAJ004en | 588 | 1973 | | 212 | A_TUR004en | 1514 | 1040 | +------+------------+--------------------+------------+ </pre> <pre><code class="sql"> SELECT id, code, main_contributor, owner_id FROM qa.approach WHERE id in (131, 128, 89 , 47 , 106, 82 , 195, 212, 76 , 107, 84 , 139, 130, 276, 72 , 147, 138, 43 , 44 , 46 , 49 , 50 , 52 , 57 , 173, 171, 170, 166, 125, 78 , 102, 45) ORDER BY code </code></pre>