I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult, I am testing this on Ubuntu 10.04, fully up to date. -- ----------------- Bob Hutchinson Midwales dot com -----------------
datetime was removed under some dubious circumstances. you can depend on date api module to get it back or probably better is to switch to int if you can. see http://drupal.org/node/866340 On Mon, Sep 20, 2010 at 10:08 AM, Bob Hutchinson <hutchlists@midwales.com> wrote:
I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult,
I am testing this on Ubuntu 10.04, fully up to date.
-- ----------------- Bob Hutchinson Midwales dot com -----------------
[A secret cabal planned a takeover and successfully assassinated the subject. No retribution has been forthcoming to this point. Details are sketchy.] On Mon, Sep 20, 2010 at 3:18 PM, Moshe Weitzman <weitzman@tejasa.com> wrote:
datetime was removed under some dubious circumstances. you can depend on date api module to get it back or probably better is to switch to int if you can. see http://drupal.org/node/866340
On Mon, Sep 20, 2010 at 10:08 AM, Bob Hutchinson <hutchlists@midwales.com> wrote:
I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult,
I am testing this on Ubuntu 10.04, fully up to date.
-- ----------------- Bob Hutchinson Midwales dot com -----------------
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450
Since I just noticed this concurrent to receiving this message I guess I will ask here. Would I be correct in assuming that there is currently no date widget for the Integer field in Drupal 7? Date is a pretty common field type (I would think). Other than possibly the Date module is anyone aware of a Date widget for Integers under development? I'd be happy to contribute, since this is something that I actually need. Thanks, Everett Zufelt http://zufelt.ca Follow me on Twitter http://twitter.com/ezufelt View my LinkedIn Profile http://www.linkedin.com/in/ezufelt On 2010-09-20, at 10:21 AM, Randy Fay wrote:
[A secret cabal planned a takeover and successfully assassinated the subject. No retribution has been forthcoming to this point. Details are sketchy.]
On Mon, Sep 20, 2010 at 3:18 PM, Moshe Weitzman <weitzman@tejasa.com> wrote: datetime was removed under some dubious circumstances. you can depend on date api module to get it back or probably better is to switch to int if you can. see http://drupal.org/node/866340
On Mon, Sep 20, 2010 at 10:08 AM, Bob Hutchinson <hutchlists@midwales.com> wrote:
I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult,
I am testing this on Ubuntu 10.04, fully up to date.
-- ----------------- Bob Hutchinson Midwales dot com -----------------
-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450
Personally, I would rather that a solution be found to get the database date/time formats back. I had enough of Y2K, I don't need to do it again in 2038. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: E.J. Zufelt Since I just noticed this concurrent to receiving this message I guess I will ask here. Would I be correct in assuming that there is currently no date widget for the Integer field in Drupal 7? Date is a pretty common field type (I would think). Other than possibly the Date module is anyone aware of a Date widget for Integers under development? I'd be happy to contribute, since this is something that I actually need.
On Monday 20 September 2010, Moshe Weitzman wrote:
datetime was removed under some dubious circumstances. you can depend on date api module to get it back or probably better is to switch to int if you can. see http://drupal.org/node/866340
Oh dear what a mess. Thanks for the prompt reply, at least I know what to do, not too bad as the dates are just a record and should still sort. Upgrade routine from D6 will be a nasty hack though. Ugh. The info provided in schema.inc (line 40+) should be updated, us mere mortals (contrib maintainers) do rely on the comments in core for guidance of what can and cannot be done.
On Mon, Sep 20, 2010 at 10:08 AM, Bob Hutchinson
<hutchlists@midwales.com> wrote:
I'm having problems with a database field which is type 'datetime' in a Drupal 7 install, using alpha7. It installed OK a few months ago but now causes the module install to crash, it would appear that the datetime type is no longer supported or this is a bug in the PDO Database Abstraction Layer. I notice that core modules using timestamp fields are using type 'int', should I do the same? I am reluctant to do this as it will make upgrades from D6 just that much more difficult,
I am testing this on Ubuntu 10.04, fully up to date.
-- ----------------- Bob Hutchinson Midwales dot com -----------------
-- ----------------- Bob Hutchinson Midwales dot com -----------------
participants (5)
-
Bob Hutchinson -
E.J. Zufelt -
Moshe Weitzman -
nan wich -
Randy Fay