Searching for nonexistent *card produces a weird search result

Support Ticket

+status
acknowledged
 

Searching for nonexistent *card produces a weird search result: See attached image.

Try to search for "*nonexistent"

 

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

--Mir S......2014-06-22 19:43:20 +0000

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.

--Ethan McCutchen.....2014-06-23 20:38:40 +0000

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

--Mir S......2014-06-25 22:58:27 +0000

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"}

--Mir S......2014-06-29 13:12:03 +0000

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"}

--Ethan McCutchen.....2014-06-30 22:51:53 +0000

(will file this too)

--Ethan McCutchen.....2014-06-30 22:52:13 +0000