Home

Als ik zoek op een serie met een ! of een : erin, krijg ik PHP errors the zien:

Quote:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error in tsquery: "law & & & order: & criminal & intent" in /home/bierdopje.com/www/includes/classes/pssqldb.class.php on line 124 ERROR: syntax error in tsquery: "law & & & order: & criminal & intent" SQL: SELECT showid, ts_rank(to_tsvector("name",to_tsquery('english','law & & & order: & criminal & intent')) as rank from shows WHERE to_tsquery('english','law & & & order: & criminal & intent') @@ to_tsvector('english',"name" ORDER BY rank DESC LIMIT 25 OFFSET 0 Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error in tsquery: "law & & & order: & criminal & intent" in /home/bierdopje.com/www/includes/classes/pssqldb.class.php on line 124 ERROR: syntax error in tsquery: "law & & & order: & criminal & intent" SQL: SELECT count(*) as count from shows WHERE to_tsquery('english','law & & & order: & criminal & intent') @@ to_tsvector('english',"name" Warning: pg_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/bierdopje.com/www/includes/classes/pssqldb.class.php on line 217 Warning: pg_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/bierdopje.com/www/includes/classes/pssqldb.class.php on line 223