Skip to content

Instantly share code, notes, and snippets.

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 | )
@lcamacho
lcamacho / ads.html
Last active August 29, 2015 14:14
Firefox OS Google Ads
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>ads</title>
</head>
<body style="margin:0">
<ins class="adsbygoogle"
style="display:block;overflow:hidden"
data-ad-client="ca-pub-XXXXXXXXXXXXXXXX"
@lcamacho
lcamacho / Dockerfile
Created October 17, 2014 13:04
Dockerfile
FROM ubuntu:14.04
MAINTAINER Leonard Camacho <leonard.camacho@gmail.com>
RUN apt-get update && apt-get install -y python python-dev python-pip postgresql libpq-dev memcached libxml2-dev libxslt1-dev
ADD . /airmozilla
WORKDIR /airmozilla
RUN pip install -r requirements/compiled.txt