By Phivos on Monday, 25 July 2016
Posted in General Issues
Likes 0
Views 524
Votes 0
Dear support,

Back in May 2016 we created some broadcasts (broadcast popup) that concerned an issue of the month (May).

Now, if a user has not logged in for many months but logs in today then the broadcast popup is displayed. Or even if a new user registers today then he sees that broadcast popup. We do not want this to appear anymore as the news are outdated and they concerned only the month of May. Can we delete this broadcast somehow?

Regards,
Hi Phivos,
Currently we do not have any option to disable or delete broadcasts from backend or frontend. If you really want to remove it, perhaps you can provide us with your following details so we can assist you on this?
- PHPMYADMIN acces
- Which Broadcast you would like to delete

Let us know, thanks.
·
Monday, 25 July 2016 16:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Dear Raymond,

Thanks for the prompt reply.

Can you explain to us how to do it ourselves in order not to disturb you in the future for similar issues?

I guess this is a table in the database in the format of "nar_....." from which we have to delete these entries?

Regards,
·
Monday, 25 July 2016 16:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Phivos,
You can run this SQL query at your database.
UPDATE `#__social_broadcasts` SET `state` = 0 WHERE `created` < DATE_SUB(NOW(), INTERVAL 90 DAY);

What this query means is that you would be configuring broadcasts of more than 90 days to not popup. With this, users who login more than 90 days since the broadcast was created will not be seeing the popup. You can adjust the number of days but keep in mind the value must be in days, so "DAYS" cannot be changed.
Before running this query ,you should also backup this table first, #__social_broadcasts for safety measure.

I will also log this issue in the tracker and see what the developers can do about this.
Hope this helped. If you have any other questions regarding this feel free to let us know.
·
Monday, 25 July 2016 16:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Dear Raymond,

Ok thank you. For now, can we delete these entries in #__social_broadcasts as well? Or will there be any issue with that?

Regards,
·
Monday, 25 July 2016 17:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Phivos,
You can run this query to empty the broadcast table.
truncate table `#__social_broadcasts`;
If you do not want to empty the table and want to select certain broadcasts to delete, you have to do it manually by selecting which you want to delete. FYI, each broadcast will generate many rows in the table where each rows contains the broadcast sent to a user.
Also, remember to backup your database before you perform this process as a precaution.
Hope this helps.
·
Monday, 25 July 2016 17:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Dear Raymond,

Thanks for the valuable input.

Regards,
·
Monday, 25 July 2016 19:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Phivos,
May I know whether you were successful in running the queries needed to achieve your objective? If yes, I would like mark this thread as resolved. Let us know, thanks.
·
Tuesday, 26 July 2016 10:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Dear Raymond,

Yes, everything works fine. Thank you.

Regards,
·
Tuesday, 26 July 2016 17:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Phivos,
You're welcome. Glad to know your issue is solved. I will now lock this thread and mark it as resolved. Thanks for updating.
·
Tuesday, 26 July 2016 17:53
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post