Hi there,
I’m sorry to hear about this issue!
First, I’d recommend making a quick backup of your site. Next, access your database via phpMyAdmin and open the wp_options table. In there, locate the iawp_is_migrating option and change the value to 0 (zero). That should fix the error, but please let me know if it persists.
If you’re not sure how to complete any of these steps yourself, please reach out to me at [email protected], and I can provide further assistance (we will need to discuss sensitive account data that can’t be posted here).
Hello,
Thank you very much, it works.
Sorry for my late reply.
Thank you
Have a nice day
That’s great to hear! I’m glad this solution worked for your site 🙂
Today I have the same problem as Akro Web 3 months ago showing exactly the same message. But in my database there is no “iawp_is_migrating” – option. Could you please give me a hint?
I’m sorry for this error. We’ve seen this happen a few times after the latest update.
Can you look for the database option “iawp_db_version” and let me know what the value is? If it’s “12” then this means the migration failed partway through. The next step will be to look at the database table named “wp_independent_analytics_session” and check if both the “city_id” and “country_id” columns are empty (they may say NULL). Please let me know if that is also true or if you see numbers in those columns instead.
This info is going to ensure that I provide you with the right solution to complete the migration successfully.
Thank you for your patience while we help to resolve this.
Hi Ben,
Thanks for your help. Yes, you are right. iawp_db_version has the option_value 12 and city_id and country_id are empty (NULL).
Thanks for verifying! There are a couple of steps to correct this.
First, please change the iawp_db_version to 13.
Next, install this helper plugin on your site: download from here. Once installed, you’ll find this new menu: https://d.pr/i/DuAx3b. All you have to do is click the Fix button on that page.
Once that’s done, you’ll need to run one SQL query. In phpMyAdmin, you can run commands from the SQL tab.
This is the query you can run:
UPDATE
wp_independent_analytics_sessions AS sessions
LEFT JOIN wp_independent_analytics_visitors AS visitors ON sessions.visitor_id = visitors.visitor_id
LEFT JOIN (
SELECT
countries.country_id,
cities.city_id,
countries.country_code,
cities.subdivision,
cities.city
FROM
wp_independent_analytics_cities AS cities
LEFT JOIN wp_independent_analytics_countries AS countries ON cities.country_id = countries.country_id) AS locations ON visitors.country_code = locations.country_code
AND visitors.subdivision = locations.subdivision
AND visitors.city = locations.city
SET sessions.country_id = locations.country_id, sessions.city_id = locations.city_id
That should fix it, but you may also have to set the iawp_is_migrating option equal to “0” if you still see the update in-progress message.
Everything should work after that, but please let me know if there are any issues along the way.
Thank you for your BugFix. I have done everything that you recommended, except the SQL query, because there was an error message:
“1054 – Unbekanntes Tabellenfeld ‘sessions.country_id’ in field list”
But the last point (“iawp_is_migrating = 0”) has really helped. Independent Analytics is working again. However, I have lost a few days of data.
Okay glad to hear we’ve made some progress. Would you be able to reach out to me at [email protected]? In order to continue, we need to discuss sensitive data that can’t be posted here.
Public note: The steps above worked to correct this issue. However, this solution was specific to the version 1.28 migration. If you experience this issue from a later version of Independent Analytics, please open a new thread as this solution will not work for your site.
