[drupal-devel] [bug] PostgreSQL fix

Cvbge drupal-devel at drupal.org
Fri Aug 19 12:53:01 UTC 2005

Issue status update for 
Post a follow up: 

 Project:      Drupal
 Version:      cvs
 Component:    forum.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  plj
 Updated by:   Cvbge
 Status:       patch (code needs review)

The attached patch fixed the problem for me, and looks quite sane.


Previous comments:

Fri, 05 Aug 2005 17:32:52 +0000 : plj

Attachment: http://drupal.org/files/issues/forum.module_5.patch (1.02 KB)

In addition to this [1] old bug there is another bug in cvs version of
forum.module, when the database in use is PostgreSQL. When forum
configuration page is accessed first time, Drupal attempts to create a
new vocabulary for forums:

INSERT INTO vocabulary (name, description, help, multiple, required,
hierarchy, relations, tags, weight, module, vid) VALUES ('Forums', '',
'', 0, 1, 1, 0, '', 0, 'forum', '1')

Unfortunately, this throws an 'Invalid input syntax for integer' error,
as no value is assigned for field 'tags'.

I've included a patch that should insert 0 into that field to avoid the
error, but I hope someone would review it, as I'm no expert in PHP and
thus unsure that I made it correctly. Only one row is affected.
[1] http://drupal.org/node/23499

More information about the drupal-devel mailing list