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