Hi, I have extended the default auth_user table in my model file db.py as follows:
db = DAL('google:datastore') from gluon.tools import Auth auth = Auth(db, hmac_key=Auth.get_or_create_key()) auth.settings.extra_fields['auth_user'] = [ Field('first_name','string',required=True, notnull=True), Field('last_name','string',default=''), Field('fb_id','string',length=512,required=True), Field('create_ts','datetime'), Field('change_ts','datetime') ] auth.define_tables() Also below this code I have also written an insert for inserting data in the auth_user table as: def new_user(first_name, last_name, email, passw,fb_id): users = db(db.auth_user.email==email).select() if users: return users[0].id else: my_crypt = CRYPT(key=auth.settings.hmac_key) crypt_pass = my_crypt(passw)[0] id_user= db.auth_user.insert( first_name=first_name, last_name=last_name, email = email, password = crypt_pass, fb_id = fb_id ) return id_user iduser = new_user('ABCD','EFGH','sushant.tanej...@gmail.com','password','8345935345') This insert I got from some other post in the group. The insert was successful and auth_user table has been created. Although no other auth table was created. Now in my controller function I check if fb_id of a user already exists in my auth_user table or not def get_existing_friends(): """ This function returns a CSV text of FB_IDs of friends which already exists """ user_fb_id = request.vars.userFBID if db(db.auth_user.fb_id==user_fb_id).select(): return "jQuery('.foundFriends').html('This facebook user is already registered');" On execution nothing happens and GAE logs the following error message: Traceback (most recent call last): File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/gluon/restricted.py", line 204, in restricted exec ccode in environment File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/applications/devekayan/controllers/registration.py", line 63, in <module> File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/gluon/globals.py", line 172, in <lambda> self._caller = lambda f: f() File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/applications/devekayan/controllers/registration.py", line 19, in get_existing_friends if db(db.auth_user.fb_id==user_fb_id).select(): File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/gluon/dal.py", line 5119, in __getattr__ return self[key] File "/home/sushant/Ekayan/src/dev/google_appengine/web2py/gluon/dal.py", line 5113, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'auth_user' Can somebody help me understand the above ? Thanks, Sushant