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.
