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!

-- 



Reply via email to