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]
> 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]> 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]> 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).:_______
--
