Hi
On web2py, version 1.83.2 (2010-08-15 08:16:30) , I have the following
table:
db.define_table("products",
Field("categoryID", db.productCategory, writable=False,
readable=False, requires=IS_IN_DB(db, "productCategory.id",
"productCategory.name") ), # reference field
Field("RRRating", 'integer', default='0',writable=False,
readable=False),
Field("productName", 'string',length=512, default=None),
Field("author", 'string',length=512, default=None),
Field("productShortDescription", 'text', length=2048,
default=None),
Field("productLongDescription", 'text', default=None),
Field("urlProduct", 'string', length=2048, default=None,
requires=IS_URL() ),
Field("urlImageBig", 'string', length=2048, default=None,
requires=IS_URL()),
Field("urlImageSmall", 'string', length=2048, default=None,
requires=IS_URL()),
Field("price", 'double', default=0),
Field("updateDate", 'datetime')
)
When the database is empty I can see it in the admin page and add
products to it
However when I fill it with data (obtained from rss feeds) and go the
the admin page to look at the table contents I get the following
error:
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 186, in restricted
exec ccode in environment
File "C:/web2py/applications/reviewround/views/appadmin.html", line
160, in <module>
<strong>{{="%02d" % ram['oldest'][0]}}</strong> hours
File "C:\web2py\gluon\globals.py", line 105, in write
self.body.write(xmlescape(data))
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\html.py", line 589, in xml
(fa, co) = self._xml()
File "C:\web2py\gluon\html.py", line 580, in _xml
self.components])
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\html.py", line 589, in xml
(fa, co) = self._xml()
File "C:\web2py\gluon\html.py", line 580, in _xml
self.components])
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\html.py", line 589, in xml
(fa, co) = self._xml()
File "C:\web2py\gluon\html.py", line 580, in _xml
self.components])
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\html.py", line 589, in xml
(fa, co) = self._xml()
File "C:\web2py\gluon\html.py", line 580, in _xml
self.components])
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\html.py", line 1065, in xml
return DIV.xml(self)
File "C:\web2py\gluon\html.py", line 589, in xml
(fa, co) = self._xml()
File "C:\web2py\gluon\html.py", line 580, in _xml
self.components])
File "C:\web2py\gluon\html.py", line 106, in xmlescape
return data.xml()
File "C:\web2py\gluon\sql.py", line 1517, in __getattr__
self.__allocate()
File "C:\web2py\gluon\sql.py", line 1512, in __allocate
raise Exception, "undefined record"
Exception: undefined record
I made sure that I sanitize the different fields when I add to this
table:
db.products.insert(productName=None if data['name'] == None else
sanitize(data['name']),
productShortDescription=None if
data['summary']==None else sanitize(data['summary']),
productLongDescription=None if
data['content']==None else sanitize(data['content']),
urlProduct=None if data['link']==None else
sanitize(data['link']),
urlImageBig=None if data['imgPreviewUrl']==None
else sanitize(data['imgPreviewUrl']),
urlImageSmall= None if
data['imgPreviewUrl75']==None else sanitize(data['imgPreviewUrl75']),
price=data['price'],
author=None if data['artist']==None else
sanitize(data['artist']),
updateDate=
data['updateDate'],
categoryID=63)
Any idea of what is going wrong?
thanks
-Miguel
