appadmin shows the tables you DEFINED in the model. If there aren't real table on the backend to "sustain" those models, you get the error. You need to let web2py create the tables in your fresh database (enable migrations, hit appadmin at least once, then disable migrations for production use).
On Monday, September 5, 2016 at 12:17:18 PM UTC+2, Morganti wrote: > > Hi! > > In appadmin the tables are there but, checking in pgadmin3 them aren´t > there. Looks like they were not being created. But, the database is created > and I am able to create tables directly in pgadmin even prompt from ubuntu. > > I reinstall everything and got the problem again. > > Thank you very much! > BR > > > Em segunda-feira, 5 de setembro de 2016 04:33:49 UTC-3, Niphlod escreveu: >> >> seemingly no response was given to a simple "how many records are there". >> sure the tables have been created ? >> >> On Sunday, September 4, 2016 at 3:55:54 PM UTC+2, Morganti wrote: >>> >>> Hi people! >>> >>> I just almost in go-live. So, I tried to create a Postgresql database >>> and starting to configure some config tables for my appliacation, but I had >>> the error below. >>> >>> Traceback (most recent call last): >>> File >>> "/home/andre/Dropbox/Projetos/web2py/applications/87k/controllers/appadmin.py", >>> line 249, in select >>> nrows = db(query, ignore_common_filters=True).count() >>> File >>> "/home/andre/Dropbox/Projetos/web2py/gluon/packages/dal/pydal/objects.py", >>> line 2010, in count >>> return db._adapter.count(self.query, distinct) >>> File >>> "/home/andre/Dropbox/Projetos/web2py/gluon/packages/dal/pydal/adapters/base.py", >>> line 1322, in count >>> return self.cursor.fetchone()[0] >>> IndexError: list index out of range >>> >>> Thanks >>> Best regards >>> André >>> >>> >>> -- 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.
