SELECT n.nid, child FROM node n INNER JOIN acidfree ON n.nid = acidfree.aid INNER JOIN acidfree_hierarchy ON acidfree.aid = acidfree_hierarchy.child WHERE acidfree_hierarchy.parent = '' AND acidfree.class <>'album' ORDER BY RAND() LIMIT 1

Trying to add an album with parent as root. Postgresql does not like the empty string for acidfree_hierarchy.parent

postgresql 8.1 report

SQL error:

ERROR: invalid input syntax for integer: ""

Comments

vhmauery’s picture

vhmauery commented

Is this on a new install? I am not sure that this is a postgress only thing since it appears that the actual query is wrong. The acidfree_hierarchy.parent should be an actual integer value, not ''.

I am not seeing such a problem with my install, so I am going to need some more information. Of course, I am using mysql, so I might not see the same problems. But anything else about your setup that you can tell me would be good.

vhmauery’s picture

vhmauery commented
Status: Active » Closed (fixed)