Here is some quick code that can be run on the database to remove the duplicates:
@todo replace wp_16 with the correct prefix
DELETE c1
FROM wp_16_comments c1
JOIN wp_16_comments c2
ON c1.comment_post_ID = c2.comment_post_ID
AND c1.comment_content = c2.comment_content
AND c1.comment_ID > c2.comment_ID;
@CairoCoder Great questions!
Security and privacy come first and will be part of the conversations all the way through.
The plan in to start playing with AI in a separate plugin.
When the plugin is installed and activated an API key will be needed to enable any AI features.
We'll be building out in a way that any of the AI services could be used. Those who want to enable AI features will have to choose which one they want.
The current big options (OpenAI and Anthropic) are powerful, but we do NOT recommend them for privacy concerns.
The most secure option would be a self hosted AI server. This will only be a good option for those with a lot of resources and tech knowledge.
We're testing and will offer a recommendation of a service (or a couple services) that are secure and focus on privacy.
TL;DR AI features will be opt in.
We've been talking about AI and are curious what applications it has in ministry and disciple making. We're also wondering what use cases AI has in Disciple.Tools itself.
While AI is becoming more and more capable, it remains a tool.
We're looking forward to discovering how it can be serve us, while maintaining privacy and security.
Here's a couple things we want to try to get started:
Please comment if you have ideas or questions. We'd love to hear.
Thanks @PetrV-Online!
The Facebook sync tool uses the wp_options table to store the current progress of the sync. If the values are cached, then it will continue trying to sync the some pages again instead of seen that it has already been done.
I'm guessing this is what is happening.
We've attempted to write a warning around object caching, but haven't been able to reliably detect if it is enabled or not: https://github.com/DiscipleTools/disciple-tools-theme/issues/2313
There isn't anything in place to remove existing duplicate comments.
There is a function to find and remove duplicate contacts created from Facebook, that could probably be copied and made to work for comments.
@jaichele70 Please try disabling
Redis Object Cache and then monitor if the issue continues to happen.
D.T does not play well with object caching. You'll want to disable this on the server side and then also disable the plugin in wordpress.
Hey @John-Komba,
The mobile app has fallen a bit behind Disciple.Tools in development. At this point we'd suggest simply using the website if the mobile app doesn't work for what you and your team will need currently.
@jaichele70 Any key differences users should be looking out for?
@Vlad-AZ You could use any backup plugin from the WordPress directory.
I've used https://updraftplus.com/ in the past. I think you'll need the paid version to copy D.T tables.
@Vlad-AZ a backup plugin can export the database and copy the .sql file to an external storage.
Hey @jaichele70,
Is this the one you are looking for https://github.com/prykon/next-steps-tile-plugin ?
Looks like @prykon built it.