It was asking me for the user generated ID
On Feb 23, 8:21 am, Anthony <abasta...@gmail.com> wrote: > 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