Sorry, I had a debug line in db.py. The actual offending line there is 726.
-Jim
On Thursday, August 30, 2012 4:44:40 PM UTC-5, Jim S wrote:
>
> Hi – sorry if this gets there multiple times, but I’ve posted twice in the
> past 6 hours and it hasn’t shown up yet:
>
>
>
> I’m getting the following:
>
>
>
> Traceback (most recent call last):
>
> File "C:\dev\web2py\gluon\restricted.py", line 209, in restricted
>
> exec ccode in environment
>
> File "C:/dev/web2py/applications/infocenter/models/db.py", line 88, in
> <module>
>
> auth.define_tables() # creates all needed
> tables
>
> File "C:\dev\web2py\gluon\tools.py", line 1501, in define_tables
>
> fake_migrate=fake_migrate))
>
> File "C:\dev\web2py\gluon\dal.py", line 7051, in define_table
>
> table = self.lazy_define_table(tablename,*fields,**args)
>
> File "C:\dev\web2py\gluon\dal.py", line 7082, in lazy_define_table
>
> polymodel=polymodel)
>
> File "C:\dev\web2py\gluon\dal.py", line 727, in create_table
>
> on_delete_action=field.ondelete)
>
> KeyError: 'index_name`'
>
>
>
> Offending line of my code is:
>
> auth.define_tables()
>
>
>
> Code up to that point:
>
>
>
> from gluon.custom_import import track_changes
>
> track_changes()
>
>
>
> import icUtil
>
> import infoCenterUtil
>
> import logging
>
> from dateutil.relativedelta import *
>
> from dateutil.parser import *
>
> import datetime
>
> import os
>
> from plugin_suggest_widget import suggest_widget
>
>
>
> log = logging.getLogger('InfoCenter')
>
> if len(log.handlers) == 0:
>
> log = icUtil.getLog(loggerName='InfoCenter', level='INFO', echo=True)
>
>
>
> if infoCenterUtil.migrate():
>
> db = DAL(infoCenterUtil.getDalString(), bigint_id=True)
>
> else:
>
> db = DAL(infoCenterUtil.getDalString(), migrate=False,
>
> migrate_enabled=False, bigint_id=True)
>
>
>
> # by default give a view/generic.extension to all actions from localhost
>
> # none otherwise. a pattern can be 'controller/function.extension'
>
> response.generic_patterns = ['*'] if request.is_local else []
>
>
>
> #print request.env.path_info
>
>
>
> #########################################################################
>
> ## Here is sample code if you need for
>
> ## - email capabilities
>
> ## - authentication (registration, login, logout, ... )
>
> ## - authorization (role based authorization)
>
> ## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
>
> ## - crud actions
>
> ## (more options discussed in gluon/tools.py)
>
> #########################################################################
>
>
>
> from gluon.tools import Mail, Auth, Crud, Service, PluginManager,
> prettydate
>
>
>
> mail = Mail() # mailer
>
> auth = Auth(db) #
> authentication/authorization
>
> crud = Crud(db) # for CRUD helpers using
> auth
>
> service = Service() # for json, xml, jsonrpc,
> xmlrpc, amfrpc
>
> plugins = PluginManager()
>
>
>
> from gluon.contrib.login_methods.email_auth import email_auth
>
> #auth.settings.login_methods.append((email_auth('smtp.asdfasdf.com:587',
> '@asdfasd.com')))
>
> auth.settings.login_methods.append((email_auth('mail.asdfasdf.com', '@
> sadfs.com')))
>
>
>
> mail.settings.server = 'mail.asdfjl.com' # your SMTP server
>
> mail.settings.sender = '[email protected]' # your email
>
> mail.settings.login = 'asdf:alkdsjl' # your credentials or None
>
>
>
> auth.settings.hmac_key = 'sha512:9d8d83af-6548-410b-9cf5-e01a163b498d' #
> before define_tables()
>
>
>
> auth_user = db.define_table(
>
> auth.settings.table_user_name,
>
> Field('first_name', length=128, default='', required=True),
>
> Field('last_name', length=128, default='', required=True),
>
> Field('email', length=128, unique=True, required=True),
>
> Field('password', 'password', length=512,
>
> readable=True, writable=True, label='Password'),
>
> Field('registration_key', length=512,
>
> writable=False, readable=False, default=''),
>
> Field('reset_password_key', length=512,
>
> writable=False, readable=False, default=''),
>
> Field('registration_id', length=512,
>
> writable=False, readable=False, default=''),
>
> Field('brillLogon', length=10, default='', label='Brill Logon'),
>
> Field('technician', 'boolean', default=False),
>
> Field('dispatcher', 'boolean', default=False),
>
> Field('lastFirst', compute=lambda u: '%s, %s' % (u['last_name'],
> u['first_name']), label='Name'),
>
> Field('firstLast', compute=lambda u: '%s %s' % (u['first_name'],
> u['last_name']), label='Name'),
>
> format='%(last_name)s, %(first_name)s')
>
>
>
> auth_user.first_name.requires =
> IS_NOT_EMPTY(error_message=auth.messages.is_empty)
>
> auth_user.last_name.requires =
> IS_NOT_EMPTY(error_message=auth.messages.is_empty)
>
> auth_user.password.requires = [CRYPT()]
>
> auth_user.email.requires =
> [IS_EMAIL(error_message=auth.messages.invalid_email),
>
> IS_NOT_IN_DB(db, auth_user.email),
>
> IS_NOT_EMPTY(error_message=auth.messages.is_empty)]
>
> auth_user.id.readable = False
>
> auth_user._plural = 'Users'
>
>
>
> auth.settings.table_user = auth_user
>
>
>
> auth.define_tables()
>
>
>
>
>
> Anyone with any idea why this is happening? Seems to be when it is
> processing the auth_membership table. Happens on existing or new (empty,
> no tables) database. Will create auth_user and auth_group on clean db
> before it fails.
>
>
>
> -Jim
>
>
>
--
