mysql> show create table CustomFields;
+--------------+--(dashes truncated)-+
| Table | Create Table
|
+--------------+--(dashes truncated)-+
| CustomFields | CREATE TABLE `CustomFields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(200) DEFAULT NULL,
`Type` varchar(200) CHARACTER SET ascii DEFAULT NULL,
`RenderType` varchar(64) CHARACTER SET ascii DEFAULT NULL,
`MaxValues` int(11) DEFAULT NULL,
`Pattern` text,
`BasedOn` int(11) DEFAULT NULL,
`ValuesClass` varchar(64) CHARACTER SET ascii DEFAULT NULL,
`Description` varchar(255) DEFAULT NULL,
`SortOrder` int(11) NOT NULL DEFAULT '0',
`LookupType` varchar(255) CHARACTER SET ascii NOT NULL,
`Creator` int(11) NOT NULL DEFAULT '0',
`Created` datetime DEFAULT NULL,
`LastUpdatedBy` int(11) NOT NULL DEFAULT '0',
`LastUpdated` datetime DEFAULT NULL,
`Disabled` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 |
+--------------+--(dashes truncated)-+
1 row in set (0.00 sec)
mysql> show indexes from CustomFields;
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| CustomFields | 0 | PRIMARY | 1 | id | A
| 2 | NULL | NULL | | BTREE | |
+--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)
mysql>
- Cory
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Alex Vandiver
Sent: Wednesday, October 30, 2013 7:10 PM
To: [email protected]
Subject: Re: [rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email
On Wed, 2013-10-30 at 12:20 -0700, Kevin Falcone wrote:
> These warnings are almost certainly a culprit.
Can you show your CustomFields definitions?
SHOW CREATE TABLE CustomFields;
SHOW INDEXES FROM CustomFields;
- Alex
