I'm working through the Friends example in the Web2py Application Cookbook,
and when I try the friends.html view, I get the following error:
<class 'sqlite3.OperationalError'> no such column: auth_user.first_name
My friends.html view is as follows:
{{extend 'layout.html'}}
<h2>Friendship Offered</h2>
<table>
{{for friend in friends:}}
<tr>
<td>{{=A(name_of(db.auth_user(friend.source)),_href=URL('wall',args=friend.source))}}
</td>
<td>{{if friend.accepted:}}accepted{{else:}}<button
onclick="ajax('{{=URL('friendship',args=('accept',friend.source))}}',
[],null); $(this).parent().html('accepted')">accept</button>{{pass}}</
td>
<td><button
onclick="ajax('{{=URL('friendship',args=('deny',friend.source))}}',
[],null); $(this).parent().html('denied')">deny</button></td>
</tr>
{{pass}}
</table>
<h2>Friendship Requested</h2>
<table>
{{for friend in requests:}}
<tr>
<td>{{=A(name_of(db.auth_user(friend.target)),_href=URL('wall',args=friend.target))}}
</td>
<td>{{if friend.accepted:}}accepted{{else:}}pending{{pass}}</td>
<td><button
onclick="ajax('{{=URL('friendship',args=('deny',friend.target))}}',
[],null); $(this).parent().html('removed')">remove</button></td>
</tr>
{{pass}}
</table>
Any help with this error would be greatly appreciated!
--