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,fields,attributes)
File "/opt/web-apps/web2py/gluon/dal.py", line 1583, in select
return self._select_aux(sql,fields,attributes)
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.
--
