[TYPO3-german] DB Check: Gelöschte, aber referenzierte Pages

Widmann, Manfred mpunktw at gmx.net
Fri Jan 8 10:10:20 CET 2010


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);




More information about the TYPO3-german mailing list