I have the following in model. I get an error invalide literal for int when
I add the line Field("comments", "list: reference comment"). Otherwise it
works fine
db.define_table('Post',
Field('author'),
Field('content','Text'),
Field("tags","list:string"),
Field("comments","list:reference comment"),
Field('date', 'datetime',default=request.now))
db.define_table("comment",
Field("created_on","datetime",default=request.now),
Field("body","text"),
Field("author","reference auth_user"))
posts = db._adapter.connection.posts_three
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Below is the error I get.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
Traceback (most recent call last):
File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\restricted.py", line
227, in restricted
exec ccode in environment
File
"C:/Users/Ron/Desktop/web2py_new/web2py_new/applications/mongo_example1/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/mongo_example1/controllers/appadmin.py>,
line 704, in <module>
File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\globals.py", line 393,
in <lambda>
self._caller = lambda f: f()
File
"C:/Users/Ron/Desktop/web2py_new/web2py_new/applications/mongo_example1/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/mongo_example1/controllers/appadmin.py>,
line 151, in insert
if form.accepts(request.vars, session):
File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\sqlhtml.py", line
1679, in accepts
self.vars.id = self.table.insert(**fields)
File
"C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\objects.py",
line 737, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File
"C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\mongo.py",
line 359, in insert
values[fieldname] = self.represent(v, fieldtype)
File
"C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\mongo.py",
line 146, in represent
value = NoSQLAdapter.represent(self, obj, fieldtype)
File
"C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\base.py",
line 1795, in represent
return map(int,obj)
ValueError: invalid literal for int() with base 10: 'comment one'
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
