Skip to content

Instantly share code, notes, and snippets.

@lcamacho
Created March 4, 2015 18:35
Show Gist options
  • Save lcamacho/c5dbc5186675318d7998 to your computer and use it in GitHub Desktop.
Save lcamacho/c5dbc5186675318d7998 to your computer and use it in GitHub Desktop.
DB log
db_1 | ERROR: syntax error in tsquery: "1"|onmouseover=prompt(931357)|bad=""
db_1 | STATEMENT: SELECT COUNT(*) FROM "main_event" WHERE (NOT ("main_event"."id" IN (SELECT U1."event_id" FROM "main_approval" U1 WHERE U1."approved" = false )) AND NOT ("main_event"."id" IN (SELECT U1."event_id" FROM "main_approval" U1 WHERE U1."processed" = false )) AND "main_event"."status" = 'scheduled' AND "main_event"."privacy" = 'public' AND (
db_1 | (
db_1 | to_tsvector('english', title) @@ to_tsquery('english', '1"|onmouseover=prompt(931357)|bad="')
db_1 | OR
db_1 | to_tsvector('english', description || ' ' || short_description)
db_1 | @@ to_tsquery('english', '1"|onmouseover=prompt(931357)|bad="')
db_1 | OR
db_1 | to_tsvector('english', transcript) @@ to_tsquery('english', '1"|onmouseover=prompt(931357)|bad="')
db_1 | )
db_1 | ))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment