The DAL uses the sql dialect to communicate with the database from
this folder . As yet there are no data you can delete these archive
that will be generated again thus entering the application admin . In
case there in question there is no data in the database then you can
delete if you have data then make a copy of the donated a backup , do
the necessary maintenance and return .
[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
2015-09-14 10:42 GMT-03:00 Anthony <[email protected]>:
> What happens if you delete the relevant *.table files in the /databases
> folder and then turn on migrations? Does the table not get created for you?
>
>
> On Monday, September 14, 2015 at 9:19:07 AM UTC-4, Gael Princivalle wrote:
>>
>> Using phpPgAdmin I can see that the table in question does not exist.
>> I've delete it.
>>
>> Il giorno lunedì 14 settembre 2015 15:11:05 UTC+2, Anthony ha scritto:
>>>
>>> Using external tools, can you confirm whether the table in question
>>> actually does exist in the database?
>>>
>>> On Monday, September 14, 2015 at 6:56:54 AM UTC-4, Gael Princivalle
>>> wrote:
>>>>
>>>> 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 [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.
