how to safely downgrade Independent Analytics to previous verison

Thanks for using Independent Analytics!

Downgrading between most versions isn’t possible because of changes to the databases, but I’m sure we can resolve whatever plugin compatibility issue you’re having. Could you let me know what’s not working with this other plugin?

Thank you for your fast reply. I guess they use the old query to get the visitors, views, and sessions but still can not find a way to query to get these data from the tables.

Could you please give me some guides to get the data for this new version?

Could you share a link to this plugin? We can help the devs directly with this and get into the technical details.

The high-level explanation is that the “visitors” table was deleted because it was merged with the “sessions” table, which is what they’ll want to query for the stats.

I like your plugin and I hired someone to do that before, Actually, it is a very simple plugin that queries the data from several sites to get the stats because Independent Analytics hasn’t supported multisites yet.

Could you please give me a few insights on how to get Visitors, Views, and Sessions?

Okay I see. Please pass this query along to your dev:

SELECT
    COUNT(DISTINCT sessions.session_id) AS sessions,
    COUNT(DISTINCT sessions.visitor_id) AS visitors,
    COUNT(DISTINCT views.id) AS views
FROM
    wp_independent_analytics_sessions AS sessions
    LEFT JOIN wp_independent_analytics_views AS views ON sessions.session_id = views.session_id
WHERE
    sessions.visitor_id IS NOT NULL
    AND sessions.created_at BETWEEN "2023-01-01" AND "2024-01-01"

That is going to fetch the visitors, views, and sessions from the given date range.

Thank you very much for you support.

You’re welcome! Stay in touch if you need anything else.