You have migrations set to False. web2py needs to create a field called is_active. Before it was called active and that created problems.
On Jun 5, 6:26 pm, danto <[email protected]> wrote: > bump > > 2011/6/5 danto <[email protected]> > > > > > > > > > 2011/6/5 danto <[email protected]> > > >> I'm still can get up my site after upgrading from 1.95.1. After solving > >> the problem with logging (importing it as J. Lundell said in another > >> message) i'm running with another issue: after reinstalling with > >> webfaction's script and uploading the .w2p, tables where I have > >> auth.signature does not recognize the 'is_active' column. Strange is that > >> when I go through the shell and do a "db.table.fields()" it DOES show the > >> 'is_active' column on each table. > > >> I don't know if I'm doing something wrong. can you help me? > > > this is when I try to run a script from my site (used to work perfectly at > > 1.95.1): > > > Database drivers available: SQLite3, pymysql, PostgreSQL > > Traceback (most recent call last): > > File "/home/danto/webapps/web2py/web2py/web2py.py", line 19, in <module> > > gluon.widget.start(cron=True) > > File "/home/danto/webapps/web2py/web2py/gluon/widget.py", line 812, in > > start > > import_models=options.import_models, startfile=options.run) > > File "/home/danto/webapps/web2py/web2py/gluon/shell.py", line 204, in run > > execfile(startfile, _env) > > File > > "/home/danto/webapps/web2py/web2py/applications/blogosfera/private/actualiz > > a_feeds.py", > > line 78, in <module> > > & (db.categoria.is_active == True) > > File "/home/danto/webapps/web2py/web2py/gluon/dal.py", line 5360, in > > select > > return self.db._adapter.select(self.query,fields,attributes) > > File "/home/danto/webapps/web2py/web2py/gluon/dal.py", line 1148, in > > select > > rows = response(sql) > > File "/home/danto/webapps/web2py/web2py/gluon/dal.py", line 1138, in > > response > > self.execute(sql) > > File "/home/danto/webapps/web2py/web2py/gluon/dal.py", line 1223, in > > execute > > return self.log_execute(*a, **b) > > File "/home/danto/webapps/web2py/web2py/gluon/dal.py", line 1218, in > > log_execute > > ret = self.cursor.execute(*a,**b) > > File > > "/home/danto/webapps/web2py/web2py/gluon/contrib/pymysql/cursors.py", line > > 108, in execute > > self.errorhandler(self, exc, value) > > File > > "/home/danto/webapps/web2py/web2py/gluon/contrib/pymysql/connections.py", > > line 184, in defaulterrorhandler > > raise errorclass, errorvalue > > gluon.contrib.pymysql.err.InternalError: (1054, u"Unknown column > > 'categoria.is_active' in 'field list'")
