Searching for nonexistent *card produces a weird search result+discussion

There seems to be an actual card with this message on it... is this by design?

---

Thanks for reporting this!

 

I'm not seeing this in mysql, so I think it's specific to Postgres' regexp handling. I will make sure to file a bug ticket and get this fixed.

---

Also I might be imagining things but I seem to remember a system card *missing link(s) which has this exact text on it.

---

Yup. Confirmed... the "*missing link" card has a similar message on it. Here it is:

ActiveRecord::StatementInvalid :: PG::SyntaxError: ERROR: syntax error at or near "false" LINE 3: ...ard_references where present = 0 AND ref_type='L' false) and... ^ : ( select t.name from cards t where t.id in (select referer_id from card_references where present = 0 AND ref_type='L' false) and (t.read_rule_id IN (500,549,551,554,556,558,559,561,956)) and t.trash is false ORDER BY t.updated_at desc LIMIT 20 OFFSET 0 ) :: {"link_to":"_none"}

---

Thanks for putting that here. On *missing links I do get an error in mysql:

 

ActiveRecord::StatementInvalid :: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'false) and t.trash is false ORDER BY t.updated_at desc LIMIT 20 OFFSET 0 )' at line 3: ( select t.name from cards t where t.id in (select referer_id from card_references where present = 0 AND ref_type='L' false) and t.trash is false ORDER BY t.updated_at desc LIMIT 20 OFFSET 0 ) :: {"link_to":"_none"}

---

(will file this too)