FastData was left without a maintainer, and marked as somewhat of a
dead-end somewhere in 2006, before 1.0.x, I remember because I removed
all references to it from the TurboGears book.
I'm not necessarily the person to help, but it looks like there's some
incompatability with the latest sqlobject. You could try pegging
your project to an earlier version of SO. And if you or someone
else is willing to help maintain fasdata I am sure that we would be
willing to do what we can to can help you get started and get
fast-data working with the latest version of SQLObject.
--Mark Ramm
On Sun, Jul 13, 2008 at 8:21 AM, Ben Sizer <[EMAIL PROTECTED]> wrote:
>
> 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
>
> >
>
--
Mark Ramm-Christensen
email: mark at compoundthinking dot com
blog: www.compoundthinking.com/blog
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
