Deleting items from stream
By Matt Meyer on Thursday, 19 February 2015
Posted in General Issues
Replies 5
Likes 0
Views 829
Votes 0
I am having an issue deleting certain items from the stream in Easysocial admin.. I receive the message that the items have been deleted but they still show up in admin. I also notice that after clearing all items from the stream I can still see a few stream items on the frontend but are no longer in the admin.
Hello Matt,

It seems like the reason why you are unable to delete the stream from the backend is because there is some data from the #__social_stream_item that are missing.

When easysocial perform a delete operation from the backend, it will try to find the data from both #_social_stream and #_social_stream_item table. If there is no data matched from the #_social_stream_item table, the delete operation will failed. We do not know what caused the data from the #_social_stream_item to be missing. Perhaps its because you are using an older version of easysocial which have some minor bug issue.

What I did to fix the stream is by deleting all the data from both #_social_stream and #_social stream_item table and everything is working fine afterwards.

Regarding with the easysocial upgrade concern, what you need to do is list down the custom file that you've made such as php, css, and language file and do a necessary backup before updating. After the update, you can restore back the custom file to the original place and everything should work fine

Hope these can clarify the issue.
Ezrul Fazwan
·
Monday, 23 February 2015 13:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Matt,

I am really sorry for the delay of this reply as it is actually a public day off for us here. When you "delete" the stream, the data get's deleted altogether. What stream item were you trying to delete? Any ways to reproduce this on your site so that I can test it on the site?
Mark
·
Friday, 20 February 2015 18:59
·
0 Likes
·
0 Votes
·
0 Comments
·
If you login to the backend you can see that I have tried to remove all the items under the stream tab. There are about 10 items that will not delete. I have tried clearing cache and checking DB tables and can not figure out why they will not delete. I have attached my site details with a current issue that is still open but please let me know if you need them again.

Thank You
Matt
Matt Meyer
·
Monday, 23 February 2015 11:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Matt,

I am sorry for the delay of this reply.

I am able to reproduce the issue from your administrator side. It seems like somehow when we click the 'purge' or 'trashed' it does not alter the social_stream database with the proper state.
Can you provide us PhpMyAdmin access so we can check your database directly to confirm the issue? Apart from that, it seems like you are using an older version of easysocial.
Can I have the permission to update your easysocial version with the latest one and see if that will fix the issue?

Please advise.
Ezrul Fazwan
·
Monday, 23 February 2015 12:36
·
0 Likes
·
0 Votes
·
0 Comments
·
You can access phpmyadmin through cpanel which I have provided. Also before I update will this also replace all the css, php and en-gb hacks I have made? I still need to place certain items in the the templates css override and en-gb override folders. Also how do I avoid having the php edits that I have made and you have provided from being replaced?

If these files will not be affected then you can go ahead with the update.

Thank You
Matt
Matt Meyer
·
Monday, 23 February 2015 12:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post