how to upgrade 2.0.8 to 2.0.9?

[Sagar_king]

I am newbies in this field will somebody guide me how to upgrade without losing my old forum data

[Kindred]

http://wiki.simplemachines.org/smf/Patching

[Sagar_king]

what to do now?

[margarett]

That's hardly related to the update.
Can you attach Profile-View.php?

[Sagar_king]

That's hardly related to the update.
Can you attach Profile-View.php?

[margarett]

Not that one. The other one without the tilde after the name

[Sagar_king]

Not that one. The other one without the tilde after the name

which one dude guide me

[kat]

There'll be this:

Profile-View.php~

and this:

Profile-View.php <--- This one.

[Sagar_king]

here it is

[margarett]

As I imagined:

Code Select Expand

$request = $smcFunc['db_query']('', '
SELECT com.id_comment, com.id_member, com.comment, com.time, mem.real_name, mem.show_online,
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type, mem.avatar
FROM {db_prefix}profile_comments as com
LEFT JOIN {db_prefix}members AS mem ON (com.id_member = mem.id_member)
LEFT JOIN {db_prefix}log_online AS lo ON (lo.id_member = com.id_member)
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = com.id_member)
WHERE com.comment_member_id = {int:id_member}
ORDER BY id_comment DESC
LIMIT {int:start}, {int:maxindex}',
array(
'id_member' => $memID,
'start' => $context['start'],
'maxindex' => $maxComments,
)
);
This query doesn't exist in core SMF and it should be related to a "profile comments" MOD. You probably didn't install/remove the MOD correctly...

[Sagar_king]

will you tell how to remove/uninstall mod manually

[Kindred]

You will have to edit your file(s) manually, finding and reversing the mod installation process.

[margarett]

This might help
Manual Installation of Mods

[Kindred]

except, in reverse for UNinstallation.

[Sagar_king]

will somebody modify it and upload that will be so nice 

[kat]

If you rename Profile-View.php to Profile-View0.php and put a virgin copy from the install archive (attached) in it's place, you might be OK.

If not, you can easily delete it and rename the other file back.

'course, if there're rogue bits of code, in other files, you might get some other errors, instead...

[Sagar_king]

If you rename Profile-View.php to Profile-View0.php and put a virgin copy from the install archive (attached) in it's place, you might be OK.

If not, you can easily delete it and rename the other file back.

'course, if there're rogue bits of code, in other files, you might get some other errors, instead...

Thanks buddy helpful
SMF must give option Thanks meter thanks all who help me