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, category,
- (SELECT count(postid) FROM posts WHERE posts.categoryid = categories.categoryid) AS postcount
- FROM categorytypes
- LEFT JOIN categories USING (categorytypeid)
- WHERE categorytype = 'Article' AND category != 'Unsorted'
- 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, users.userid, name,
- (SELECT count(commentid) FROM comments WHERE posts.postid = comments.postid) AS commentcount
- FROM categorytypes
- LEFT JOIN categories USING (categorytypeid)
- LEFT JOIN posts USING (categoryid)
- LEFT JOIN users USING (userid)
- WHERE categorytype = 'Article' AND category != 'Unsorted'
- 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.
