b&w_logo Created with Sketch.
  • Get Started
  • Contact
  • Sign up
  • Sign in

sharks

get started

concepts

features

syntax

 

monkeys

intro

mods

REST API

 

platypuses

github

blueprints

tickets

 

everyone

support

ideas

contact

license

 

 
 

catch blank searches when no fulltext search

help edit space_dashboard

Ticket

+status
closed
help edit space_dashboard
+priority
low
help edit space_dashboard
+tag
Search
mysql
help edit space_dashboard
+commit
 

 

 

+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

 

+discussed in support tickets

help edit space_dashboard