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
Comment #1
nancydruhttp://drupal.org/node/165806