This is now the correct forum, the link in the plugin page refers to the old forums and is now out of date. You could also add an issue on GitHub but this forum is going to have a wider audience.
But you should start a new topic, not tag onto an unrelated one, so I have split this into a new topic.
I’m assuming this thread now applies to the rss feed plugin.
I’m using Rss Feed Manager 2015-05-10 on phplist 3.0.12 in Centos. Under “campaigns” | “view rss items” receiving multiple database errors, such as:
Database error 1267 while doing query Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’
A problem with the query: SELECT COUNT(*) AS t
FROM phplist_RssFeedPlugin_item it
JOIN phplist_RssFeedPlugin_feed fe ON it.feedid = fe.id
WHERE fe.url IN (
SELECT DISTINCT data
FROM phplist_messagedata md
JOIN phplist_message m ON m.id = md.id
WHERE md.name = ‘rss_feed’ AND md.data != ‘’
It looks as if the plugins own tables have been created with a collation that is different to that used by the phplist core tables. In particular the “data” column of the phplist_messagedata table has a different collation to the “url” column of the phplist_RssFeedPlugin_feed table.
i don’t know why that would have happened. To try to fix this you will need to use phpmyadmin or a similar tool to look at the collations and change any that are not right.
This is what I see in phpmyadmin for the feed table:
and for the messagedata table
These have the same collation, but I guess yours are different.
I would like to add an RSS feed in a template message, but I found nothing to do this.
I studied on your last plugin and on rssmanager plug in but they always check the user rss propriety to admit the message to be send. I don’t need that, because I’d use the [RSS] feed in newsletters template.
Do you know if is there something to do that work out of these plugin?
Or, is it possible to make some little change to one of these plugin to do the proper work?