By davetayl on

Guys I seem to be getting a problem when creating content in this case a book page, the following message appears on the right hand side.

warning: pg_exec() query failed: ERROR: pg_atoi: error in "book": can't parse "book"
in /usr/share/pear/DB/pgsql.php on line 171.

user error: DB Error: unknown error
query: SELECT n.*, u.uid, u.name FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = 'book' in /var/www/html/drupal/includes/database.pear.inc on line 89.

Any ideas?

Comments

orzenil’s picture

orzenil commented

davetayl,

I really don't know about book module - I had not installed it yet - but I think there is an error in the sql statement at n.nid='book'. The data type expected by postgresql is an integer type (n.nid) not a string. Give a look at http://drupal.org/book/view/1805 (ERD diagram).

Maybe you could try replacing your sql:

SELECT n.*, u.uid, u.name FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = 'book'

SELECT n.*, u.uid, u.name FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.type = 'book'