// Show complete SQL error and path to administrators only

// Additionally show complete error on installation or if extended debug mode is enabled

// The DEBUG_EXTRA constant is for development only!

{

// Print out a nice backtrace...

$backtrace = get_backtrace();

<?php

*

* @package install

* @version $Id$

*

*/

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

{

$exit = false;

if (version_compare($current_version, '3.0.RC3', '<='))

{

<br />

flush();

$submit = (isset($_POST['resolve_conflicts'])) ? true : false;

}

}

}

// after RC3 a different utf8_clean_string function is used, this requires that

// the unique column username_clean is recalculated, during this recalculation

// duplicates might be created. Since the column has to be unique such usernames

$result = $db->sql_query($sql);

$colliding_users = $found_names = array();

while ($row = $db->sql_fetchrow($result))

{

// Calculate the new clean name. If it differs from the old one we need

// to make sure there is no collision

$clean_name = utf8_new_clean_string($row['username']);

if ($clean_name != $row['username_clean'])

{

$user_id = (int) $row['user_id'];

// If this clean name was not the result of another user already ...

// who already had this clean name with the old version

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

$result2 = $db->sql_query($sql);

$user_ids = array($user_id);

while ($row = $db->sql_fetchrow($result2))

{

// Make sure this clean name will still be the same with the

// new function. If it is, then we have to add it to the list

// of user ids for this clean name

}

}

}

}

$db->sql_freeresult($result);

// for the admin: keep name, change name (with text input) or delete user

$u_action = "database_update.$phpEx?language=$language&amp;type=$inline_update";

?>

<p><?php echo $lang['CHANGE_CLEAN_NAMES']; ?></p>

<form id="change_clean_names" method="post" action="<?php echo $u_action; ?>">

</form>

<?php

}

{

$sql = 'SELECT user_id, username, username_clean

FROM ' . USERS_TABLE . '

while ($row = $db->sql_fetchrow($result))

{

$clean_name = utf8_new_clean_string($row['username']);

if ($clean_name != $row['username_clean'])

{

$user_id = (int) $row['user_id'];

$found_names[$user_id] = $clean_name;

// impossible unique clean name

$db->sql_query($sql);

}

}

'CHANGE' => 'Change',

'CHECK_TABLE_PREFIX' => 'Please check your table prefix and try again.',

'CLEAN_VERIFY' => 'Cleaning up and verifying the final structure',

'COLLIDING_CLEAN_USERNAME' => '<strong>%s</strong> is the clean username for:',

'COLLIDING_USERNAMES_FOUND' => 'Colliding usernames were found on your old board. In order to complete the conversion please delete or rename these users so that there is only one user on your old board for each clean username.',

'COLLIDING_USER' => '» user id: <strong>%d</strong> username: <strong>%s</strong> (%d posts)',

'INST_ERR_USER_TOO_SHORT' => 'The username you entered is too short. The minimum length is 3 characters.',

'INVALID_PRIMARY_KEY' => 'Invalid primary key : %s',

// mbstring

'MBSTRING_CHECK' => '<samp>mbstring</samp> extension check',

'MBSTRING_CHECK_EXPLAIN' => '<strong>Required</strong> - <samp>mbstring</samp> is a PHP extension that provides multibyte string functions. Certain features of mbstring are not compatible with phpBB and must be disabled.',