I installed statuses and when I create a status. It displays 2 posts on the profile page. When I delete the post. It deletes both posts. I wish there was more I could do to help replicate this issue. I can take a screen shot of the double post but am sure most of your understand what am talking about. I will be installing devel and hopfuly i can assist a bit more in getting this bug fixed. If it isn't a bug, can someone please direct/instruct me how to fix the issue?

Comments

IceCreamYou’s picture

Status: Active » Postponed (maintainer needs more info)

That's very weird. It's very likely a display issue, probably if you look in your database there is just one record for each status. Have you edited the default view at all? (Also, do you have User Relationships installed?)

Digital Fire’s picture

I have UR 7.x-1.0-alpha4 & Statuses 7.x-1.0-unstable3+23-dev. I played with the view slightly to see if i could get rid of the double (Didnt work). Also, in the Db there is only one entry. So am guessing it may be in the default view?..

IceCreamYou’s picture

It's probably related to the way UR interacts with the view. The facebook_status_stream view probably works but the fbss_ur_stream one probably doesn't. I haven't looked at the UR integration since upgrading the module to D7 but that would be the place to start.

Digital Fire’s picture

Is that the /includes/views/fbss_user_relationships.views_default.inc file that creates the view?

IceCreamYou’s picture

Yes, that's where the fbss_ur_stream view is defined

Digital Fire’s picture

Status: Postponed (maintainer needs more info) » Needs work

I haven't been able to fix this issue. Is it possible you can help me out with this?

mathankumarc’s picture

Status: Needs work » Postponed (maintainer needs more info)

I'm not able to reproduce this. We fixed all the views handlers other than rels_and_me(UR integration) in the dev. Please use the latest dev version.

We have separate issue for rels_and_me handler #1503418: rels_and_me handler is broken

IceCreamYou’s picture

Status: Postponed (maintainer needs more info) » Closed (duplicate)

I'm pretty sure that the fact that the rels_and_me handler is broken is the cause of this issue as well. Let's mark this issue as a duplicate of that issue (#1503418: rels_and_me handler is broken) and if it turns out this issue still exists after the other one is fixed then this issue can be reopened.

Digital Fire’s picture

I've updated to the latest dev and still the issue stands.

Another issue is, I cant delete the status. When I tried I received the following error.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'op' in 'where clause'.
#0 /public_html/includes/database/database.inc(2139): PDOStatement->execute(Array)
#1 /public_html/includes/database/database.inc(664): DatabaseStatementBase->execute(Array, Array)
#2 /public_html/includes/database/database.inc(2318): DatabaseConnection->query('SELECT aid FROM...', Array, Array)
#3 /public_html/sites/all/modules/statuses/submodules/fbss_activity/fbss_activity.module(12): db_query()
#4 /public_html/includes/module.inc(819): fbss_activity_statuses_delete('SELECT aid FROM...', Array)
#5 /public_html/sites/all/modules/statuses/statuses.module(838): module_invoke_all()
#6 /public_html/sites/all/modules/statuses/includes/utility/statuses.edit.inc(116): statuses_delete_status()
#7 /public_html/includes/form.inc(1432): _statuses_delete_confirm(Object(stdClass), Array)
#8 /public_html/includes/form.inc(846): form_execute_handlers('fbss_activity_s...', Array)
#9 /public_html/includes/form.inc(366): drupal_process_form('statuses_delete', Object(stdClass), Array)
#10 /public_html/includes/form.inc(123): drupal_build_form(Object(stdClass))
#11 /public_html/includes/menu.inc(517): drupal_get_form(Array, Array)
#12 /public_html/index.php(21): menu_execute_active_handler()
#13 {main}
$_REQUEST:
Array
(
[destination] => user/1
[op] => Confirm
[form_build_id] => form-D5R-UwMKi30b3gsdGsKGMnCTU1RDxBceCsflua19aRI
[form_token] => 4W6i2_Pl3j_NEi-NYx7HFoJCs1mtv1LI6GGVFNI_nBU
[form_id] => _statuses_delete
[Drupal_visitor_admin_compact_mode] => 1
[SESScf523b7301049e1ca5b5fbb73498e767] => BlPMMC9skbZG-GZJym-M5nmd-igRG95KIv3W5eAoFXg
[Drupal_tableDrag_showWeight] => 0
[has_js] => 1
[Drupal_toolbar_collapsed] => 1
)

REQUEST_URI:
/statuses/1/delete?destination=user/1

Also, I can't see how this would relate to the UR module because am posting the status on my own profile page. I've noticed that it ONLY does the double post when you post on your own profile.

IceCreamYou’s picture

Yes, this hasn't been fixed yet. It's just marked duplicate of another issue that more directly addresses the root cause of the problem. The reason it is related to UR is because the view on your own profile uses an argument that depends on UR (if UR is installed). You can change the view if you want and it should work.

The deletion thing is a totally separate issue. In the future you should open a separate issue for any unrelated problems. However in this case your question is a duplicate of #1415020: Activity integration is broken.

Digital Fire’s picture

Status: Closed (duplicate) » Needs work

This problem is still an issue. Also, Am not sure on that activity fix as I just updated to the latest dev and I received the follow error when trying to delete a status.

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] => 1 ) in fbss_activity_statuses_delete() (line 12 of /public_html/sites/all/modules/statuses/submodules/fbss_activity/fbss_activity.module).

