Are you getting errors with both psycopg2 and pg8000? Are these errors new with 2.0.7?
On Thursday, 6 September 2012 09:09:42 UTC-5, Christian Espinoza wrote: > > The last one was with psycopg2, this is the last value of command using * > pg8000:* > > SELECT auth_group.id, auth_group.role, auth_group.description FROM > auth_group WHERE (auth_group.id > 0) ORDER BY auth_group.id LIMIT 1 > OFFSET 0; > > The failure appears when I try to init some values in a empty postgresql > database, with a empty sqlite db all works fine... > Im using if db(db.auth_group).isempty(): > To check if is empty to insert the firsts values... > > Christian. > > 2012/9/6 Christian Espinoza <[email protected] <javascript:>> > >> Massimo, >> >> SELECT auth_user.id, auth_user.username, auth_user.first_name, >> auth_user.last_name,\ >> auth_user.sede_id, auth_user.email, auth_user.estado, auth_user.password, >> auth_user.created_on, auth_user.modified_on, auth_user.registration_key,\ >> auth_user.reset_password_key, auth_user.registration_id FROM auth_user >> WHERE (auth_user.id > 0) ORDER BY auth_user.id LIMIT 1 OFFSET 0; >> >> INSERT INTO >> auth_user(username,first_name,last_name,registration_key,reset_password_key,registration_id,modified_on,created_on,sede_id,password,estado,email)\ >> VALUES ('11111111-1','admin','admin','','','','2012-09-06 >> 10:36:50','2012-09-06 >> 10:36:50',1,'admin','activo','[email protected]<javascript:> >> '); >> >> Thanks in advance >> Christian. >> >> 2012/9/6 Massimo Di Pierro <[email protected] <javascript:>> >> >>> Can you add a >>> >>> print command >>> >>> after >>> >>> command = a[0] >>> >>> I want to know what is the invalid command. The ticket only shows part >>> if it. >>> >>> On Wednesday, 5 September 2012 17:27:49 UTC-5, Christian Espinoza wrote: >>>> >>>> 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((comma**nd,time.time()-t0)) >>>> >>>> >>>> >>>> del self.db._timings[:-TIMINGSSIZE**] >>>> >>>> >>>> >>>> return ret >>>> >>>> Variables a('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>ret >>>> undefined self.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/**re**stricted.py", line 209, in >>>>>> restricted >>>>>> >>>>>> >>>>>> >>>>>> exec ccode in environment >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "/opt/web-apps/web2py-2.0.7/**ap**plications/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/**da**l.py", line 8722, in isempty >>>>>> >>>>>> >>>>>> >>>>>> return not self.select(limitby=(0,1)) >>>>>> >>>>>> >>>>>> >>>>>> File "/opt/web-apps/web2py/gluon/**da**l.py", line 8743, in select >>>>>> >>>>>> >>>>>> >>>>>> return adapter.select(self.query,fiel****ds,attributes) >>>>>> >>>>>> >>>>>> >>>>>> File "/opt/web-apps/web2py/gluon/**da**l.py", line 1583, in select >>>>>> >>>>>> >>>>>> >>>>>> return self._select_aux(sql,fields,at****tributes) >>>>>> >>>>>> >>>>>> >>>>>> File "/opt/web-apps/web2py/gluon/**da**l.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. >>>>>> >>>>>> -- >>>>> >>>>> >>>>> >>>>> >>>> >>>> -- >>> >>> >>> >>> >> >> > --
