goFrendiAsgard / No-CMS

No-CMS, A CodeIgniter Based CMS Framework
299 stars 199 forks source link

Your database doesn't support Innodb #60

Closed tarunhere closed 11 years ago

tarunhere commented 11 years ago

I am installing this on Mac OS X, I have checked the settings, n Mysql does support and Innodb and its default also. Still, why I am getting this error, not sure. screen shot 2013-07-26 at 8 39 39 pm

Any help appreciated.

Please find other screenshots which says that my default DB engine is InnoDB. phpmyadmin 3 5 7

Still while installing, I am getting this error !! install no cms

goFrendiAsgard commented 11 years ago

No-CMS 0.6.2 use this query to check whether innodb is activated or not:

show variables like 'have_innodb';

Can you please run the query via PHPMyadmin?

For temporary fix, please modify install/function.php. Comment out line 105-116

        if (!$connection) {
            $return["success"] = false;
            $return["error_message"] .= "Cannot connect to database";
        } else {
           /* comment out these lines:
            $result = @mysql_query('SHOW VARIABLES LIKE \'have_innodb\';', $connection);
            $row    = mysql_fetch_array($result);
            $innodb = $row['Value'];
            if (!$innodb) {
                $return["success"] = false;
                $return["error_message"] .= "Your database doesn't support Innodb";
            }
            */
        }

In No-CMS 0.6.5 (still on development stage) the mechanism has been changed, and this will probably not become problem.

tarunhere commented 11 years ago

I ran this script and I didn't got any result!! Here is the screenshot. phpmyadmin local

goFrendiAsgard commented 11 years ago

In my computer I get this: selection_001 This explains why the installer cannot recognize innodb setting in your computer

I think you should take the second approach. Please comment out line 105-116 of install/function.php.

tarunhere commented 11 years ago

I found this that, has_innodb has been deprecated and removed in MySQL 5.6. Thanks for quick response though.

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_have_innodb

tarunhere commented 11 years ago

I guess those lines of code at install/function.php needs to be changed. Isn't it?

goFrendiAsgard commented 11 years ago

Okay, I've just apply this fix.