Profile Error

[simpsonetti]

Hi, some days ago i deinstalled SMG Gallery. and than i installed AEVA.

Since this i don't can visit any profile. i get this error:

Unknown column 'mem.mgal_total_items' in 'field list'
File: /is/htdocs/wp1070799_4G6MI1TGH2/www/......../smf/Sources/Load.php
Line: 986

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.


SMF is in 1.1.11 .
What can i do ?

[Paul_Pauline]

Hi.

You need to get the database upgrade.php and its associated .sql file from the Large Upgrade package, place them in the root of your forum and run it.

[simpsonetti]

so i do so and it runs without any errors. but after visiting i get this message:

Database Error
Unknown column 'mem.mgal_total_items' in 'field list'
File: /is/htdocs/wp1070799_4G6MI1TGH2/www/............/smf/Sources/Load.php
Line: 986

Code Select Expand

if (!empty($users))
{
// Load the member's data.
$request = db_query("
SELECT$select_columns
FROM {$db_prefix}members AS mem$select_tables
WHERE mem." . ($is_name ? 'memberName' : 'ID_MEMBER') . (count($users) == 1 ? " = '" . current($users) . "'" : " IN ('" . implode("', '", $users) . "')"), __FILE__, __LINE__);
$new_loaded_ids = array();
while ($row = mysql_fetch_assoc($request))
{
$new_loaded_ids[] = $row['ID_MEMBER'];
$loaded_ids[] = $row['ID_MEMBER'];
$row['options'] = array();
$user_profile[$row['ID_MEMBER']] = $row;
//Happy Birthday Color ;D Hope you love it :D
if(!empty($modSettings['MemberColorBirthdayColor']) && !empty($row['birthdate']) && compare_colorBirthdate($row['birthdate'])) {
$user_profile[$row['ID_MEMBER']]['post_group_color'] = $modSettings['MemberColorBirthdayColor'];
$user_profile[$row['ID_MEMBER']]['member_group_color'] = $modSettings['MemberColorBirthdayColor'];
}
//Color Banned user, replace there color... hope they are not moderators ;P?
if(!empty($modSettings['MemberColorBanned']) && isset($row['is_activated']) && $row['is_activated'] >= 10) {
$user_profile[$row['ID_MEMBER']]['post_group_color'] = $modSettings['MemberColorBanned'];
$user_profile[$row['ID_MEMBER']]['member_group_color'] = $modSettings['MemberColorBanned'];
}
//Memeber Color Link Data, i store them for later use
if($set == 'normal' || $set == 'profile') //This are the only sets with the infos i need.
$color_profile[$row['ID_MEMBER']] = array(
'ID_MEMBER' => $row['ID_MEMBER'],
'realName' => $row['realName'],
'member_group_color' => $user_profile[$row['ID_MEMBER']]['member_group_color'],
'post_group_color' => $user_profile[$row['ID_MEMBER']]['post_group_color'],
);
}
mysql_free_result($request);
}

this is the area with the coe and this the line 986:

Code Select Expand

WHERE mem." . ($is_name ? 'memberName' : 'ID_MEMBER') . (count($users) == 1 ? " = '" . current($users) . "'" : " IN ('" . implode("', '", $users) . "')"), __FILE__, __LINE__);


so what to do further ?