Last modified: 2011-12-21 19:36:04 UTC
I get the following error with the regexp '{{Contamination.*?}}' A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT page_id,page_namespace,page_title,old_text FROM `clw_page`,`clw_revision`,`clw_text` WHERE (old_text REGEXP '{{Contamination.*?}}') AND page_namespace IN ('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','102','103','106','107','108','109','170','171','420','421') AND (rev_id = page_latest) AND (rev_text_id = old_id) ORDER BY page_namespace, page_title from within function "ReplaceText::doSearchQuery". Database returned error "1139: Got error 'repetition-operator operand invalid' from regexp (localhost)".
I suspect you want '{{Contamination.*\?}}'.
No, I want to make sure I capture just one template, using ? like in PCRE.
Well, it's not PCRE. :) You'll need to use something that MySQL's regexp supports: http://dev.mysql.com/doc/refman/5.1/en/regexp.html