Software Versions: Drupal 5.1, Quotes 5.x-1.1, PHP 4.3.9, Postgres 7.4.17

First error happened when trying to add a new block (/admin/settings/quotes/blocks):

* pg_query(): Query failed: ERROR: relation "quotes_blocks_bid_seq" does not exist in /home/akairenn/news.taldar.com/html/includes/database.pgsql.inc on line 125.

* user warning: query: SELECT nextval('quotes_blocks_bid_seq') in /home/akairenn/news.taldar.com/html/includes/database.pgsql.inc on line 144.

This was easily fixed by manually running the following on my database:

CREATE SEQUENCE quotes_blocks_bid_seq;

Then encountered another error when attempting to place the block (/admin/build/block):

* warning: pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer in /home/akairenn/news.taldar.com/html/includes/database.pgsql.inc on line 125.

* user warning: query: SELECT COUNT(*) FROM quotes q INNER JOIN node n ON n.vid = q.vid WHERE n.status = 1 AND n.type = 'quotes' AND q.promote = 1 AND 1 in /home/akairenn/news.taldar.com/html/includes/database.pgsql.inc on line 144.

I managed to fix this by changing line 878 of quotes.module:

- 878 return (count($where) ? implode('AND', $where) : '1');
+ 878 return (count($where) ? implode('AND', $where) : 'TRUE');

Haven't gotten enough coffee into myself to see if this is a correct fix, but it worked and I haven't experienced any odd behavior, so.. ;)

Comments

nancydru’s picture

Status: Active » Closed (duplicate)