Update: It started working as soon as I installed psycopg2.
This is pg8000 issue.
I am using psql 8.4.11
--
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
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,
So, what is wrong with those SQL? I think web2py is generating the correct
ones. What am I missing?
On Sep 6, 2012, at 8:40 AM, Christian Espinoza wrote:
Massimo,
SELECT auth_user.id, auth_user.username, auth_user.first_name,
auth_user.last_name,\
auth_user.sede_id, auth_user.email,
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
Again… what is wrong with the generated SQL? I do not know how to fix it if I
do not understand why postgres is complaining.
Massimo
On Sep 6, 2012, at 9:09 AM, Christian Espinoza wrote:
The last one was with psycopg2, this is the last value of command using
pg8000:
SELECT
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,
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:
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
9 matches
Mail list logo