mathankumarc’s picture

Status: Needs work » Closed (duplicate)

We are currently disabled the activity support, since it doesn't have a stable release #1415020: Activity integration is broken. You updated the code but still fbss_activity module is enabled on your instance, that's why you're getting this error.

Since we disabled the activity integration, you will not be able to disable/enable fbss_activity module using modules list. You need to disable it in the database. Using the following query or a similar one.

UPDATE system SET status=0 WHERE name="fbss_activity"
Digital Fire’s picture

Heh, Well I was able to disable the fbss_activity module without having to do the sql query.

Digital Fire’s picture

Also, Is statuses even usable? I tried to post a status with activity disabled and it still double posts AND can not be deleted (I get a server 500 error).

IceCreamYou’s picture

The core Statuses modules are working and stable, but some of the integrations with other modules are broken.

Digital Fire’s picture

So I tried uninstalling everything and turned on JUST statuses... Why do I still get a double post? You keep mentioning views, can you post a walk through with views so that I can see only one post?

mathankumarc’s picture

@Digital Fire could you please export the views and attach in this thread? So that we can able to troubleshoot it..

Another note. Try to use the latest beta version and report back.

Digital Fire’s picture

This was from a project for a previous employer i worked for. So I won't be able to provide the view set up. But, from memory everything was 'out-of-the-box' with this module. i literally just turned it on and used the default blocks that it creates.

oystercrackher’s picture

Status: Closed (duplicate) » Active

Hi, I am also getting the same error described above for duplicate status posts. The number of duplicates varies based on the number of relationships a user has such as followers etc. I have the following installed: User Relationships 7.x-1.0-alpha4 and Statuses 7.x-1.0-beta1.

Attached is the export of the following view "fbss-ur_stream"

