Interesting problem I've encountered. I'm getting the error: *<type 'exceptions.SyntaxError'> invalid table/column name "comment" is a "ALL" reserved SQL/NOSQL keyword* * * after defining my tables as such: # define tables for blog posts db.define_table('post', Field('title', unique=True), Field('body', 'text'), format = '%(title)s')
# define tables for comments on a blog post db.define_table('comment', Field('post_id', 'reference post'), Field('author'), Field('email'), Field('body', 'text')) db.post.title.requires = IS_NOT_IN_DB(db, db.post.title) db.post.body.requires = IS_NOT_EMPTY() db.comment.post_id.requires = IS_IN_DB(db, db.post.id, '%(title)s') db.comment.author.requires = IS_NOT_EMPTY() db.comment.email.requires = IS_EMAIL() db.comment.body.requires = IS_NOT_EMPTY() Comment isn't a reserved keyword by mysql from what I have looked up. I've tried to look this up in google and got nowhere, so here I am again. xD Currently self-teaching myself python and web2py and do plan to pay it forward to open-source in the future and all help is appreciated in advance! -Jeremy -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.