I used extract_mysql_models.py to create the models since I couldn't see them when I typed db.tables. After putting the defined models in db.py I could then see the models.
I've tried troubleshooting with enable_migrate_all and migrate=True, but the register screen just stays blank for me. I'm also not sure how it is suppose to help me troubleshoot. I would like for the database to be able to overwrite any fields I have in there now and fix itself if possible. I thought that is what the migrate=True setting would do, but I must be wrong. On Fri, Feb 7, 2014 at 9:46 PM, LightDot <light...@gmail.com> wrote: > Looks like web2py thinks that your main database structure is different than > it really is. With other words, database migrations are broken for your app. > That's why auth works if you start with a fresh database and doesn't if you > use the existing one. > > Since you've been replacing one database with another (to test auth, etc.), > how did you handle database migrations in web2py? Migrations are described > here: > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Migrations > > What I would do: > > 1) if there was important data in the main database: check the differences > between the database definitions and your current main database structure, > sort that out using fake migrations (refer to Fixing broken migrations > chapter in the book) > > 2) if there was no need to keep the old data from the main database: > a) drop all tables from the main database > b) delete all files from the applications/yourapp/databases folder (assuming > there are no sqlite databases in there that you still need) > > Regards > > > > On Friday, February 7, 2014 10:07:15 PM UTC+1, Austin Taylor wrote: >> >> Thanks, Massimo. Whenever I click register I get some new unknown column >> 'modified_by' in the field list (error 1054). >> >> I have tried manually adding each field whenever I get new errors, but I'm >> tired of it and just want to start over. >> >> I restored the views and controller to the default, but still get errors. >> When I create a new app and just use SQLite instead of mysql the register >> function works great. It also works well when I use it with another database >> in MYSql, but if I use it with my main database I run into issues. >> >> On Friday, February 7, 2014 1:50:54 PM UTC-5, Massimo Di Pierro wrote: >>> >>> Hard to help you without seeing the cod or the error tickets. There >>> should be no difference between auth in sqlite or mysql. You should not save >>> auth info a different database else you lose the ability to join the >>> auth_user table with other tables and that is often an important >>> requirement. >>> >>> On Thursday, 6 February 2014 06:38:26 UTC-6, Austin Taylor wrote: >>>> >>>> I've tried creating another app and authentication works fine there with >>>> the sqlite database, but when I try to use my mysql instance I run into >>>> error after error. >>>> >>>> Right now I have Login, Forgot Username and Lost Password when I hover >>>> over the login button. I don't know how to get it back to the default of >>>> just register/lost password/login. >>>> >>>> I have no idea where the code could be that messed up my registration. >>>> It was initially working but I tried creating another registration script >>>> that seems to have messed everything up. >>>> >>>> I tried removing the script and creating a new app and cloning the >>>> models/controllers but the old registration form which request a username >>>> still pops up. >>>> >>>> Any help would be greatly appreciated!! > > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/BfmiTOOM0o4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. -- 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/groups/opt_out.