$view = new view();
$view->name = 'fbss_ur_stream';
$view->description = 'Displays status updates that match the current recipient context or that match the recipient\'s friends.';
$view->tag = 'Statuses';
$view->base_table = 'users';
$view->human_name = '';
$view->core = 0;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'view all statuses';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['style_plugin'] = 'table';
/* Relationship: User relationships: Requester user */
$handler->display->display_options['relationships']['requester_id']['id'] = 'requester_id';
$handler->display->display_options['relationships']['requester_id']['table'] = 'user_relationships';
$handler->display->display_options['relationships']['requester_id']['field'] = 'requester_id';
/* Field: Statuses: Status ID */
$handler->display->display_options['fields']['sid']['id'] = 'sid';
$handler->display->display_options['fields']['sid']['table'] = 'statuses';
$handler->display->display_options['fields']['sid']['field'] = 'sid';
$handler->display->display_options['fields']['sid']['label'] = '';
$handler->display->display_options['fields']['sid']['exclude'] = TRUE;
/* Field: Statuses: HTML classes */
$handler->display->display_options['fields']['classes']['id'] = 'classes';
$handler->display->display_options['fields']['classes']['table'] = 'statuses';
$handler->display->display_options['fields']['classes']['field'] = 'classes';
$handler->display->display_options['fields']['classes']['label'] = '';
$handler->display->display_options['fields']['classes']['exclude'] = TRUE;
/* Field: Statuses: Sender picture */
$handler->display->display_options['fields']['sender_pic']['id'] = 'sender_pic';
$handler->display->display_options['fields']['sender_pic']['table'] = 'statuses';
$handler->display->display_options['fields']['sender_pic']['field'] = 'sender_pic';
$handler->display->display_options['fields']['sender_pic']['label'] = '';
$handler->display->display_options['fields']['sender_pic']['exclude'] = TRUE;
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['exclude'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['text'] = '[name]';
/* Field: Statuses: Status message */
$handler->display->display_options['fields']['message']['id'] = 'message';
$handler->display->display_options['fields']['message']['table'] = 'statuses';
$handler->display->display_options['fields']['message']['field'] = 'message';
$handler->display->display_options['fields']['message']['label'] = '';
$handler->display->display_options['fields']['message']['exclude'] = TRUE;
/* Field: Statuses: Edit */
$handler->display->display_options['fields']['edit']['id'] = 'edit';
$handler->display->display_options['fields']['edit']['table'] = 'statuses';
$handler->display->display_options['fields']['edit']['field'] = 'edit';
$handler->display->display_options['fields']['edit']['label'] = '';
$handler->display->display_options['fields']['edit']['exclude'] = TRUE;
/* Field: Statuses: Delete */
$handler->display->display_options['fields']['delete']['id'] = 'delete';
$handler->display->display_options['fields']['delete']['table'] = 'statuses';
$handler->display->display_options['fields']['delete']['field'] = 'delete';
$handler->display->display_options['fields']['delete']['label'] = '';
$handler->display->display_options['fields']['delete']['exclude'] = TRUE;
/* Field: Statuses: Created time */
$handler->display->display_options['fields']['created']['id'] = 'created';
$handler->display->display_options['fields']['created']['table'] = 'statuses';
$handler->display->display_options['fields']['created']['field'] = 'created';
$handler->display->display_options['fields']['created']['label'] = '';
$handler->display->display_options['fields']['created']['exclude'] = TRUE;
$handler->display->display_options['fields']['created']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['created']['alter']['path'] = 'statuses/[sid]';
/* Field: Statuses: Re-post */
$handler->display->display_options['fields']['repost']['id'] = 'repost';
$handler->display->display_options['fields']['repost']['table'] = 'statuses';
$handler->display->display_options['fields']['repost']['field'] = 'repost';
$handler->display->display_options['fields']['repost']['label'] = '';
$handler->display->display_options['fields']['repost']['exclude'] = TRUE;
/* Field: Statuses: Status comment box */
$handler->display->display_options['fields']['comment-box']['id'] = 'comment-box';
$handler->display->display_options['fields']['comment-box']['table'] = 'statuses';
$handler->display->display_options['fields']['comment-box']['field'] = 'comment-box';
$handler->display->display_options['fields']['comment-box']['label'] = '';
$handler->display->display_options['fields']['comment-box']['exclude'] = TRUE;
/* Field: Statuses: The word "(Private)" if the status message is private */
$handler->display->display_options['fields']['private']['id'] = 'private';
$handler->display->display_options['fields']['private']['table'] = 'statuses';
$handler->display->display_options['fields']['private']['field'] = 'private';
$handler->display->display_options['fields']['private']['label'] = '';
$handler->display->display_options['fields']['private']['exclude'] = TRUE;
/* Field: Global: Custom text */
$handler->display->display_options['fields']['nothing']['id'] = 'nothing';
$handler->display->display_options['fields']['nothing']['table'] = 'views';
$handler->display->display_options['fields']['nothing']['field'] = 'nothing';
$handler->display->display_options['fields']['nothing']['label'] = '';
$handler->display->display_options['fields']['nothing']['alter']['text'] = '

[sender_pic]
[name] [private]

[message]

[created]

[comment-box]

';
/* Sort criterion: Statuses: Status ID */
$handler->display->display_options['sorts']['sid']['id'] = 'sid';
$handler->display->display_options['sorts']['sid']['table'] = 'statuses';
$handler->display->display_options['sorts']['sid']['field'] = 'sid';
$handler->display->display_options['sorts']['sid']['order'] = 'DESC';
/* Contextual filter: User relationships: Requestee or Requester or Argument user */
$handler->display->display_options['arguments']['rels_and_me']['id'] = 'rels_and_me';
$handler->display->display_options['arguments']['rels_and_me']['table'] = 'user_relationships';
$handler->display->display_options['arguments']['rels_and_me']['field'] = 'rels_and_me';
$handler->display->display_options['arguments']['rels_and_me']['exception']['title_enable'] = TRUE;
$handler->display->display_options['arguments']['rels_and_me']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['rels_and_me']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['rels_and_me']['specify_validation'] = TRUE;
$handler->display->display_options['arguments']['rels_and_me']['validate']['type'] = 'user';
/* Filter criterion: Statuses: Status message */
$handler->display->display_options['filters']['message']['id'] = 'message';
$handler->display->display_options['filters']['message']['table'] = 'statuses';
$handler->display->display_options['filters']['message']['field'] = 'message';
$handler->display->display_options['filters']['message']['operator'] = '!=';
$handler->display->display_options['filters']['message']['group'] = '0';
$handler->display->display_options['filters']['message']['expose']['operator'] = FALSE;
/* Filter criterion: Statuses: Recipient type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'statuses';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'user' => 'user',
);
$handler->display->display_options['filters']['type']['group'] = '0';
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->display->display_options['defaults']['hide_admin_links'] = FALSE;

Please advise on your thoughts.

Thanks

mathankumarc’s picture

Will look into it and get back to you with more info :)

mathankumarc’s picture

Yeah!! able to re-produce the issue. :)

As of now enable the "Distinct" option in the query settings under other tab.

@IceCreamYou can we add distinct option in fbss_ur_stream or is there any work around?

IceCreamYou’s picture

@mathankumarc If this is always reproducible on a blank installation, then whatever fixes the problem is fine. If this only happens under certain circumstances then it might get more complicated. So when is this reproducible / what is the cause?

Yucom’s picture

I do have the same Problem. I am using a custom user-profile.tpl.php, and placed Statuses-block in a custom region. It's working so far, but I get double posts on my own profile. It doesn't happen on other users profile, but if I comment my own Status. So it looks like it does only happen, if a user comment on his own profile/status. Strange thing is, when I comment on someone elses profile there's only one reply, but the same status gets twice on my profile. It seems to be a problem with the users own profile/status.

Digital Fire’s picture

Haven't picked this issue up in awhile because I haven't used the module for a few months. Will start doing some debugging. I hope to be able to provide atleast some info on what might be the root cause to this error. I REALLY want to get this functionality working for a couple of my sites.

eidoscom’s picture

On a fresh install of the new 7.x-1.0-beta2 version I'm unable to reproduce the problem. I installed UR + Statuses and out-the-box it is working well. @Yucom and @oystercrackher are you tried to uncheck the "Show the status stream on the default user profiles" checkbox on "admin/config/statuses/settings/advanced"? It sloves the problem for you??

As I said, out-the-box is working but there was another issue similar with this that solved unchecking the checkbox mentioned above.

I noted that in the new beta2 version "fbss_ur_stream" has desapeared... So if the problem was with the "fbss_ur_stream" view, must we consider this issue fixed??

Thanks

eidoscom’s picture

Sorry but fbss_ur_stream is not desapeared. I installed Statuses prior to UR and for this I can't see the fbss_ur_stream on views list but desinstalling statuses and reinstalling make the fbss_ur_stream reapeared.

Is this behavior working as designed?? Seems that the fbss_ur_stream must be available no matter the order of module installing.

IceCreamYou’s picture

If you install Statuses before UR, the contexts won't automatically switch to using the fbss_ur_stream view, but it will still exist and you can switch to it manually. This is to avoid unexpected changes for people who are already happy with their views before UR is installed.

haunted’s picture

Issue summary: View changes

Same problem here with both 7.x-1.0-beta2 and 7.x-1.x-dev.