There are some who contend that 'type' is a MySQL reserved word on certain versions of MySQL:

http://docsrv.caldera.com:8457/cgi-bin/info2html?(mysql.info.gz)Reserved%2520words

In the 4.5.1 database, there is a type field in the email table, and likely others.

Here is a search from the SQL file for type:

`type` varchar(255) default NULL,
`type` varchar(25) default NULL,
KEY `idx_email_assigned` (`assigned_user_id`,`type`,`status`)
`type` varchar(255) NOT NULL default '',
`type` varchar(30) default NULL,
`type` varchar(25) default NULL,
KEY `idx_vcal` (`type`,`user_id`)

Just as a matter of form, it seems like these should be renamed, if only for clarification.

The email `type` field may be causing some group by problems under MySQL Server version: 4.1.21-standard-log.

Thanks,
Ken