1 (edited by artoodetoo 2016-01-17 13:25)

Topic: install and InnoDB on new MySQL engines

Since MySQL 5.6 there is no variable `have_innodb`.
So, you cannot use install option "MySQL Improved (InnoDB)" or 'MySQL Standard (InnoDB)'.

Because of
https://github.com/punbb/punbb/blob/mas … l.php#L483

            $result = $forum_db->query('SHOW VARIABLES LIKE \'have_innodb\'');
            $row = $forum_db->fetch_assoc($result);
            if (!$row || !isset($row['Value']) || strtolower($row['Value']) != 'yes')
            {
                error($lang_install['MySQL InnoDB Not Supported']);
            }

You can adopt workaround from FluxBB ticket http://fluxbb.org/development/core/tickets/1078/

DigitalOcean: VPS from $5/mon. Get $10 bonus!.

Re: install and InnoDB on new MySQL engines

wow! this is great news. thanks for the info!

Re: install and InnoDB on new MySQL engines

thanks , so the solution was to add/change  install.php

// Check if InnoDB is available
    if ($db_type == 'mysql_innodb' || $db_type == 'mysqli_innodb')
    {
        $result = $db->query('SELECT SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = \'InnoDB\'');
        list ($result) = $db->fetch_row($result);
        if (!in_array($result, array('YES', 'DEFAULT')))
            error($lang_install['InnoDB off']);
    }

from

// Check InnoDB support in DB
        if (in_array($db_type, array('mysql_innodb', 'mysqli_innodb')))
        {
            $result = $forum_db->query('SHOW VARIABLES LIKE \'have_innodb\'');
            $row = $forum_db->fetch_assoc($result);
            if (!$row || !isset($row['Value']) || strtolower($row['Value']) != 'yes')
            {
                error($lang_install['MySQL InnoDB Not Supported']);
            }
        }

based on
http://stackoverflow.com/questions/1051 … 2#10517292

Re: install and InnoDB on new MySQL engines

Hello, I found that, in order to works, the solution needs extra edit, from $db to $forum_db

// Check if InnoDB is available
    if ($db_type == 'mysql_innodb' || $db_type == 'mysqli_innodb')
    {
        $result = $forum_db->query('SELECT SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = \'InnoDB\'');
        list ($result) = $forum_db->fetch_row($result);
        if (!in_array($result, array('YES', 'DEFAULT')))
            error($lang_install['InnoDB off']);
    }