it is the same as for define_table() it applies to all tables created by define_tables()
On Jul 3, 4:59 pm, Mico Siahaan <mico.siah...@gmail.com> wrote: > Massimo, thanks it solved. Actually what is 'migrate' parameter > purpose in define_tables function? > > regards, > > > > On Fri, Jul 3, 2009 at 8:49 PM, mdipierro<mdipie...@cs.depaul.edu> wrote: > > > Haha! > > >> Then using phpmyadmin I create user, and create database happo. > > > but you did not set > > > auth.define_tables(migrate=False) > > > So I am not sure what happened. You tests may have messed up various > > things. > > > What to do? > > 1) delete database happo > > 2) delete everything in databases/ folder > > 3) recreate happo and give the use permission to create/alter tables > > 4) use auth.define_table(migrate="happo") > > 5) start you app again > > > On Jul 3, 2:45 am, Mico Siahaan <mico.siah...@gmail.com> wrote: > >> Hi Yarko, > > >> I will try as details as I could :). > >> 1. This is my first try with web2py, basically I just want to make > >> sample app. It will be a website that member can login and update his > >> status so other member can know the update > >> 2. For development, I am using win vista business and xampp for > >> windows (it has apache and mysql) > >> 3. So from xampp control panel I start mysql > >> 4. Then using phpmyadmin I create user, and create database happo. > >> Give permission for that user to create and modify all tables in happo > >> database > >> 5. Then I start web2py > >> 6. Create new application > >> 7. Edit db.py. I uncommented lines of auth settings. > >> 8. After that I access index method of appadmin.py controller. > >> 9. Got error tickets > > >> File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py", line 166, in > >> execute > >> self.errorhandler(self, exc, value) > >> File "C:\Python25\Lib\site-packages\MySQLdb\connections.py", line > >> 35, in defaulterrorhandler > >> raise errorclass, errorvalue > >> ProgrammingError: (1146, "Table 'happo.auth_user' doesn't exist") > > >> while my db.py (full, as requested by massimo) > > >> if request.env.web2py_runtime_gae: # if running on Google App Engine > >> from gluon.contrib.gql import * > >> ### connect to Google BigTable > >> db = GQLDB() > >> ## and store sessions and tickets there > >> session.connect(request, response, db=db) > >> ### or use the following lines to store sessions in Memcache > >> # from gluon.contrib.memdb import MEMDB > >> # from google.appengine.api.memcache import Client > >> # session.connect(request, response, db=MEMDB(Client())) > >> else: # else use a normal relational database > >> # if not, use SQLite or other DB > >> #db = SQLDB('sqlite://storage.sqlite') > >> db = SQLDB('mysql://my_user:my_pas...@localhost/happo', pool_size=0) > > >> from gluon.tools import * > >> auth=Auth(globals(),db) # authentication/authorization > >> auth.define_tables() # creates all needed tables > >> crud=Crud(globals(),db) # for CRUD helpers using auth > >> service=Service(globals()) # for json, xml, jsonrpc, xmlrpc, amfrpc > > >> ## uncomment as necessary or consult docs for more options > >> crud.settings.auth=auth # (optional) enforces authorization on > >> crud > >> mail=Mail() # mailer > >> mail.settings.server='smtp.gmail.com:587' # your SMTP server > >> mail.settings.sender='mico.siah...@gmail.com' # your email > >> mail.settings.login='mico.siahaan:gmaipass' # your credentials > >> auth.settings.mailer=mail # for user email verification > >> auth.settings.registration_requires_verification = False > >> auth.settings.registration_requires_approval = True > >> auth.messages.verify_email = \ > >> 'Click on the > >> linkhttp://127.0.0.1:8000/customer/default/user/verify_email/%(key)sto > >> verify your email' > > >> so basically I have not done much :) > >> -- > > -- > Mico Siahaan > --- > Email: mico.siah...@gmail.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---