not working with postgresql

aaconti - February 5, 2009 - 17:43
Project:E-Journal
Version:6.x-1.0-alpha2
Component:Code
Category:bug report
Priority:normal
Assigned:nobios
Status:postponed
Description

I'm using drupal 6.9 and postgresql 8 and I got several erros. Everytime I try to create any content, even a content with no connection with ejournal, I get this:

# warning: pg_query() [function.pg-query]: Query failed: ERROR: sintaxe de entrada inválida para integer: "" in /var/www/melro.ginux.ufla.br/htdocs/bazar-teste/includes/database.pgsql.inc on line 139.
# user warning: query: SELECT jid FROM ejournal_articles WHERE nid='' in /var/www/melro.ginux.ufla.br/htdocs/bazar-teste/modules/ejournal/ejournal.module on line 2500.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: sintaxe de entrada inválida para integer: "" in /var/www/melro.ginux.ufla.br/htdocs/bazar-teste/includes/database.pgsql.inc on line 139.
# user warning: query: SELECT jid FROM ejournalshortly WHERE nid='' in /var

when I edit an issue, I get this:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: para SELECT DISTINCT, expressões ORDER BY devem aparecer na lista do select in /var/www/melro.ginux.ufla.br/htdocs/bazar-teste/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT DISTINCT n.nid, n.type, n.title, n.changed, n.status, n.moderate, t.tid, td.name, ea.iid, ea.weight AS article_weight, ea.proofreader_mark AS p_status FROM (SELECT DISTINCT ON (nid) * FROM node) n INNER JOIN ejournal_articles ea ON n.nid = ea.nid LEFT JOIN term_node t ON n.nid=t.nid LEFT JOIN term_data td ON t.tid=td.tid WHERE ea.iid='1' AND ea.jid='1' ORDER BY ea.weight ASC, td.weight ASC, td.name ASC, n.title ASC in /var/www/melro.ginux.ufla.br/htdocs/bazar-teste/modules/ejournal/ejournal.module on line 2255.

this not happen with mysql, so...

#1

nobios - February 5, 2009 - 19:15
Assigned to:Anonymous» nobios
Status:active» postponed

The querys to work in postgre are only changed in the install, not in all code base.. Maybe will see this later on...

 
 

Drupal is a registered trademark of Dries Buytaert.