Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By reydan on
I have installed Organic Groups it is working fine but when I enable Og Forum Module I have folowing errors and when I check the database I realize that og_term table is not created.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: type modifier is not allowed for type "int_unsigned" LINE 2: tid int_unsigned(10) NOT NULL default '0', ^ in /www/htdocs/drupal_agora/includes/database.pgsql.inc on line 139.
* user warning: query: CREATE TABLE og_term ( tid int_unsigned(10) NOT NULL default '0', nid int_unsigned(10) NOT NULL default '0', public int_unsigned(1) NOT NULL default '0', PRIMARY KEY (tid, nid) ) in /www/htdocs/drupal_agora/includes/database.inc on line 515.
Comments
How can I resolve this
How can I resolve this issue?
This must be a bug of the
This must be a bug of the og_forum module with PostgreSQL, as it happens with many modules, because the module's developers don't use PostgreSQL.
The problem with PostgreSQL is that relatively few people use it with Drupal, and the module developers rely on them to suggest solutions and to test them.
LIke the man says, lots of
LIke the man says, lots of module developers don't have Postgres installed to test on so we don't catch instances where SQLs handle things differently (got bit by this very thing just now). The best thing to do is indeed to let the developers know. It's easy to put in a check and modify a SQL statement to play nice with both DBs, once the problem has been pointed out.
salud,
Bill