Update: It started working as soon as I installed psycopg2.
This is pg8000 issue.
I am using psql 8.4.11
--
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
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 auth_grou
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 postg
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,
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
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
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
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:
>
>
9 matches
Mail list logo