Thank you for brining this us and insisting, otherwise this mistake would
not have been fixed. ;-)
On Monday, 3 September 2012 17:01:24 UTC-5, Carlos Correia wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Thanks!
>
> Everything is working fine again :D
>
> Em 03-09-2012 22:15, Massimo Di Pierro escreveu:
> > You are right. It was a mistake to remove it. It is now back and no more
> fetch.
> > Please check it again.
> >
> > On Monday, 3 September 2012 16:02:49 UTC-5, Carlos Correia wrote:
> >
> > Hi,
> >
> > It fixed the issue, indeed.
> >
> > So I assume I'll have to review all the executesql's calls in order to
> add the
> > fetch parameter to the ones that need it, which, in this case won't be a
> simple
> > task :(
> >
> > What was the problem with the try/except block? Can't see one (at least,
> not a
> > PostgreSQL related one)... in which case, perhaps it would be possible
> to put
> > the try/except block inside the adapter or somehow test the kind of
> adapter in
> > use...
> >
> > Thanks
> >
> > Em 03-09-2012 20:17, Massimo Di Pierro escreveu:
> >> we did remove a try... except in there that would have caused more
> problems.
> >
> >> Check out latest trunk and try:
> >
> >> db.executesql('truncate auth_event',fetch=False)
> >
> >> else it expect the query to return something.
> >
> >> On Monday, 3 September 2012 14:01:57 UTC-5, Carlos Correia wrote:
> >
> >> Hi,
> >
> >> After updating to trunk (Version 2.0.6 (2012-09-03 10:18:10) stable), I
> > started
> >> getting the following error in executesql():
> >
> >> In [1]: db.executesql( 'truncate auth_event' )
> >>
> ---------------------------------------------------------------------------
> >> ProgrammingError Traceback (most recent call
> last)
> >
> >
> /home/carlos/development/m16e/apps/web/web2py/clusters/m16e/src/applications/belmiro/models/menu.py
>
>
> >
> >
> >> in <module>()
> >> ----> 1 db.executesql( 'truncate auth_event' )
> >
> >
> >
> /home/carlos/development/m16e/apps/web/web2py/clusters/m16e/src/gluon/dal.pyc
> in
> >
> >
> >> executesql(self, query, placeholders, as_dict, fields, colnames)
> >> 7247 # easier to work with. row['field_name'] rather
> than
> > row[0]
> >
> >> 7248 return [dict(zip(fields,row)) for row in data]
> >> -> 7249 data = adapter.cursor.fetchall()
> >> 7250 if fields or colnames:
> >> 7251 fields = [] if fields is None else fields
> >
> >> ProgrammingError: no results to fetch
> >
> >> Before the upgrade, I was using Version 2.00.0 (2012-08-03 09:01:00)
> dev
> >
> >> Thanks,
> >
> >> --
> >
> >
> >
> >
> >
> > --
> >
> >
> >
>
> - --
> Com os melhores cumprimentos,
>
> Carlos Correia
> =========================
> MEMÓRIA PERSISTENTE, Lda.
> Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762
> e-mail: ge...@memoriapersistente.pt <javascript:> - URL:
> http://www.memoriapersistente.pt
> Jabber: m1...@jabber.org <javascript:>
> GnuPG: wwwkeys.eu.pgp.net
> URL Suporte (experimental): https://ky.m16e.com (certificado
> auto-assinado)
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://www.enigmail.net/
>
> iEYEARECAAYFAlBFKK0ACgkQ90uzwjA1SJXWNwCggJOTV26mUny9MhznbcPsLJ7F
> HugAoJ3y5gIq9463YYFWdVuFGoI8ph/Q
> =fZDj
> -----END PGP SIGNATURE-----
>
--
