search

SmartDataAnalytics / OpenResearch

Public issue system for OPENRESEARCH/ConfIDent
8 stars 3 forks source link

FASE series Fatal exception of type "Error" #237

Open WolfgangFahl opened 3 years ago

WolfgangFahl commented 3 years ago

has been spammed and SPAM can not be undone

[78fbe634097f00d0cb62b04e] 2021-06-09 11:10:53: Fatal exception of type "Error"

WolfgangFahl commented 3 years ago

Trying to recreate content as: https://confident.dbis.rwth-aachen.de/or/index.php?title=FASE&action=submit

{{Event series
 | acronym = FASE
 | Title = International Conference on Fundamental Approaches to Software Engineering
 | Field = Software engineering
}}

leads to: Someone else has changed this page since you started editing it. The upper text area contains the page text as it currently exists. Your changes are shown in the lower text area. You will have to merge your changes into the existing text. Only the text in the upper text area will be saved when you press "Save changes".

WolfgangFahl commented 3 years ago 
-- https://www.mediawiki.org/wiki/Manual:Database_layout
-- https://www.mediawiki.org/wiki/Manual:Page_table
-- https://www.mediawiki.org/wiki/Manual:Revision_table
select 
   p.page_id,
   r.rev_id,
   convert(p.page_title using utf8) as title,
   convert(r.rev_timestamp using utf8) as timestamp,
   p.page_len,
   convert(a.actor_name using utf8) as actor
from  page p 
join revision r 
on r.rev_page=p.page_id
join revision_actor_temp rat on rat.revactor_rev=r.rev_id
join actor a on a.actor_id=rat.revactor_actor
where page_title="FASE";
WolfgangFahl commented 3 years ago
page_id rev_id title timestamp page_len actor
655 1441 FASE 20080818191924 153 Soeren
655 1842 FASE 20080819231935 153 Soeren
655 30705 FASE 20120703091027 153 94.23.1.28
WolfgangFahl commented 3 years ago

delete from revision where rev_id=30705

WolfgangFahl commented 3 years ago

grafik

WolfgangFahl commented 3 years ago

same problem

tholzheim commented 3 years ago

same problems:

WolfgangFahl commented 3 years ago

same for https://confident.dbis.rwth-aachen.de/or/index.php?title=APMC_2008&action=formedit