Yes.Is is this file right: pkg_communitybuilder_2.4.5+build.2020.05.07.21.35.06.e8f8a6125.zip
Nope, issue with that query was entirely in core CB.Does the other plugins require updates as well?
Please Log in to join the conversation.
if ( $_CB_database->isDbCollationCaseInsensitive() ) {
$query .= "\n WHERE ( u." . $_CB_database->NameQuote( 'username' ) . " = " . $_CB_database->Quote( trim( $username ) )
. ' OR c.' . $_CB_database->NameQuote( 'alias' ) . ' = ' . $_CB_database->Quote( trim( $username ) ) . ' )';
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT u.`id` FROM `#_comprofiler` AS c INNER JOIN `#_users` AS u ON u.`id` = c.`id` WHERE ( u.`username` = 'xxxxx' OR c.`alias` = 'xxxxx' ) LIMIT 0, 1
Please Log in to join the conversation.
krileon wrote: The check in performCheckUsername within comprofiler.php was changed. Are you sure your install has the latest build installed? I've manually downloaded it and reviewed its files and appears fine.
if ( $function == 'testexists' ) {
if ( $_CB_database->isDbCollationCaseInsensitive() ) {
$query .= "\n WHERE u." . $_CB_database->NameQuote( 'username' ) . " = " . $_CB_database->Quote( trim( $username ) );
} else {
$query .= "\n WHERE LOWER( u." . $_CB_database->NameQuote( 'username' ) . " ) = " . $_CB_database->Quote( strtolower( trim( $username ) ) );
}
} else {
if ( $_CB_database->isDbCollationCaseInsensitive() ) {
$query .= "\n WHERE ( u." . $_CB_database->NameQuote( 'username' ) . " = " . $_CB_database->Quote( trim( $username ) )
. ' OR c.' . $_CB_database->NameQuote( 'alias' ) . ' = ' . $_CB_database->Quote( trim( $username ) ) . ' )';
} else {
$query .= "\n WHERE ( LOWER( u." . $_CB_database->NameQuote( 'username' ) . " ) = " . $_CB_database->Quote( strtolower( trim( $username ) ) )
. ' OR LOWER( c.' . $_CB_database->NameQuote( 'alias' ) . ' ) = ' . $_CB_database->Quote( strtolower( trim( $username ) ) ) . ' )';
}
}
$_CB_database->setQuery( $query, 0, 1 );
Please Log in to join the conversation.
Please Log in to join the conversation.