Traceback (most recent call last):
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/applications/my_app/controllers/appadmin.py",
line 238, in select
nrows = db(query).count()
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/gluon/packages/dal/pydal/objects.py",
line 1992, in count
return db._adapter.count(self.query,distinct)
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1311, in count
self.execute(self._count(query, distinct))
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/gluon/packages/dal/pydal/adapters/postgres.py",
line 360, in execute
return BaseAdapter.execute(self, *a, **b)
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1378, in execute
return self.log_execute(*a, **b)
File
"/home/tasko/webapps/w2p_2_12_3_prod/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1372, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
ProgrammingError: relation "cavities" does not exist
LINE 1: SELECT count(*) FROM "cavities" WHERE ("cavities"."id" > 0);
Il giorno lunedì 14 settembre 2015 14:24:11 UTC+2, Ovidio Marinho ha
scritto:
>
> show full tickets error
>
>
>
>
>
> [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
>
>
> 2015-09-14 9:06 GMT-03:00 Gael Princivalle <gaelpri...@gmail.com
> <javascript:>>:
>
>> Thanks Ovidio but the error still here also with migrate=False.
>>
>> ProgrammingError: relation "cavities" does not exist
>> LINE 1: SELECT count(*) FROM "cavities" WHERE ("cavities"."id" > 0);
>>
>>
>> Il giorno lunedì 14 settembre 2015 14:04:01 UTC+2, Ovidio Marinho ha
>> scritto:
>>>
>>> Use migrate=False or not use migrate in string of connection.
>>>
>>>
>>>
>>>
>>>
>>> [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
>>>
>>>
>>> 2015-09-14 7:56 GMT-03:00 Gael Princivalle <gaelpri...@gmail.com>:
>>>
>>>> Hello.
>>>>
>>>> I've already read about this message error anyway I don't reach to find
>>>> the solution.
>>>>
>>>> Here here my db string:
>>>>
>>>> db = DAL('postgres://user:pass@localhost:5432/my_db',
>>>> check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
>>>> migrate=True)
>>>>
>>>>
>>>> In db.py I've add some tables with relations, and cancel these tables.
>>>>
>>>>
>>>> When I try to add again a table called "cavities" that is in reference in
>>>> a table called "model_c" (same names as the first time I've add these
>>>> tables), when I try to see the empty table in the administration database
>>>> I've this error:
>>>>
>>>> relation "cavities" does not exist
>>>> LINE 1: SELECT count(*) FROM "cavities" WHERE ("cavities"."id" > 0);
>>>>
>>>>
>>>> The table:
>>>>
>>>> db.define_table('cavities',
>>>> Field('name', type='string', requires=IS_NOT_EMPTY()),
>>>> format='%(name)s')
>>>>
>>>>
>>>> I've tried to add migrate=True to the connection string, I've cancel
>>>> manually all old tables in the db, I've add the app in a totally new
>>>> web2py application, and cancel also all the database app folder.
>>>>
>>>> Always the same error.
>>>>
>>>>
>>>> Someone can give me a help?
>>>>
>>>>
>>>> Thanks.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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+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.
