Was bedeutet das?
Verfasst: 19.02.2006 17:07
Hallo! habe den "SEARCH IN USERPROFILES-MOD" und den "USERCARS-MOD" installiert. nun würde ich gerne mit der so erweiterten suche die einzelnen felder des USERCARS-MOD durchsuchen...
habe daher in der search.php diese zeilen
so geändert (also um die punkte mit "usercars_carname" erweitert):
leider scheint das sO nicht zu funktionieren...
denn nachdem drcüken des "Suchen"-Knopfs erscheint:
Allgemeiner Fehler
Could not read user profile data
DEBUG MODE
SQL Error : 1054 Unknown column 'usercars_carname' in 'field list'
SELECT user_interests, user_occ, user_from, user_website, usercars_carname, user_id FROM phpbb_users WHERE user_active = 1 AND disallow_profile_search = 0
Line : 1233
File : search.php
weiß jemand was ich falsch mach?
habe daher in der search.php diese zeilen
Code: Alles auswählen
//
// Search profile fields settings - BEGIN
// Insert all wanted fields and new fields from other profile mods
//
$search_profile_fields = array(1 => 'user_interests', 2 => 'user_occ', 3 => 'user_from', 4 => 'user_website');
$search_profile_fields_sql = 'user_interests, user_occ, user_from, user_website';
$search_profile_fields_names = array($lang['Interests'], $lang['Occupation'], $lang['Location'], $lang['Website']);
$search_profile_fields_select = '<option value="0">'.$lang['All'].'</option>';
$i = 0;
foreach($search_profile_fields_names as $profile_field)
{
$i++;
$search_profile_fields_select .= '<option value="'.$i.'">'.$profile_field.'</option>';
}
// Search profile fields settings - END
Code: Alles auswählen
//
// Search profile fields settings - BEGIN
// Insert all wanted fields and new fields from other profile mods
//
$search_profile_fields = array(1 => 'user_interests', 2 => 'user_occ', 3 => 'user_from', 4 => 'user_website', 5=> 'usercars_carname');
$search_profile_fields_sql = 'user_interests, user_occ, user_from, user_website, usercars_carname';
$search_profile_fields_names = array($lang['Interests'], $lang['Occupation'], $lang['Location'], $lang['Website'], $lang['usercars_carname']);
$search_profile_fields_select = '<option value="0">'.$lang['All'].'</option>';
$i = 0;
foreach($search_profile_fields_names as $profile_field)
{
$i++;
$search_profile_fields_select .= '<option value="'.$i.'">'.$profile_field.'</option>';
}
// Search profile fields settings - END
denn nachdem drcüken des "Suchen"-Knopfs erscheint:
Allgemeiner Fehler
Could not read user profile data
DEBUG MODE
SQL Error : 1054 Unknown column 'usercars_carname' in 'field list'
SELECT user_interests, user_occ, user_from, user_website, usercars_carname, user_id FROM phpbb_users WHERE user_active = 1 AND disallow_profile_search = 0
Line : 1233
File : search.php
weiß jemand was ich falsch mach?
