Download & Extend
Issues

Drupal tries to insert a blank string ('') in an integer column in PostgreSQL

Posted by Nimish P on April 28, 2006 at 5:39pm
Project:Drupal core
Version:4.6.9
Component:base system
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (won't fix)

Issue Summary

Drupal user and node modules attempt to insert a blank string ('') in when the input is not specified for an integer column. MySQL allows this but not PostgreSQL. This results in a DB error.

This problem was found in node.module and user.module.

Some discussion of this issue exists in http://drupal.org/node/27870

Login or register to post comments

Comments

#1

Posted by Nimish P on April 28, 2006 at 5:58pm

A patch that includes fix for the Drupal core modules - user.module and node.module.

Works for Drupal 4.6.6.

AttachmentSizeStatusTest resultOperations
pg_query.patch.txt2.16 KBIgnored: Check issue status.NoneNone

#2

Posted by Nimish P on April 28, 2006 at 6:11pm
Status:active» needs review

#3

Posted by markus_petrux on April 28, 2006 at 6:17pm
Status:needs review» needs work

I believe it would be best to use %d for integers, rather than '%s'

#4

Posted by magico on August 21, 2006 at 5:18pm

Would this be a much wider problem related to postgresql support?

#5

Posted by magico on August 26, 2006 at 6:05pm
Version:4.6.6» 4.6.9
Status:needs work» closed (won't fix)

Closing due the the low interest in this.

nobody click here