problematic utstats 4.2.8

[McNamara]

When i type this into PhpMyAdmin

CREATE TEMPORARY TABLE `uts_temp_7gfgfe3` (
`id` mediumint( 5 ) NOT NULL ,
`col0` char( 20 ) NOT NULL default '',
`col1` char( 120 ) NOT NULL default '',
`col2` char( 120 ) NOT NULL default '',
`col3` char( 120 ) NOT NULL default '',
`col4` char( 120 ) NOT NULL default '',
KEY `part1` ( `col1` ( 20 ) , `col2` ( 20 ) ) ,
KEY `part2` ( `col0` ( 20 ) , `col1` ( 20 ) , `col2` ( 20 ) ) ,
KEY `full` ( `col0` ( 20 ) , `col1` ( 20 ) , `col2` ( 20 ) , `col3` ( 20 ) , `col4` ( 20 ) )
) TYPE = 'MyISAM');

it shows
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 11
When i remove
) TYPE = 'MyISAM');
and leave );
Your SQL query has been executed successfully ( Query took 0.0015 sec )

[iDeFiX]

It was already described here.

[McNamara]

please open a new thread instead of hijacking one. (c) rork