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é 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 <javascript:> > Brasil > > > 2018-02-22 12:40 GMT-03:00 Morganti <acmor...@gmail.com <javascript:>>: > >> 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 <javascript:>. >> 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.