Hi NG! Ich versuche gerade, ein etwas aus den Fugen geratenes TYPO3-Web wieder zu bereinigen und habe da in DB-Check > Database Relations eine Menge Meldungen der Art "There are 2 records pointing to this missing or deleted record; [pages][728]" ... also, dass wohl irgend ein DB-Eintrag die Page mit der uid = 728 referenziert, diese aber nicht mehr vorhanden ist.
Ich hätte jetzt versucht, alle DB-Tables, in denen eine pid vorkommt nach den in DB-Check genannten pids zu durchsuchen (Query ganz unten), habe aber jeweils 0 Rows erhalten. Dann habe ich versuchsweise eine neue Page mit einer dieser id's angelegt und DB-Check meldet dann tatsächlich einen Fehler weniger, aber leider sehe ich auf der Page dann auch nciht, was dorthin verweist ... Meine Frage daher: Wie kann ich das bereinigen? Wie komm ich drauf, was auf diese nciht vorhandenen Pages verweist? lg Manfred Hier das Query: select * from be_groups where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from be_users where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from fe_groups where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from fe_users where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from pages where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from pages_language_overlay where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_countries where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_country_zones where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_currencies where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_languages where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_markets where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_template where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from static_territories where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_domain where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_filemounts where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_language where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_messages where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_note where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_template where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_todos where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_workflows where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from sys_workspace where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tt_content where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tt_news where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tt_news_cat where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_contact_responsibilities where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam_cat where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam_file_tracking where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam_log_index where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam_metypes_avail where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_dam_selection where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_gooffotoboek_basket where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTLFeedback_Daten where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_htlnotenstatistik_daten where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_htlsupplierungen_supplierung where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_fach where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_klasse where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_lehrer where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_raum where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_stundenplan where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_HTL_Belegung_unterrichtet where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_kbconttable_tmpl where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_lzgallery_galleries where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_noindexedsearch_content where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_noindexedsearch_stats where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_rtehtmlarea_acronym where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_singlesignon_data where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_wmbanner_banner where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74); select * from tx_wmcontact_contact where pid in (728,392,2,68,43,217,61,439,64,221,329,41,1053,707,782,919,1479,479,1485,1497,1484,118,385,114,1,58,617,618,74);
_______________________________________________ TYPO3-german mailing list TYPO3-german@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german
