Closed (fixed)
Project:
Date
Version:
6.x-2.x-dev
Component:
Date CCK Field
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
8 Jul 2008 at 16:38 UTC
Updated:
23 Jul 2008 at 10:57 UTC
The datestamp field is defined as type=int, length=11. When a datestamp field is added, this spec gets translated by db_add_field into the following query
ALTER TABLE {content_type_foo} ADD COLUMN field_bar_value int(11)
This query fails with a syntax error on postgres, because you cannot specify the numeric length for int fields in Postgres. It seems likely that the size parameter is unnecessary, since in MySQL it is only used for display padding and string compares.
Patch attached.
| Comment | File | Size | Author |
|---|---|---|---|
| datestamp_length.patch | 455 bytes | gdd |
Comments
Comment #1
gddoops setting status
Comment #2
karens commentedRight, that should never have been there, but apparently no one ever noticed (or at least no one reported this that I can remember.)
Thanks!
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.