Bug #1849 » 1849a.patch
| administrator/components/com_comprofiler/controller/controller.default.php | ||
|---|---|---|
|
|
||
|
if ( $dbId == 0 ) {
|
||
|
|
||
|
echo "<div style='text-align:left;'><p>". CBTxt::T('Checking Community Builder Datbase') .":</p>";
|
||
|
echo "<div style='text-align:left;'><p>". CBTxt::T('Checking Community Builder Database') .":</p>";
|
||
|
|
||
|
// 1. check comprofiler_field_values table for bad rows
|
||
|
$sql = "SELECT fieldvalueid,fieldid FROM #__comprofiler_field_values WHERE fieldid=0";
|
||
| ... | ... | |
|
|
||
|
} elseif ( $dbId == 2 ) {
|
||
|
|
||
|
echo "<div style='text-align:left;'><p>" . CBTxt::T('Checking Users Datbase') . ":</p>";
|
||
|
echo "<div style='text-align:left;'><p>" . CBTxt::T('Checking Users Database') . ":</p>";
|
||
|
|
||
|
// 3. check if comprofiler table is in sync with users table
|
||
|
$sql = "SELECT c.id FROM #__comprofiler c LEFT JOIN #__users u ON u.id = c.id WHERE u.id IS NULL";
|
||