Hello Mate,
Using latest trunk Version 1.57
Here is the model:
.....
db =SQLDB('mysql://userName:p...@localhost:3306/dbname')
class MyAuth(Auth):
def __init__(self, environment, T, db= None):
.....
.....
auth = MyAuth(globals(), T,db)
auth.define_tables()
....
Here is the controller:
auth.settings.on_failed_authorization=URL(r=request,f='error')
auth.settings.login_url=URL(r=request,f='login')
auth.messages.invalid_login= 'Very Very Bad Login'
auth.messages.logged_in = 'Perfect'
def register():
return dict(form=auth.register(next="login"))
def login():
return dict(form=auth.login(next="profile"))
And now I'm trying to access the application through the register
page: (http://127.0.0.1:8000/AppName/default/register)
Here is the error (with Mysql) which WORK FINE with SQLITE but
complaint with MYSQL on tool.py:
--------------------------------------------------------------------------------------------------------
Error traceback:
Traceback (most recent call last):
File "/opt/web2py/gluon/restricted.py", line 98, in restricted
exec ccode in environment
File "/opt/web2py/applications/webFunc2/controllers/default.py",
line 27, in <module>
File "/opt/web2py/gluon/globals.py", line 75, in <lambda>
self._caller = lambda f: f()
File "/opt/web2py/applications/webFunc2/controllers/default.py",
line 8, in register
return dict(form=auth.register(next="login"))
File "/opt/web2py/gluon/tools.py", line 649, in register
group_id = self.add_group("user_%s" % form.vars.id, description)
File "/opt/web2py/gluon/tools.py", line 1058, in add_group
self.log_event(log % dict(group_id=group_id, role=role))
File "/opt/web2py/gluon/tools.py", line 508, in log_event
origin=origin, user_id=user_id)
File "/opt/web2py/gluon/sql.py", line 1305, in insert
self._db._execute(query)
File "/opt/web2py/gluon/sql.py", line 633, in <lambda>
**b)
File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line
166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1048, "Column 'user_id' cannot be null")
--------------------------------------------------------------------------------------------------------
Please let me know If you have any information... I don't really
understand why the user_id is null using MySQL and not the case using
SQLITE.
Thanks for your help,
Yannick P.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
