This is not a 2.3.2 bug. This is a bug in a previous version in the appadmin.html file. Your app was probably created with a previous web2py version. copy the latest appadmin.py and appadmin.html from the new welcome into loja and your problem should go away.
On Tuesday, 18 December 2012 15:57:21 UTC-6, Tito Garrido wrote: > > I guess I have found a bug on 2.3.2 when I try to use database admin > queries: > Ticket ID > > 127.0.0.1.2012-12-18.18-56-07.412e0e88-61e7-472c-9e46-c8d1220cba9f > <type 'exceptions.NameError'> name 'tb' is not defined Version web2py™ (2, > 3, 2, datetime.datetime(2012, 12, 17, 15, 3, 30), 'stable') Python Python > 2.6.6: /usr/bin/python Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > > Traceback (most recent call last): > File "/home/titog/Documents/Projetos/web2py/gluon/restricted.py", line 212, > in restricted > > > exec ccode in environment > File > "/home/titog/Documents/Projetos/web2py/applications/loja/views/appadmin.html" > <http://127.0.0.1:8000/admin/default/edit/loja/views/appadmin.html>, line > 133, in <module> > > > <p> > NameError: name 'tb' is not defined > > > > > On Tue, Dec 18, 2012 at 4:18 PM, Richard Vézina > <[email protected]<javascript:> > > wrote: > >> Forget that, I was pointing database on my dev machine postgres server, >> for some reason, it was not working. I copy the db into local postgres >> database and point on the same server instead of my old dev VM and it gone >> away. Maybe issue with different version of software between Ubuntu 10.04 >> and 12.10. I don't know. >> >> Thanks >> >> Richard >> >> >> On Tue, Dec 18, 2012 at 12:21 PM, Richard Vézina >> <[email protected]<javascript:> >> > wrote: >> >>> Ok, thanks >>> >>> It must be my server... It seems to work fine with my dev machine. >>> >>> Richard >>> >>> >>> On Tue, Dec 18, 2012 at 12:05 PM, Massimo Di Pierro < >>> [email protected] <javascript:>> wrote: >>> >>>> Are other people having problems with psycopg2 and web2py 2.3.2? >>>> Nothing should have changed in this respect. psycopg2 if available takes >>>> precendence over pg8000 which has problems. >>>> >>>> Massimo >>>> >>>> >>>> On Tuesday, 18 December 2012 10:46:16 UTC-6, Richard wrote: >>>> >>>>> Is there something different with psycopg2 under web2py 2.3.2 ? >>>>> >>>>> I get this error on a new server that I configure : >>>>> >>>>> <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times: >>>>> Traceback (most recent call last): File "/home/www-data/web2py/gluon/* >>>>> *dal.py", line 6853, in __init__ self._adapter = >>>>> ADAPTERS[self._dbname](****kwargs) File "/home/www-data/web2py/gluon/* >>>>> *dal.py", line 2493, in __init__ if do_connect: >>>>> self.find_driver(adapter_args,**uri) File >>>>> "/home/www-data/web2py/gluon/**dal.py", line 704, in find_driver >>>>> raise RuntimeError("driver %s not available" % request_driver) >>>>> RuntimeError: driver psycopg2 not available >>>>> >>>>> python-psycopg2 is installed >>>>> >>>>> For some reason I had to add apdater to my connection string like this >>>>> : >>>>> >>>>> db=DAL('postgres:psycopg2:...) >>>>> >>>>> Because if I didn't not precise it, web2py seems to use pg8000 and I >>>>> get this error with pg8000 : >>>>> >>>>> <type 'exceptions.ValueError'> invalid literal for int() with base 10: >>>>> 'SELECT' >>>>> >>>>> Traceback (most recent call last): >>>>> File "/home/www-data/web2py/gluon/**restricted.py", line 212, in >>>>> restricted >>>>> exec ccode in environment >>>>> File "/home/www-data/web2py/**applications/sgddms/models/**dict.py", >>>>> line 121, in <module> >>>>> for r in db().select(db.dict_database.**table_name, >>>>> db.dict_database.column_name, db.dict_database.column_name_**en_ui)]) >>>>> File "/home/www-data/web2py/gluon/**dal.py", line 8905, in select >>>>> return adapter.select(self.query,**fields,attributes) >>>>> File "/home/www-data/web2py/gluon/**dal.py", line 1631, in select >>>>> return self._select_aux(sql,fields,**attributes) >>>>> File "/home/www-data/web2py/gluon/**dal.py", line 1597, in >>>>> _select_aux >>>>> rows = self._fetchall() >>>>> File "/home/www-data/web2py/gluon/**dal.py", line 1590, in _fetchall >>>>> return self.cursor.fetchall() >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/dbapi.py", line >>>>> 246, in _fn >>>>> return fn(self, *args, **kwargs) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/dbapi.py", line >>>>> 414, in fetchall >>>>> return tuple(self.cursor.iterate_**tuple()) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/interface.py", >>>>> line 76, in next >>>>> retval = self.func(self.obj) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/interface.py", >>>>> line 270, in read_tuple >>>>> return self._fetch() >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/interface.py", >>>>> line 205, in _fetch >>>>> self._fill_cache() >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/interface.py", >>>>> line 190, in _fill_cache >>>>> end_of_data, rows = self.c.fetch_rows(self._**portal_name, >>>>> self.row_cache_size, self._row_desc) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/protocol.py", >>>>> line 943, in _fn >>>>> return fn(self, *args, **kwargs) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/protocol.py", >>>>> line 1249, in fetch_rows >>>>> retval = reader.handle_messages() >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/protocol.py", >>>>> line 906, in handle_messages >>>>> msg = self._conn._read_message() >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/protocol.py", >>>>> line 1038, in _read_message >>>>> msg = message_types[message_code].**createFromData(bytes) >>>>> File "/home/www-data/web2py/gluon/**contrib/pg8000/protocol.py", >>>>> line 783, in createFromData >>>>> args['rows'] = int(values[-1]) >>>>> ValueError: invalid literal for int() with base 10: 'SELECT' >>>>> >>>>> >>>>> I never really use pg8000, because it didn't works for me, maybe >>>>> because of my app code or issue with pg8000 in web2py, but I am more >>>>> inclined in the former (my app code). >>>>> >>>>> >>>>> I use ubuntu 12.10 and a custom Nginx installation with uwsgi emperor >>>>> mode. >>>>> >>>>> Could it be only because web2py is missing a dependance? >>>>> >>>>> Thanks >>>>> >>>>> Richard >>>>> >>>>> >>>>> On Tue, Dec 18, 2012 at 5:23 AM, Niphlod <[email protected]> wrote: >>>>> >>>>>> totally unrelated.... epydoc folder in examples/static is 22mb. >>>>>> Leaving that one out and artwork.tar.gz (that seems to be a compressed >>>>>> version of examples/static/images) takes the compressed binary down to >>>>>> ~10 >>>>>> MB compressed/25MB uncompressed. >>>>>> Maybe a little cleanup in the next release will save everyone a few >>>>>> MB ? >>>>>> >>>>>> >>>>>> On Tuesday, December 18, 2012 9:20:54 AM UTC+1, apps in tables wrote: >>>>>>> >>>>>>> sorry, both are 45 mb after unzipping, (examples application 25 mb). >>>>>>> >>>>>>> On Tuesday, December 18, 2012 7:34:22 AM UTC+3, Massimo Di Pierro >>>>>>> wrote: >>>>>>>> >>>>>>>> Are you sure about this? I cannot explain it. What's in the extra >>>>>>>> +30MB? >>>>>>>> >>>>>>>> On Monday, 17 December 2012 21:27:44 UTC-6, apps in tables wrote: >>>>>>>>> >>>>>>>>> >>>>>>>>> another advantage: >>>>>>>>> >>>>>>>>> 2.3.1 is 45 mb >>>>>>>>> 2.3.2 is 15 mb >>>>>>>>> >>>>>>>>> smaller is nicer...:) >>>>>>>>> >>>>>>>>> >>>>>>>>> On Monday, December 17, 2012 6:11:19 PM UTC+3, Massimo Di Pierro >>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> It is the same as 2.3.2 but fixed a major bug with NEWINSTALL >>>>>>>>>> being ignored and therefore not creating the welcome.w2p for the new >>>>>>>>>> scaffolding app. >>>>>>>>>> >>>>>>>>>> If you are using 2.3.1 you may still be using an older welcome >>>>>>>>>> instead of the cool new one. Upgrade to 2.3.2 to fix this. >>>>>>>>>> >>>>>>>>>> Massimo >>>>>>>>>> >>>>>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>> >>>> >>>> >>>> >>> >>> >> -- >> >> >> >> > > > > -- > > Linux User #387870 > .........____ > .... _/_õ|__| > ..º[ .-.___.-._| . . . . > .__( o)__( o).:_______ > --
