OperationalError: (1054, "Unknown column 'feed.to_player' in 'on
clause'")
mysql> show fields from feed;
+--------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| account_id | int(11) | YES | MUL | NULL | |
| date_created | datetime | YES | | NULL | |
| to_player | int(11) | YES | MUL | NULL | |
| message | longtext | YES | | NULL | |
+--------------+----------+------+-----+---------+----------------+
The app
@character_required()
def index():
friends = db(db.friends.account_id==session.account.id).select
(db.friends.friend)
thelist = []
for f in friends:
thelist.append(f['friend'])
if len(thelist) > 0:
accounts2 = db.accounts.with_alias("accounts2")
rows = (accounts2.id==db.feed.to_player)
feeds = db((db.feed.account_id.belongs(thelist))&
(db.accounts.id==db.feed.account_id)).select(db.feed.ALL,
db.accounts.name, accounts2.id, accounts2.name, left=accounts2.on
(rows), orderby=~db.feed.id, limitby=(0, 10))
try:
accounts2 = db.accounts.with_alias("accounts2")
rows = (accounts2.id==db.feed.to_player)
feeds = db((db.feed.account_id.belongs(thelist))&
(db.accounts.id==db.feed.account_id)).select(db.feed.ALL,
db.accounts.name, accounts2.id, accounts2.name, left=accounts2.on
(rows), orderby=~db.feed.id, limitby=(0, 10))
except:
feeds = None
else:
thelist = None
feeds = None
return dict(feed=feeds)
def logout():
if session.has_key('account'):
del session.account
session.flash = "Logged out of your character"
return redirect(URL(r=request, c='account', f='index', args=''))
def show():
return dict(message="Test")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
