pg_query() [function.pg-query]: Query failed: ERROR: relation "categories" does not exist
- LINE 4: LEFT JOIN categories USING (categoryid)
- ^
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "categories" does not exist
- LINE 4: LEFT JOIN categories USING (categoryid)
- ^
- SQL Query:
- SELECT title, postid, html
- FROM posts
- LEFT JOIN categories USING (categoryid)
- LEFT JOIN categorytypes USING (categorytypeid)
- WHERE categorytype = 'Internal' AND category = 'Page' AND title = 'About404'
- LIMIT 1
- ;
- 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() expects parameter 1 to be resource, boolean given
- 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: syntax error at or near ";"
- LINE 1: UPDATE posts SET hitcount = hitcount + 1 WHERE postid = ;
- ^
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: syntax error at or near ";"
- LINE 1: UPDATE posts SET hitcount = hitcount + 1 WHERE postid = ;
- ^
- SQL Query: UPDATE posts SET hitcount = hitcount + 1 WHERE postid = ;
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 24.
pg_query() [function.pg-query]: Query failed: ERROR: relation "categories" does not exist
- LINE 3: FROM categories
- ^
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "categories" does not exist
- LINE 3: FROM categories
- ^
- 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() expects parameter 1 to be resource, boolean given
- 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.
