Hi Massimo, this is:
*File /opt/web-apps/web2py/gluon/dal.py in log_execute at line 1653*
Code listing
1648.
1649.
1650.
1651.
1652.
1653.
1654.
1655.
1656.
1657.
command = a[0]
if self.db._debug:
logger.debug('SQL: %s' % command)
self.db._lastsql = command
t0 = time.time()
ret = self.cursor.execute(*a, **b)
self.db._timings.append((command,time.time()-t0))
del self.db._timings[:-TIMINGSSIZE]
return ret
Variablesa('SELECT auth_user.id, auth_user.username, auth_u...r.id > 0)
ORDER BY auth_user.id LIMIT 1 OFFSET 0;',)b{}self<gluon.dal.PostgreSQLAdapter
object>retundefinedself.cursor<gluon.contrib.pg8000.dbapi.CursorWrapper
object>self.cursor.execute<bound method CursorWrapper._fn of
<gluon.contrib.pg8000.dbapi.CursorWrapper object>>
2012/9/5 Massimo Di Pierro <[email protected]>
> Did you install psycopg2? If not it is probably using pg8000. Can you
> please help us debug? Edit dal.py and in the function log_excecute can you
> print the value of the command variable? What does it print when it fails?
>
> On Wednesday, 5 September 2012 11:29:42 UTC-5, Christian Espinoza wrote:
>>
>> Hello, I'm in trouble with a webapp that I'have.
>>
>> I develop it using sqlite only for a best approach of web2py features
>> with it.
>>
>> And I'm trying to migrate it to a Postgresql DB to put it on Testing
>> phase.
>>
>> But It doesn't work with PostgreSQL, only work with sqlite, I'd tried
>> with 1.99.7 - 2.0.6 - 2.0.7 Versions
>>
>> At 2.0.7 and 2.0.6 showme: <type 'exceptions.ValueError'> invalid
>> literal for int() with base 10: 'SELECT'
>>
>> At
>>
>> Traceback (most recent call last):
>> File "/opt/web-apps/web2py/gluon/**restricted.py", line 209, in restricted
>> exec ccode in environment
>> File "/opt/web-apps/web2py-2.0.7/**applications/sadma/models/db.**py"
>> <https://172.16.1.34/admin/default/edit/sadma/models/db.py>, line 236, in
>> <module>
>> if db(db.auth_user).isempty():
>> File "/opt/web-apps/web2py/gluon/**dal.py", line 8722, in isempty
>> return not self.select(limitby=(0,1))
>> File "/opt/web-apps/web2py/gluon/**dal.py", line 8743, in select
>> return adapter.select(self.query,fiel**ds,attributes)
>> File "/opt/web-apps/web2py/gluon/**dal.py", line 1583, in select
>> return self._select_aux(sql,fields,at**tributes)
>> File "/opt/web-apps/web2py/gluon/**dal.py", line 1556, in _select_aux
>> self.execute(sql)
>>
>> My Connection string:
>>
>> * #db = DAL('sqlite://storage.sqlite')
>> db = DAL('postgres://user:pass@localhost/dbapp')**
>> *
>>
>> *Running on Centos 6.0, external Postgresql Server with 9 version, **Python
>> 2.6.6*
>>
>> *
>> *
>>
>> Thanks in advance
>>
>> Christian.
>>
>> --
>
>
>
>
--
