title: Joomla 3.2 installation error: Table usergroups doesn't exist
body: <p>I have a problem - after fresh installation of Joomla 3.2, I get the following error from the web-based interactive automatic installation script:</p>
  
  <blockquote>
    <p>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 'USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 11
    SQL=CREATE TABLE IF NOT EXISTS <code>j32_usergroups</code> ( <code>id</code> int(10)
    unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', <code>parent_id</code>
    int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Adjacency List Reference
    Id', <code>lft</code> int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', <code>rgt</code>
    int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', <code>title</code>
    varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (<code>id</code>), UNIQUE KEY
    <code>idx_usergroup_parent_title_lookup</code> (<code>parent_id</code>,<code>title</code>), KEY
    <code>idx_usergroup_title_lookup</code> (<code>title</code>), KEY
    <code>idx_usergroup_adjacency_lookup</code> (<code>parent_id</code>), KEY
    <code>idx_usergroup_nested_set_lookup</code> (<code>lft</code>,<code>rgt</code>) USING BTREE )
    ENGINE=InnoDB DEFAULT CHARSET=utf8</p>
    
    <p>Table 'mydb_8.j32_usergroups' doesn't exist SQL=INSERT INTO
    <code>j32_usergroups</code> (<code>id</code>, <code>parent_id</code>, <code>lft</code>, <code>rgt</code>, <code>title</code>) VALUES (1,
    0, 1, 18, 'Public'), (2, 1, 8, 15, 'Registered'), (3, 2, 9, 14,
    'Author'), (4, 3, 10, 13, 'Editor'), (5, 4, 11, 12, 'Publisher'), (6,
    1, 4, 7, 'Manager'), (7, 6, 5, 6, 'Administrator'), (8, 1, 16, 17,
    'Super Users'), (9, 1, 2, 3, 'Guest')</p>
  </blockquote>
  
  <p>Seems that the installation script failed to create the table. Surprisingly, these problems were present in the version 1.x too (as I found by google). I haven't found any solution besides some hacking of the installation script. One of most used CMS must be installable in some cleaner way than this, I hope!!</p>
  
  <p>My setup:</p>
  
  <ul>
  <li>database type: MySQLi</li>
  <li>host name: localhost</li>
  <li>table prefix: j32_</li>
  </ul>
  
  <p>There are other tables in the db but no tables beginning with j32.</p>
  
  <p>PHP Version 5.4.4-14+deb7u7, MySQL 5.0.51a-24+lenny5</p>