Migration issue - Mailing list pgsql-www

From Terminal Station
Subject Migration issue
Date
Msg-id b3d67c1a0803021518t71dc749doa6404779bf98a7ee@mail.gmail.com
Whole thread Raw
Responses Re: Migration issue
List pgsql-www
Url : http://pugs.postgresql.org/directory

Error Msg:
"

   * warning: pg_query() [function.pg-query]: Query failed: ERROR:
function left(character varying, integer) does not exist LINE 1:
SELECT count(DISTINCT(LEFT(term_data.name, 1))) FROM node no... ^
HINT: No function matches the given name and argument types. You may
need to add explicit type casts. in
/usr/local/www/drupal5/includes/database.pgsql.inc on line 125.   * user warning: query: SELECT
count(DISTINCT(LEFT(term_data.name,
1))) FROM node node LEFT JOIN term_node term_node ON node.nid =
term_node.nid LEFT JOIN term_data term_data ON term_node.tid =
term_data.tid WHERE (node.status = '1') AND (term_data.name IS NOT
NULL) in /usr/local/www/drupal5/includes/database.pgsql.inc on line
144.   * warning: pg_query() [function.pg-query]: Query failed: ERROR:
function left(character varying, integer) does not exist LINE 1:
SELECT term_data.tid, LEFT(term_data.name, 1) AS letter, cou... ^
HINT: No function matches the given name and argument types. You may
need to add explicit type casts. in
/usr/local/www/drupal5/includes/database.pgsql.inc on line 125.   * user warning: query: SELECT term_data.tid,
LEFT(term_data.name,
1) AS letter, count(node.nid) AS num_nodes, term_data.weight AS
term_data_weight, term_data.name AS term_data_name, node.sticky AS
node_sticky, node.created AS node_created_created FROM node node LEFT
JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN
term_data term_data ON term_node.tid = term_data.tid WHERE
(node.status = '1') AND (term_data.name IS NOT NULL) GROUP BY
LEFT(term_data.name, 1), term_data_weight, term_data_name,
node_sticky, node_created_created ORDER BY term_data_weight ASC,
term_data_name ASC, node_sticky DESC, node_created_created DESC LIMIT
50 OFFSET 0 in /usr/local/www/drupal5/includes/database.pgsql.inc on
line 144.

"

Cause:
Automatic casting not supported!


pgsql-www by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: An actually *useful* mail-list message footer
Next
From: "Joshua D. Drake"
Date:
Subject: Re: An actually *useful* mail-list message footer