PunBB Forums — install and InnoDB on new MySQL engines

Re: install and InnoDB on new MySQL engines

null@example.com (siprof) — Fri, 16 Sep 2016 12:25:17 +0000

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']);
    }

Re: install and InnoDB on new MySQL engines

null@example.com (KeyDog) — Wed, 17 Feb 2016 16:05:37 +0000

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

null@example.com (brewsten.coding) — Tue, 02 Feb 2016 09:36:46 +0000

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

install and InnoDB on new MySQL engines

null@example.com (artoodetoo) — Sun, 17 Jan 2016 13:16:45 +0000

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/