Did some other testing and found simular error on this controler:
def add_relatie():
adres = db.executesql('SELECT adressen.relatie_nummer, " | ",
adressen.relatie_code, " | ", adressen.relatie_naam FROM adressen left join
edirelaties on adressen.relatie_nummer = edirelaties.relatie_nummer WHERE
edirelaties.relatie_nummer is null;')
form = SQLFORM.factory(
Field('relatie_nummer', requires=IS_IN_SET([a[0] for a in adres],labels
=[a for a in adres])),
Field('login_naam', requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,
'edirelaties.login_naam'),IS_ALPHANUMERIC(error_message='must be
alphanumeric!')]),
Field('password', requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,
'edirelaties.password'),IS_ALPHANUMERIC(error_message='must be
alphanumeric!')]),
Field('work_directory', requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,
'edirelaties.work_directory'),IS_ALPHANUMERIC(error_message='must be
alphanumeric!')]))
if form.process().accepted:
db.edirelaties.insert(**form.vars)
response.flash = 'Your new edirelatie has been added'
redirect(URL('show', args=form.vars.id))
elif form.errors:
response.flash = 'form has errors'
return dict(form=form)
Any idea?
Op woensdag 7 november 2012 12:42:58 UTC+1 schreef Niphlod het volgende:
>
> did you try with trunk ?
>
> On Wednesday, November 7, 2012 12:38:40 PM UTC+1, Wouter Pronk wrote:
>>
>> I just did and it did go in exception. Is my web2py corrupt?
>>
>> Op woensdag 7 november 2012 12:17:32 UTC+1 schreef Niphlod het volgende:
>>>
>>> create a fresh app and paste your code in it. It shouldn't go in
>>> exception
>>>
>>> form = SQLFORM.factory(
>>> Field('relatie_id', writable=False, readable=False),
>>> Field('relatie_nummer', writable=False, readable=False),
>>> Field('direction', writable=False, readable=False),
>>> Field('protocol', writable=False, readable=False),
>>> Field('email', requires=IS_EMAIL())
>>> )
>>>
>>>
>>>
>>> This doesn't
>>>
>>> On Wednesday, November 7, 2012 12:12:24 PM UTC+1, Wouter Pronk wrote:
>>>>
>>>> Hello Niphlod,
>>>> this is the traceback:
>>>>
>>>> Traceback (most recent call last):
>>>> File "/home/wouter/Web2py/web2py/gluon/restricted.py", line 212, in
>>>> restricted
>>>> exec ccode in environment
>>>> File
>>>> "/home/wouter/Web2py/web2py/applications/edirelaties/controllers/default.py"
>>>>
>>>> <http://127.0.0.1:8000/admin/default/edit/edirelaties/controllers/default.py>,
>>>> line 381, in <module>
>>>> File "/home/wouter/Web2py/web2py/gluon/globals.py", line 188, in <lambda>
>>>> self._caller = lambda f: f()
>>>> File
>>>> "/home/wouter/Web2py/web2py/applications/edirelaties/controllers/default.py"
>>>>
>>>> <http://127.0.0.1:8000/admin/default/edit/edirelaties/controllers/default.py>,
>>>> line 200, in add_protocol
>>>> Field('relatie_id', writable=False, readable=False),
>>>> TypeError: __init__() takes exactly 1 argument (4 given)
>>>>
>>>> Where should I look?
>>>>
>>>>
>>>> Op woensdag 7 november 2012 11:54:24 UTC+1 schreef Niphlod het volgende:
>>>>>
>>>>> something else is wrong in your app, that piece of code works
>>>>> perfectly fine (the fact that you're declaring 5 fields to let display
>>>>> only
>>>>> one is quite not understandable but hey, it works nonetheless)
>>>>>
>>>>> On Wednesday, November 7, 2012 11:32:39 AM UTC+1, Wouter Pronk wrote:
>>>>>>
>>>>>> I have the following code:
>>>>>> form = SQLFORM.factory(
>>>>>> Field('relatie_id', writable=False, readable=False),
>>>>>> Field('relatie_nummer', writable=False, readable=False),
>>>>>> Field('direction', writable=False, readable=False),
>>>>>> Field('protocol', writable=False, readable=False),
>>>>>> Field('email', requires=[IS_EMAIL(),IS_NOT_IN_DB(db,
>>>>>> 'comprotocol.email')]))
>>>>>>
>>>>>> and this is working perfectly in version 1.99 but not in 2.2.1. I get
>>>>>> an error:
>>>>>>
>>>>>> File
>>>>>> "/home/wouter/Web2py/web2py/applications/edirelaties/controllers/default.py"
>>>>>>
>>>>>> <http://127.0.0.1:8000/admin/default/edit/edirelaties/controllers/default.py>,
>>>>>> line 199, in add_protocol
>>>>>> Field('relatieid', writable=False, readable=False),
>>>>>> TypeError: __init__() takes exactly 1 argument (4 given
>>>>>>
>>>>>> What is wrong?
>>>>>>
>>>>>
--
