Frontend erstellt Orgas/Events ohne Entry -> Suche schlägt fehl

[kakenbok]

es fehlt ein after_create :create_entry! im FAPI

[kakenbok]

Quickfix Orgas (85 Stück heute):

INSERT INTO entries (entry_type, entry_id) 
select 'Orga', o.id from orgas o
left join entries e
on o.id = e.entry_id and e.entry_type = 'Orga'
where o.title != 'ROOT-ORGA'
and e.entry_id is null

Quickfix Events (74 Stück heute):

INSERT INTO entries (entry_type, entry_id) 
select 'Event', ev.id from events ev
left join entries e
on ev.id = e.entry_id and e.entry_type = 'Event'
where e.entry_id is null

[kakenbok]

Orgas:

select o.* from orgas o
left join entries e
on o.id = e.entry_id and e.entry_type = 'Orga'
where e.id is null
and o.id <> 1

Events:

select o.* from events o
left join entries e
on o.id = e.entry_id and e.entry_type = 'Event'
where e.id is null

[kakenbok]

heute 11 orgas und 13 events gefixt :-)