[drupal-devel] [bug] PostgreSQL fix

[Cvbge]

Issue status update for 
http://drupal.org/node/28287
Post a follow up: 
http://drupal.org/project/comments/add/28287

 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.




Cvbge



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