I will send a screen shot when i get a chance. Thanks for all the help.
On Feb 23, 9:16 am, Anthony <abasta...@gmail.com> wrote: > Can you send a screenshot of the page that is asking you for the user ID? > Also, can you post the code from your model file where auth is defined? More > details will help. > > On Wednesday, February 23, 2011 9:08:32 AM UTC-5, stargate wrote: > > It was asking me for the user generated ID > > > On Feb 23, 8:21 am, Anthony <abas...@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 > >
