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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.