Warnings
TheTuxer — Thu, 03/05/2009 - 19:04
Hello everybody!
I'm trying to make IdeaTorrent work on a website I created only for this purpose,but I got these warnings after I installed it when I tested it:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "qapoll_choice" does not exist in /home/thetuxer/public_html/includes/database.pgsql.inc on line 126.
* user warning: query: SELECT qapoll_choice.id, qapoll_choice.title, qapoll_choice.bugid, qapoll_choice.specid, qapoll_choice.forumid, qapoll_choice.userid as userid, qapoll_choice.date, qapoll_choice.status, qapoll_choice.description, qapoll_choice.duplicatenumber, qapoll_choice.totalapprovalvotes, qapoll_choice.whiteboard, qapoll_choice.release_target, qapoll_choice.categoryid, qapoll_choice.relation_id, qapoll_choice.relation_subcategory_id, qapoll_choice_approval_vote.value as myapprovalvote, (qapoll_choice_bookmark.date IS NOT NULL) as mybookmark, qapoll_poll_category.name as catname, qapoll_poll_relation.name as relation_name, qapoll_poll_relation.url_name as relation_url_name, qapoll_poll_relation_subcategory.name as relationsubcatname, users.name as username, qapoll_choice.totalvotes as votes, qapoll_choice.ideavotes as ideavotes,qapoll_choice.relation_id as relation_id, qapoll_choice.commentscount, qapoll_choice.last_status_change, qapoll_choice.last_comment_date, qapoll_choice.last_edit_date FROM qapoll_choice LEFT JOIN users ON users.uid = qapoll_choice.userid LEFT JOIN qapoll_choice_approval_vote ON qapoll_choice_approval_vote.choiceid = qapoll_choice.id AND qapoll_choice_approval_vote.userid = 1 LEFT JOIN qapoll_choice_bookmark ON qapoll_choice_bookmark.choiceid = qapoll_choice.id AND qapoll_choice_bookmark.userid = 1 LEFT JOIN qapoll_poll_category ON qapoll_choice.categoryid = qapoll_poll_category.id LEFT JOIN qapoll_poll_relation ON qapoll_choice.relation_id = qapoll_poll_relation.id LEFT JOIN qapoll_poll_relation_subcategory ON qapoll_choice.relation_subcategory_id = qapoll_poll_relation_subcategory.id WHERE qapoll_choice.pollid='1' AND qapoll_choice.status != '-2' AND qapoll_choice.status != 2 AND qapoll_choice.status != 3 AND qapoll_choice.status != 5 AND qapoll_choice.status != 4 AND qapoll_choice.status != 7 AND qapoll_choice.status != 8 AND qapoll_choice.choicetype != 0 AND ( ( qapoll_choice.bugid IS NOT NULL OR qapoll_choice.specid IS NOT NULL OR qapoll_choice.forumid IS NOT NULL ) OR (qapoll_choice.bugid IS NULL AND qapoll_choice.specid IS NULL AND qapoll_choice.forumid IS NULL ) ) AND qapoll_choice.duplicatenumber = '-1' AND (NOW() - qapoll_choice.date) < interval '1 month' ORDER BY totalvotes/EXTRACT(EPOCH FROM ( CASE WHEN (NOW() - qapoll_choice.date) < interval '1 week' THEN interval '1 week' ELSE NOW() - qapoll_choice.date END ) ) DESC LIMIT 20 OFFSET 0 in /home/thetuxer/public_html/includes/database.pgsql.inc on line 145.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "qapoll_choice" does not exist in /home/thetuxer/public_html/includes/database.pgsql.inc on line 126.
* user warning: query: SELECT COUNT(*) FROM qapoll_choice WHERE qapoll_choice.pollid='1' AND qapoll_choice.status != '-2' AND qapoll_choice.status != 2 AND qapoll_choice.status != 3 AND qapoll_choice.status != 5 AND qapoll_choice.status != 4 AND qapoll_choice.status != 7 AND qapoll_choice.status != 8 AND qapoll_choice.choicetype != 0 AND ( ( qapoll_choice.bugid IS NOT NULL OR qapoll_choice.specid IS NOT NULL OR qapoll_choice.forumid IS NOT NULL ) OR (qapoll_choice.bugid IS NULL AND qapoll_choice.specid IS NULL AND qapoll_choice.forumid IS NULL ) ) AND qapoll_choice.duplicatenumber = '-1' AND (NOW() - qapoll_choice.date) < interval '1 month' in /home/thetuxer/public_html/includes/database.pgsql.inc on line 145.





Hmm..this is very strange..in
Anonymous — Tue, 03/24/2009 - 21:42Hmm..this is very strange..in my host's information about its services,Postgresql 8.3 was explicitly mentioned!
I'll see if I can find out more..
This is because...
nand — Sun, 03/22/2009 - 14:32Hey,
The tables failed to install, and this is very likely because you do not have Postgresql 8.3 or higher! Psql 8.3 is a requirement!
Cheers,
Nicolas