PROBLEM SOLVED
[image: http://itjp.net.br] <http://itjp.net.br>
http://itjp.net.b <http://itjp.net.br>r
*Ovidio Marinho Falcao Neto*
[email protected]
Brasil
2018-02-28 8:02 GMT-03:00 Morganti <[email protected]>:
> Hi,
>
> The last command before the error in line 54 'for row in rows:' is a
> selection using 'iterselect'. I changed the 'iterselect' to 'select' and no
> more errors.
>
> Thanks Massimo, Ovidio and Daves.
>
> Best regards
> André
>
>
> Em terça-feira, 27 de fevereiro de 2018 12:29:16 UTC-3, Morganti escreveu:
>>
>> HI Massimo, I could import psycopg2 in web2py shell manually.
>>
>> I used the installation script inside web2py scripts folder. Bellow the
>> entire error:
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>> 12.
>> 13.
>> 14.
>> 15.
>> 16.
>> 17.
>> 18.
>> 19.
>> 20.
>> 21.
>> 22.
>>
>> Traceback (most recent call last):
>> File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in
>> restricted
>> exec(ccode, environment)
>> File
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py"
>> <https://nwcosmeticos.ml/admin/edit/nwproducao/controllers/carreira.py>,
>> line 812, in <module>
>> File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in
>> <lambda>
>> self._caller = lambda f: f()
>> File
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py"
>> <https://nwcosmeticos.ml/admin/edit/nwproducao/controllers/carreira.py>,
>> line 19, in gera_plano_carreira
>> vgraduacao = gera_graduacao()
>> File
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py"
>> <https://nwcosmeticos.ml/admin/edit/nwproducao/controllers/carreira.py>,
>> line 54, in gera_graduacao
>> for r in rows:
>> File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py",
>> line 3039, in __iter__
>> row = next(self)
>> File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py",
>> line 3014, in __next__
>> db_row = self.cursor.fetchone()
>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line
>> 947, in fetchone
>> return next(self)
>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line
>> 1032, in __next__
>> self._c.handle_messages(self)
>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line
>> 2088, in handle_messages
>> raise self.error
>> ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_11313" does
>> not exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'')
>>
>>
>> Thanks
>> Best regards
>> André
>>
>> Em domingo, 25 de fevereiro de 2018 21:02:54 UTC-3, Massimo Di Pierro
>> escreveu:
>>>
>>> If it finds psycopg2 it should be using it over pg8000. Is t possible
>>> you have two versions of python installed?
>>>
>>>
>>>
>>> On Sunday, 25 February 2018 04:46:57 UTC-6, Morganti wrote:
>>>>
>>>> Hi Massimo, thanks your answer.
>>>>
>>>> How can force web2py uses psycop2? I install pyscop2 using pip and made
>>>> a test importing it in normal python shell. But I got the same error when
>>>> tried to execute the same function:
>>>>
>>>> <class 'gluon.contrib.pg8000.core.ProgrammingError'>((u'ERROR',
>>>> u'34000', u'portal "pg8000_portal_294" does not exist', u'postgres.c',
>>>> u'1861', u'exec_execute_message', u'', u''))
>>>>
>>>> It is using pg8000 and not pyscop2.
>>>>
>>>> Thanks,
>>>> Best regards
>>>> André
>>>>
>>>> Em sábado, 24 de fevereiro de 2018 23:36:32 UTC-3, Massimo Di Pierro
>>>> escreveu:
>>>>>
>>>>> I know. It is there and we distribute it but we will remove it in the
>>>>> next version.
>>>>> I run into lots of problems with it, even with simple apps. psycopg2
>>>>> works instead.
>>>>>
>>>>>
>>>>> On Friday, 23 February 2018 04:57:41 UTC-6, Morganti wrote:
>>>>>>
>>>>>> Hi Dave,
>>>>>>
>>>>>> I found "pg8000" inside "gluon/contrib".
>>>>>>
>>>>>> In "gluon\packages\dal\pydal\adapters" I found the "postgres.py". So
>>>>>> is it wrong? Do I need to move pg8000 to "gluon\packages\dal\pydal\adap
>>>>>> ters"?
>>>>>>
>>>>>> You said about socket. I have no idea how to do it.
>>>>>>
>>>>>> Thanks a lot your support!
>>>>>> Best regards
>>>>>> Andre
>>>>>>
>>>>>> Em quinta-feira, 22 de fevereiro de 2018 18:30:17 UTC-3, Dave S
>>>>>> escreveu:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote:
>>>>>>>>
>>>>>>>> Hi, thanks your time.
>>>>>>>>
>>>>>>>> How can I check it? If I try to open web2py shell (web2py -S app
>>>>>>>> -M), I had no errors and all tables could be used.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> BR
>>>>>>>> André
>>>>>>>>
>>>>>>>>
>>>>>>> That's one way to check. The actual files should show up in the
>>>>>>> web2py/gluon/packages/dal/pydal/adapters, I think, and not just in
>>>>>>> gluon/contrib.
>>>>>>>
>>>>>>>
>>>>>>> But the error looks, to my inexpert eye, like a socket error. So I
>>>>>>> would start by verifying the socket exists and has the proper
>>>>>>> permissions.
>>>>>>>
>>>>>>> /dps
>>>>>>>
>>>>>>> Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio
>>>>>>>> Marinho escreveu:
>>>>>>>>>
>>>>>>>>> make sure the pg8000 and psycopg2 libraries are installed at the
>>>>>>>>> start of web2py
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> [image: http://itjp.net.br]
>>>>>>>>> <http://itjp.net.br>
>>>>>>>>> http://itjp.net.b <http://itjp.net.br>r
>>>>>>>>> *Ovidio Marinho Falcao Neto*
>>>>>>>>> [email protected]
>>>>>>>>> Brasil
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2018-02-22 12:40 GMT-03:00 Morganti <[email protected]>:
>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py
>>>>>>>>>> 2.16.1.
>>>>>>>>>>
>>>>>>>>>> I tried to execute one controller that populate some tables and
>>>>>>>>>> got the error below.
>>>>>>>>>>
>>>>>>>>>> Then, I used that command to create a csv file with all tables
>>>>>>>>>> and uploaded it in my desktop using SQLITE and no error were found.
>>>>>>>>>>
>>>>>>>>>> The controller coud create some rows before the error.
>>>>>>>>>>
>>>>>>>>>> Traceback (most recent call last):
>>>>>>>>>> File "/home/www-data/py27env/web2py/gluon/restricted.py", line
>>>>>>>>>> 219, in restricted
>>>>>>>>>> exec(ccode, environment)
>>>>>>>>>> File
>>>>>>>>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>>>>>>>> line 633, in <module>
>>>>>>>>>> File "/home/www-data/py27env/web2py/gluon/globals.py", line 419,
>>>>>>>>>> in <lambda>
>>>>>>>>>> self._caller = lambda f: f()
>>>>>>>>>> File
>>>>>>>>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>>>>>>>> line 21, in gera_plano_carreira
>>>>>>>>>> vgraduacao = gera_graduacao()
>>>>>>>>>> File
>>>>>>>>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>>>>>>>> line 56, in gera_graduacao
>>>>>>>>>> for r in rows:
>>>>>>>>>> File
>>>>>>>>>> "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py",
>>>>>>>>>> line 3039, in __iter__
>>>>>>>>>> row = next(self)
>>>>>>>>>> File
>>>>>>>>>> "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py",
>>>>>>>>>> line 3014, in __next__
>>>>>>>>>> db_row = self.cursor.fetchone()
>>>>>>>>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py",
>>>>>>>>>> line 947, in fetchone
>>>>>>>>>> return next(self)
>>>>>>>>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py",
>>>>>>>>>> line 1032, in __next__
>>>>>>>>>> self._c.handle_messages(self)
>>>>>>>>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py",
>>>>>>>>>> line 2088, in handle_messages
>>>>>>>>>> raise self.error
>>>>>>>>>> ProgrammingError: (u'ERROR', u'34000', u'portal
>>>>>>>>>> "pg8000_portal_13259" does not exist', u'postgres.c', u'1861',
>>>>>>>>>> u'exec_execute_message', u'', u'')
>>>>>>>>>>
>>>>>>>>>> *Thanks your helping.*
>>>>>>>>>>
>>>>>>>>>> *Best regards*
>>>>>>>>>>
>>>>>>>>>> *Andre*
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Resources:
>>>>>>>>>> - http://web2py.com
>>>>>>>>>> - http://web2py.com/book (Documentation)
>>>>>>>>>> - http://github.com/web2py/web2py (Source code)
>>>>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>>>>>>> ---
>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>> Google Groups "web2py-users" group.
>>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>>> send an email to [email protected].
>>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
