Tried using this as logging tool:
http://mdp.cti.depaul.edu/AlterEgo/default/show/194
But it didn't record where I have the problem at all (even after my
patches).
The controller:
def view():
#try:
board = db(db.mb_boards.id==request.args[0]).select()[0]
rows = (db.auth_user.id==db.mb_posts.posted_by)
mb_posts2 = db.mb_posts.with_alias("mb_posts2")
rows2 = (mb_posts2.reply_to==db.mb_posts.id)
mb_posts3 = db.mb_posts.with_alias("mb_posts3")
threads = db((db.mb_posts.board_id==request.args[0])&
(db.mb_posts.reply_to==None)).select(db.mb_posts.ALL,
db.auth_user.ALL,mb_posts2.id.count(), db
(mb_posts3.reply_to==db.mb_posts.id)._select(mb_posts3.id,
orderby=~mb_posts3.id, limitby=(0,1)), left=(db.auth_user.on
(rows),mb_posts2.on(rows2)), groupby=db.mb_posts.id)
return dict(board=board, threads=threads)
#except:
# session.flash = "This board doesn't exist."
# redirect(URL(r=request, f='index'))
The problem:
ProgrammingError: (1064, "You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT mb_posts3.id FROM mb_posts3, mb_posts WHERE
mb_posts3.reply_to=mb_posts.i' at line 1")
What I'm trying to do:
mb_posts2 = The # of replies within that topic/thread (this works)
mb_posts3 = The last reply created within that topic (sub query will
do fine).
I've tried various ways, the aggregate way, another left join, nothing
seems to work. Asked a few people on the IRC as well, but they were
just as lost as me. Anyone on here have any thoughts on the situation?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
