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 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.
