Searching for nonexistent *card produces a weird search result
Support Ticket
+issues
Searching for nonexistent *card produces a weird search result: See attached image.
Try to search for "*nonexistent"
+screenshot
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)