close fullscreen

Ticket

catch blank searches when no fulltext search+status
closed
help edit space_dashboard
catch blank searches when no fulltext search+priority
low
help edit space_dashboard
catch blank searches when no fulltext search+tag
Search
mysql
help edit space_dashboard
catch blank searches when no fulltext search+commit
 

 

 

catch blank searches when no fulltext search+example

help edit space_dashboard

Platform: OS X 10.5

Browser: FF 2.0.0.15

Build on localhost: 661

DB: MySQL on localhost

 

 

Action creating bug:

Search string in Search Cards field is "*"

 

Resultant error message in browser:

ActiveRecord::StatementInvalid: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR OR ) and t.trash='f' ORDER BY t.updated_at desc LIMIT 50 OFFSET 0)' at line 1: (select t.* from cards t join revisions on revisions.id=t.current_revision_id where ( OR OR ) and t.trash='f' ORDER BY t.updated_at desc LIMIT 50 OFFSET 0)
{"match":"_keyword", "sort":"relevance"}

 

Full trap of terminal output:

Verbose output from command line: [my best guess as to corresponding to bug]

 

(moved out verbose output. still accessible via history -efm)

 

 

 

help edit space_dashboard


same as improve cue text for stripped searches? close?

  --Ethan McCutchen.....Thu Dec 01 15:31:50 -0800 2011


closing (bc of above and bc fulltext search no longer supported)

  --Ethan McCutchen.....2013-03-26 21:29:54 +0000

 

catch blank searches when no fulltext search+discussed in support tickets

help edit space_dashboard