Hi,

I have installed and enabled og_forum and when a group member tries to create a forum topic above the forum topic creation form below error displayed;

* warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: " .14. " in /www/htdocs/agora/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT t.* FROM term_node r INNER JOIN (SELECT DISTINCT ON (tid) * FROM term_data) t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid LEFT JOIN og_term ogt ON t.tid = ogt.tid WHERE (t.tid NOT IN (SELECT x.tid FROM (SELECT DISTINCT(ogt.tid) FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid != ' .14. ') x WHERE x.tid NOT IN (SELECT DISTINCT(ogt.tid) FROM og_term ogt INNER JOIN og_uid ogu ON ogt.nid = ogu.nid AND ogu.uid = ' .14. ')) AND ogt.nid = 1) AND ( r.vid = 1 )ORDER BY v.weight, t.weight, t.name in /www/htdocs/agora/modules/taxonomy/taxonomy.module on line 618.

How can I solve that issue?
By the way new forum topic is created.

Comments

reydan’s picture

Any answers?

Anonymous’s picture

Can anyone help here with this PostgreSQL ?

@reydan

I think most people use MySQL , i would recommend getting some paid for support to either fix this this problem OR migrate to MySQL and then get some free support from me and other users with any additional MySQL problems

Best, Paul

Anonymous’s picture

Please reopen if you still require assistance

Best, Paul

Anonymous’s picture

Status: Active » Closed (fixed)
reydan’s picture

Status: Closed (fixed) » Active
playground21’s picture

Title: Og Forum PostgreSql Error » Content image is not displaying in shopping cart view
Anonymous’s picture

Was this title change correct ?

vegantriathlete’s picture

Version: 6.x-1.1 » 6.x-2.x-dev
Issue summary: View changes
Status: Active » Closed (won't fix)