Did you previously define that column with notnull=True? If so, you may need to alter that column directly in MySQL so it allows null values.
Anthony On Monday, March 4, 2013 11:41:05 AM UTC-5, Anthony Bond wrote: > > I've fixed the issue with the variable names by prefixing a letter to the > variable. However, the insert still does not function. Here's the error: > > 127.0.0.1.2013-03-04.11-38-23.96eaf75d-0524-4eb8-8848-6000d1993dcd > <class 'gluon.contrib.pymysql.err.InternalError'> (1048, u"Column 'Q4_3A' > cannot be null") > > Traceback (most recent call last): > File "gluon/restricted.py", line 212, in restricted > File > "C:/Users/abond2/Desktop/web2py/web2py/web2py/applications/Teacher_Evaluation_System/controllers/evaluation.py" > > <http://127.0.0.1:8000/admin/default/edit/Teacher_Evaluation_System/controllers/evaluation.py>, > line 84, in <module> > File "gluon/globals.py", line 193, in <lambda> > File "gluon/tools.py", line 2929, in f > File > "C:/Users/abond2/Desktop/web2py/web2py/web2py/applications/Teacher_Evaluation_System/controllers/evaluation.py" > > <http://127.0.0.1:8000/admin/default/edit/Teacher_Evaluation_System/controllers/evaluation.py>, > line 28, in Take_Eval > File "gluon/dal.py", line 7918, in insert > File "gluon/dal.py", line 1176, in insert > InternalError: (1048, u"Column 'Q4_3A' cannot be null") > > > line 28, in Take_Eval refers to the insert method. Just a thought - do I > need to append something extra to "form.vars.Q4_3A" to get the value of that > particular drop down list? > > > On Sunday, March 3, 2013 2:34:29 PM UTC-5, Alan Etkin wrote: >> >> > My attempts at resolving this issue have made the implementation of the >> form much simpler, but I'm still unable to get the code to >> > compile after I put the insert in. I would appreciate and assistance >> you could provide in enlightening me as to why that insert >> > statement would not compile. >> >> Could you post the relevant part of the error ticket? >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
