I installed the latest version of FastData and applied it to a few of
my model classes. The display seems to work ok, but when I click to
edit a row, I get an error like this:
<...snip...>
File "e:\code\python25\lib\site-packages\TGFastData-0.9a7-py2.5.egg
\tgfastdata\datacontroller.py", line 314, in edit
values.update(join_items(obj))
File "e:\code\python25\lib\site-packages\TGFastData-0.9a7-py2.5.egg
\tgfastdata\datacontroller.py", line 21, in join_items
d[attr_name] = list(getattr(sobj, attr_name))
File "<string>", line 1, in <lambda>
File "e:\code\python25\lib\site-packages\SQLObject-0.10.0-py2.5.egg
\sqlobject\joins.py", line 144, in performJoin
inst.id)
File "e:\code\python25\lib\site-packages\SQLObject-0.10.0-py2.5.egg
\sqlobject\dbconnection.py", line 537, in _SO_selectJoin
self.sqlrepr(value)))
File "e:\code\python25\lib\site-packages\SQLObject-0.10.0-py2.5.egg
\sqlobject\dbconnection.py", line 686, in queryAll
return self._dbConnection._queryAll(self._connection, s)
File "e:\code\python25\lib\site-packages\SQLObject-0.10.0-py2.5.egg
\sqlobject\dbconnection.py", line 343, in _queryAll
self._executeRetry(conn, c, s)
File "e:\code\python25\lib\site-packages\SQLObject-0.10.0-py2.5.egg
\sqlobject\mysql\mysqlconnection.py", line 119, in _executeRetry
raise OperationalError(ErrorMessage(e))
OperationalError: Unknown column 'task_type_id' in 'where clause'
The model class looks like this:
class TaskType(SQLObject):
description = UnicodeCol(length=30, notNone=True)
# ...more, presumably irrelevant properties elided...
instances = MultipleJoin('Task') # all existing tasks of this type
The table in the MySQL database looks like:
CREATE TABLE `task_type` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(30) NOT NULL,
/* --- etc -- */
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8
Anybody got any ideas what I could be doing wrong?
Running TG 1.0.4.4, TGFastData 0.9.a7, SQLObject 0.10.0, on Python 2.5/
Win32/MySQL platform.
--
Ben Sizer
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
