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

  • Registered: 2007-03-15
  • Posts: 31

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!.
  • Registered: 2016-01-06
  • Posts: 6

Re: install and InnoDB on new MySQL engines

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

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

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

  • siprof
  • siprof
  • Junior Member
  • Offline
  • Registered: 2016-09-16
  • Posts: 2

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