it's one of the two: either migrations are turned off, or are turned on and you have .table files in the databases/ folder (that tell web2py "hey, tables are already there!")
On Monday, September 5, 2016 at 11:04:42 PM UTC+2, Morganti wrote: > > Hi, > > I checked an the migrations are enabled! I dont know where is the problem. > I checked to try to create the tables directly in postgresql and it is > running normal. But, using web2py... > > Thanks > > Em segunda-feira, 5 de setembro de 2016 13:11:04 UTC-3, Niphlod escreveu: >> >> 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.
