pg_query() [function.pg-query]: Query failed: ERROR: relation "clans" does not exist
- In /home/clan404/public_html/borked/Iconic/database_postgresql.php on line 22.
PostgreSQL ERROR: relation "clans" does not exist
- SQL Query:
- SELECT
- matchid, clanid, leagueid, EXTRACT(EPOCH FROM posted) AS posted,
- title, postid, clan,
- SUM(SIGN(scorefor - scoreagainst)) AS state,
- SUM(scorefor) AS scorefor,
- SUM(scoreagainst) AS scoreagainst
- FROM
- matches
- LEFT JOIN
- posts USING (postid)
- LEFT JOIN
- matchmaps USING (matchid)
- LEFT JOIN
- clans USING (clanid)
- GROUP BY
- matchid, clanid, leagueid, postid, title, posted, clan
- ORDER BY
- posts.posted DESC
- LIMIT
- 10;
- 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.