File: includes/search/fulltext_mysql.php
Unmodified
Added
Modified
Removed
| Line 86 | Line 86 |
|---|
$engine = $info['Type'];
}
|
$engine = $info['Type'];
}
|
if ($engine != 'MyISAM')
| $fulltext_supported =
$engine === 'MyISAM' ||
// FULLTEXT is supported on InnoDB since MySQL 5.6.4 according to
// http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html
$engine === 'InnoDB' &&
phpbb_version_compare($db->sql_server_info(true), '5.6.4', '>=');
if (!$fulltext_supported)
|
{
|
{
|
return $user->lang['FULLTEXT_MYSQL_NOT_MYISAM'];
| return $user->lang['FULLTEXT_MYSQL_NOT_SUPPORTED'];
|
}
$sql = 'SHOW VARIABLES
| }
$sql = 'SHOW VARIABLES
|
| Line 707 | Line 714 |
|---|
*/
function index_remove($post_ids, $author_ids, $forum_ids)
{
|
*/
function index_remove($post_ids, $author_ids, $forum_ids)
{
|
$this->destroy_cache(array(), $author_ids);
| $this->destroy_cache(array(), array_unique($author_ids));
|
}
/**
| }
/**
|
| Line 747 | Line 754 |
|---|
{
if ($db->sql_layer == 'mysqli' || version_compare($db->sql_server_info(true), '4.1.3', '>='))
{
|
{
if ($db->sql_layer == 'mysqli' || version_compare($db->sql_server_info(true), '4.1.3', '>='))
{
|
//$alter[] = 'MODIFY post_subject varchar(100) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';
| $alter[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';
|
}
else
{
| }
else
{
|
| Line 896 | Line 903 |
|---|
}
$db->sql_freeresult($result);
|
}
$db->sql_freeresult($result);
|
$sql = 'SELECT COUNT(post_id) as total_posts
FROM ' . POSTS_TABLE;
$result = $db->sql_query($sql);
$this->stats['total_posts'] = (int) $db->sql_fetchfield('total_posts');
$db->sql_freeresult($result);
| $this->stats['total_posts'] = empty($this->stats) ? 0 : $db->get_estimated_row_count(POSTS_TABLE);
|
}
/**
| }
/**
|
