No need to do a fresh install. Why clobber all your test data? Check out one or more of the sqlite gui interfaces at this link:
http://stackoverflow.com/questions/1507506/what-are-good-open-source-gui-sqlite-database-managers Then drop the column using the gui. On Aug 28, 9:51 am, Juan Tiger <goldenboy...@gmail.com> wrote: > I using sqlite, alter table does not support drop columns, so you must try a > fresh install > > 2011/8/24 Johann Spies <johann.sp...@gmail.com> > > > > > > > > > > > TypeError: <lambda>() takes exactly 1 argument (2 given) > > > I still get this error with the following model (all 'represent' lines > > commented out): > > > db.define_table('akb_articles', > > Field('title'), > > Field('primaryauthor'), > > Field('authors', 'text'), > > Field('rp_author', length=64, > > requires = > > IS_EMPTY_OR(IS_IN_DB(db,'akb_reprint.uuid', '%(rp_author)s'))), > > Field('journal', > > requires = IS_IN_DB(db,'akb_journal.uuid', > > '%(title)s')), > > Field('bib_id'), > > Field('bib_pages'), > > Field('doctype'), > > Field('language'), > > Field('abstract', 'text'), > > Field('bib_vol'), > > Field('bib_date'), > > Field('url'), > > Field('pubyear', compute= lambda x: x['bib_date'][-4:]), > > Field('ut', # isi-unieke rekordnommer > > > requires=IS_EMPTY_OR(IS_NOT_IN_DB(db,'akb_articles.ut'))), > > Field('scopus_id', > > requires=IS_EMPTY_OR(IS_NOT_IN_DB(db,'akb_articles.scopus_id'))), > > Field('sabinet_id', > > requires=IS_EMPTY_OR(IS_NOT_IN_DB(db,'akb_articles.sabinet_id'))), > > Field('isap_id', > > requires=IS_EMPTY_OR(IS_NOT_IN_DB(db,'akb_articles.isap_id'))), > > Field('category', 'list:string', IS_EMPTY_OR( > > IS_IN_DB(db,'akb_categories.uuid', > > '%(category)s', > > multiple=True))), > > Field('heading', 'list:string', IS_EMPTY_OR( > > IS_IN_DB(db,'akb_headings.uuid', '%(headings)s', > > multiple=True))), > > Field('art_eq',compute= lambda x: art_ekw(x)), > > akb_signature, > > #format = '%(title)s' > > ) > > > There is no 'lambda' in akb_signature. > > > Regards > > Johann > > > -- > > May grace and peace be yours in abundance through the full knowledge of > > God and of Jesus our Lord! His divine power has given us everything we need > > for life and godliness through the full knowledge of the one who called us > > by his own glory and excellence. > > 2 Pet. 1:2b,3a
