Trying to set up Yelp Review (on MT 4.23), and I’m getting errors that look like this:
“You tried to set inexistent column review to value McDonalds Hamburgers (3/5) on Yelp.com on ActionStreams::Event::Auto::Yelp::Reviews”
Looking at the code, I’m thinking that the problem might have to do with the fact that it’s looking for column “review” (singular) and yet the $stream_id (I think that is what it is using) is “Reviews” (plural). But I’m not certain. There doesn’t seem to be anything else funky about the reviews, so I’m out of other ideas. Other profiles work fine, it’s just the Yelp user.
Any ideas?
Reported on Movable Type 4.2
What version of AS are you using?
At what point is this error being generated, when actions are updated or when publishing a page with the actions on it?
How are you accessing the "review" field?
the "stream_type" is reviews but within that there is a field called "review" that you should be able to access using MTStreamActionVar.
See below for a list of action stream fields:
http://www.richardbenson.co.uk/2008/12/action-stream-20-field-list.html
Version is listed in config.yaml as 2.0, schema_version 13 (from SVN, updated 12/3). Error is generated when I click "update now". Since I don't really have much in the way of data, I don't have any template tags in use (I have been able to update other content, such as del.icio.us, however - just not using in any templates).
I'm not accessing the data - this is an error generated by MT after clicking the "update now" button.
The del.icio.us items show as `profileevent_class` = `delicious_links`, and in `profileevent_meta` they are "title" and "url" - your link shows other fields "created_on" and "note" which I don't show in the meta table (may not matter, just mentioning).
I'll try updating to the latest revision and see what happens.
Updated to revision 1314 (schema version 15), and I'm getting the same message. So while it may have helped (something), the initial problem is still there. Any other ideas?
Hmm, there's no `fields` setting in the stream to declare that `review` is a field of Yelp actions. It really *doesn't* exist, and it's a mistake that it's trying to put the entry `title` there.
I removed the reference to the `review` field in changeset 1322.
That seemed to fix it right up. Thanks Mark!
Thanks Mark, that has been removed from my field list as well.