[rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email

[Wright, Cory (CDC/OID/NCEZID) (CTR)]

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: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Wednesday, October 30, 2013 7:10 PM
To: rt-users at lists.bestpractical.com
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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131030/5b93385b/attachment.htm>