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*
>>                  ovid...@gmail.com
>>                             Brasil
>>              
>>
>> 2018-02-22 12:40 GMT-03:00 Morganti <acmor...@gmail.com>:
>>
>>> 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 web2py+un...@googlegroups.com.
>>> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to