On Wednesday, February 23, 2011 7:11:08 AM UTC-5, stargate wrote: > > Yes but I click on the database administration within the new > application I have created. The database is connected to a mySQL > server. The issue is when i create a new table in the mySQL server it > doesn't show up under the Available databases and tables. So how do i > correct this.
Are you saying you have added a new table to the database outside of web2py? If so, web2py won't know about it unless you create a model (i.e., using db.define_table) in your models file. Instead, you can create the web2py model first, and then web2py will create the table for you. > > Also when I add a new user > > here > http://127.0.0.1:8000/in2cu/appadmin/insert/db/auth_user > > I fill everything out but it asks me for a userID but this should be > generated automatically Are you saying it's asking you for the auto generated record ID for the new user -- that shouldn't be the case? Or is it asking you for a "username"? By default, Auth uses the email address as the username for login. However, if you use auth.define_tables(username=True), it will add a "username" field to the user table -- perhaps that is what you are seeing (if there's an actual "userID" field, perhaps that was added as a custom field). Anthony
