search

google-code-backups / yii-usergroups

Automatically exported from code.google.com/p/yii-usergroups
0 stars 0 forks source link

Installation fails to create tables #18

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Installing userGroups module on Win7 system with IIS and MySQL

What is the expected output? What do you see instead?

Database tables should be automatically created. 

Instead, Installation fails with a message "Unable to create the tables in the 
database..... " 

What version of the product are you using? On what operating system?

Microsoft Win7
Microsoft IIS/7.5
MySQL 5.0.51a
userGroups 1.7.1

Please provide any additional information below.

The problem is caused by specifying the database engine = InnoDB when the 
tables are created. 
Testing the tables creation using phpMyAdmin gives the error "#1286 - Unknown 
table engine 'InnoDB'"

Resolution : Remove the text 'ENGINE=InnoDB' from InstallController.php

Original issue reported on code.google.com by kossaw....@gmail.com on 20 Jul 2011 at 10:44

GoogleCodeExporter commented 8 years ago 
as already explained we need InnoDB, you are suppose to install the engine, and 
not the other way around.

Original comment by nic...@creationgears.com on 5 Aug 2011 at 7:56