From 49bfc08757b727a02ccc944833536712f23384e2 Mon Sep 17 00:00:00 2001
From: Christian Weber
Date: Thu, 11 Oct 2007 00:07:55 +0000
Subject: correct _field[]['Length'] for datetime fields

---
 it_dbi.class | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'it_dbi.class')

diff --git a/it_dbi.class b/it_dbi.class
index b2b7f0e..4e855e4 100644
--- a/it_dbi.class
+++ b/it_dbi.class
@@ -627,7 +627,7 @@ function _get_field_info()
 	{
 		debug("it_dbi(): no fields for {$this->_p['dbid']}.{$this->_p['table']}, calculating.", 5);
 		for ($res = $this->query('SHOW COLUMNS FROM ' . $this->_p['table']); $field = mysql_fetch_assoc($res);)
-			$this->_fields[$field['Field']] = $field + array('Length' => intval(it::match('\d+', $field['Type'])));
+			$this->_fields[$field['Field']] = $field + array('Length' => ($field['Type'] == 'datetime') ? 20 : intval(it::match('\d+', $field['Type'])));
 
 		$GLOBALS['it_dbi']->_state[$this->_p['dbid']]['fields'][$this->_p['table']] = $this->_fields;
 	}
-- 
cgit v1.2.3