pg_query() [function.pg-query]: Query failed: ERROR: relation "categorytypes" does not exist
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "categorytypes" does not exist
- SQL Query:
- SELECT categorytype, categoryid, category,
- (
- SELECT count(postid)
- FROM posts
- WHERE posts.categoryid = categories.categoryid AND
- (SELECT COUNT(fileid) FROM files WHERE posts.postid = files.postid) > 0
- ) AS postcount
- FROM categorytypes
- LEFT JOIN categories USING (categorytypeid)
- WHERE categorytype = 'File' AND category != 'Unsorted' OR (Categorytype = 'Internal' AND category='Match')
- ORDER BY category
- ;
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 24.
pg_fetch_array() expects parameter 1 to be resource, boolean given
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 58.
pg_free_result(): supplied argument is not a valid PostgreSQL result resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 30.
failed to free sql resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 31.
pg_query() [function.pg-query]: Query failed: ERROR: relation "categorytypes" does not exist
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "categorytypes" does not exist
- SQL Query:
- SELECT categoryid, title, postid, EXTRACT(EPOCH FROM posted) AS posted,
- (SELECT SUM(hitcount) FROM files WHERE posts.postid = files.postid) AS downloadcount
- FROM categorytypes
- LEFT JOIN categories USING (categorytypeid)
- JOIN posts USING (categoryid)
- WHERE (
- categorytype = 'File' AND category != 'Unsorted'
- OR
- (
- categorytype = 'Internal' AND category='Match' AND
- (SELECT COUNT(fileid) FROM files WHERE posts.postid = files.postid) > 0
- )
- )
- AND
- (
- postid IS NULL
- OR
- postid IN
- (
- SELECT postid
- FROM posts
- WHERE posts.categoryid = categories.categoryid
- ORDER BY posted DESC
- LIMIT 5
- )
- )
- ORDER BY title
- ;
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 24.
pg_fetch_array() expects parameter 1 to be resource, boolean given
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 58.
pg_free_result(): supplied argument is not a valid PostgreSQL result resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 30.
failed to free sql resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 31.
pg_query() [function.pg-query]: Query failed: ERROR: relation "categories" does not exist
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "categories" does not exist
- SQL Query:
- SELECT title, postid, EXTRACT(EPOCH FROM posted) AS posted, name, userid
- FROM categories
- LEFT JOIN posts USING (categoryid)
- LEFT JOIN users USING (userid)
- WHERE category = 'Column'
- ORDER BY posted DESC LIMIT 5
- ;
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 24.
pg_fetch_array() expects parameter 1 to be resource, boolean given
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 58.
pg_free_result(): supplied argument is not a valid PostgreSQL result resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 30.
failed to free sql resource
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 31.
