Thanks, Massimo. I studied the ticket a little more closely, and it looks like it was a problem with the controller.
I had: *friends = db(Link.target==me).select(orderby=alphabetical)* But the "alphabetical" variable stores a query that references db.auth_user, so I changed it to: *friends = db(Link.target==me)(Link.target==db.auth_user.id ).select(orderby=alphabetical)* and everything appears to be working now. On Tue, Aug 21, 2012 at 9:42 AM, Massimo Di Pierro < [email protected]> wrote: > please try delete eveything in yourapp/databasaes > > > On Tuesday, 21 August 2012 08:35:52 UTC-5, pjryan126 wrote: >> >> 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! >> > -- > > > > --
