Using the wiki as an example was a bit stupid.
This happens to all my tables with a foreign key.
The tables exist, but it happens when i add a field.
As I understand fake_migrate it regenerates the meta data in databases.
So if I first fake_migrate on the database that is exactly the same as my
models.
I expect turning on migrate to true to do nothing after the fake migrate.
But it throws the error for every single table that have a foreign key.
I have tried to empty the databases directory before the fake_migrate, but
I'm still stuck.
It still works on my production server. Copying to local with nothing
changed throws the error as soon as I turn on migrate. (Also after fake
migrate)
I also downloaded and renamed the databases files from the server, to see
if that would work.
Thinking about it now, I have not fully deleted and recreate the entire
local/develop pg_database / before import. Will try that next.
Tom Ø.
kl. 10:29:14 UTC+1 mandag 1. desember 2014 skrev Paolo Valleri følgende:
>
> Hi Tom,
> wiki's tables are not present.
> You have to include them during the migration, probably you have defined
> the wiki object in a controller?
>
> Paolo
>
> On Saturday, November 29, 2014 6:22:00 PM UTC+1, Tom Øyvind Hogstad wrote:
>>
>> My migrations suddenly failed with
>> Error:
>> <class 'gluon.contrib.pg8000.errors.ProgrammingError'> ('ERROR',
>> '42P01', 'relation "wiki_page" does not exist')
>>
>> This will happen for any relation trying to commenting them out etc.
>>
>> Running a fake_migrate_all and the problem still persists, so I can not
>> find a way around manually modify my PostgreSQL schema at the moment.
>>
>> Any suggestions?
>>
>> Web2Py: 2.9.11
>> PostrgeSQL: 9.3
>>
>> Tom Ø.
>>
>>
>>
>>
>>
>>
>>
>>
>>
--
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.
