Closed (fixed)
Project:
Statuses (Social Microblog)
Version:
7.x-1.x-dev
Component:
Comments submodule
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
24 Jan 2012 at 07:03 UTC
Updated:
18 Feb 2013 at 20:02 UTC
Not sure if any of you have a work around. but I've just come across the below error message and now i can't delete ANY statuses or comments. I hope someone can point me in the right direction. Thanx a lot.
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'op' in 'where clause': SELECT aid FROM {activity} WHERE type = :type AND op <> :op AND eid = :eid; Array ( [:type] => fbss_comments [:op] => fbss_comments_deleted [:eid] => 2 ) in fbss_comments_fbss_comments_delete() (line 1105 of /home/content/04/6522704/html/mysite/sites/all/modules/statuses/submodules/fbss_comments/fbss_comments.module).
Comments
Comment #1
icecreamyou commentedThe problem is likely that I haven't upgraded integration with the Activity module yet and it's still using the D6 API.
Comment #2
javdich commentedI am also looking for integration between statuses and activity module.
Comment #3
mathankumarc commentedAre we gonna support activity integration? Because it has dev release alone for D7.
Comment #4
icecreamyou commentedJust looked -- it's been over a year since the last commit to Activity 7.x-1.x and 7.5 months since the last commit to 6.x-2.x. Activity was always hard to integrate with because there was rarely a stable release and API changes in dev weren't documented. So, no -- let's drop Activity integration. If someone picks it up and starts developing it again, we can always add the integration back.
However, that means we need to make sure we support another activity stream solution. I wrote Activity Log but I haven't ported it to D7 (and although it's usable in D6 I would really like to rewrite it pretty substantially -- and I don't have time to do that in the foreseeable future). That leaves Message and Heartbeat. I think that both of them should just work without any explicit integration courtesy of Rules integration, but I'm not 100% sure. (However Heartbeat permanently caches activity messages, so using submodules like Comments and Flag wouldn't work with it.)
Comment #5
mathankumarc commentedI think we can go for message, cause it supports entity and rules(not a required dependency).
In 2.x we are planned to go for statuses as entity, so message will be a better option for us.
Changing the status to "needs work", since we decided to drop this integration. Any one of us can go ahead and delete this integration submodule.
Comment #6
icecreamyou commentedLet's do this instead.
Comment #7
bdesai commentedAre you guys planning flag friend integration?
Comment #9
mathankumarc commentedWe stopped support for activity. For statuses we have a separate module, so we just disabled it. But for fbss_comments activity integration code was written in fbss_comments.module and its not looking fine.
Can we remove it?
Comment #10
icecreamyou commentedYep
Comment #11
icecreamyou commentedWhile we're at it, there is actually Activity integration code in the Tags submodule too
Comment #12
icecreamyou commentedMarked #1563456: Fatal error: Call to undefined function db_fetch_object() in C:\wamp\www\sites\all\modules\statuses\submodules\fbss_comments\fbs as duplicate
Comment #13
Triumphent commented@IceCreamYou
Re: Fatal error: Call to undefined function db_fetch_object() in C:\wamp\www\sites\all\modules\statuses\submodules\fbss_comments\fbss_comments.module on line 843
Your post: drupal/node/1563456
Can you kindly identify lines 840 to 849 to be deleted in fbss_comments.module (like typing out the first line and the last one?)
Thank you very much. :)
Comment #14
icecreamyou commentedthis
Comment #15
Triumphent commented@IceCreamYou. Thank you.
Comment #16
icecreamyou commentedCommitted fix to dev
Comment #18
jschoder commentedI got the same problem in the activity submodule and at least at the moment it isn't fixed yet:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'op' in 'where clause': SELECT aid FROM {activity} WHERE type = :type AND op NOT LIKE 'fbss_deleted%' AND eid = :eid; Array ( [:type] => statuses [:eid] => 3 ) in fbss_activity_statuses_delete() (line 12 of /home/jschoder/Documents/projekte/nginx/veggie3/sites/all/modules/statuses/submodules/fbss_activity/fbss_activity.module).
Comment #19
icecreamyou commentedThat code should never be executed if this is a new installation or if you followed the upgrade instructions. If you continue have this problem please open a separate support request.