Problem

If you are getting error similar to this during installation:

Error in query "CREATE TABLE `iu3_content` ( `id` int(11) NOT NULL auto_increment, `codename` text NOT NULL, `text` text character set utf8 collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; " - MySQL said: 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 'character set utf8 collate utf8_unicode_ci NOT NULL, PRIMARY

Error in query "INSERT INTO `iu3_content` (`id`, `codename`, `text`) VALUES (1, 'default', 'This is your first IU powered page! Now go create another one.rn'); " - MySQL said: Table 'iu2.iu_content' doesn't exist

Error in query "CREATE TABLE `iu3_users` ( `id` int(11) NOT NULL auto_increment, `user` text NOT NULL, `pass` text NOT NULL, `status` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;" - MySQL said: 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 'DEFAULT CHARSET=utf8' at line 1

...

Solution

This is error is shown due to old version of MySQL which don't have support for UTF-8 encoding. To solve this problem, download patch (iu3_tables_fix.zip, 1 KB), and unpack it to manage/install/sql/ folder overwriting existing tables.sql file. Then empty your MySQL database (delete any IU tables created in previous installation attempt, if any), and try to install Instant Update again. This should solve the problem and install IU correctly. Note that after applying this patch, you won't be able to use UTF-8 characters in your web site (or they'll be converted to their respective HTML entities).