You need to also revert the default mybb template.
admin>templates & style > templates > find updated templates
In this new menu you will see a list. Most likely with several templates listed. Find the default templates and on the options button on the right of all of them click "revert to original"
Which error?? The SQL error or the undefined error in the welcomeblock??
This is why we tell people to make their own threads, it just gets confusing.
I had the Undefined error too. too get rid of it find this code in the header_welcomeblock_guest template:
<!--
lang.username = "{$lang->login_username}";
lang.password = "{$lang->login_password}";
lang.login = "{$lang->login}";
lang.lost_password = " — <a href=\"{$mybb->settings['bburl']}/member.php?action=lostpw\">{$lang->lost_password}<\/a>";
Replace with the code below and make sure that you updated your language files with the 1.6 language files:
<!-- lang.username = "{$lang->login_username}";
lang.password = "{$lang->login_password}";
lang.login = "{$lang->login}";
lang.lost_password = " — <a href=\"{$mybb->settings['bburl']}/member.php?action=lostpw\">{$lang->lost_password}<\/a>"; lang.register_url = " — <a href=\"{$mybb->settings['bburl']}/member.php?action=register\">{$lang->welcome_register}<\/a>"; lang.remember_me = "{$lang->remember_me}";// -->