andraZD
|
I just got back today and I will ask hosting company what can be done. You said it still took some time to process even via querry? That means that shared server would have a problem as well ? because it wasn't possible via plugins. How long did it take to process on your end?
|
andraZD
|
Hi Otto,
I have just talked to my hosting company, and they said they are afraid to run this query because they do not understand the plugin and the query good enough to "play" with these settings.
Would you be willing to help it if we create a staging, and I would give you access to it's cPanel? Or would you need some other setup?
Can only a part of the DB be synced via staging, or only the whole DB? I am wondering how to do this without interrupting our publishing schedule.
Thanks,
Andraž
|
Otto
WPML Supporter since 09/2015
Languages:
English (English )
Spanish (Español )
Timezone:
America/Argentina/Buenos_Aires (GMT-03:00)
|
Hello Andraž,
In my local environment, the query took around 30-45 minutes. But it's a powerful setup, and it only ran that site at the moment, without visits.
I suggest creating a copy of the DB. Run the query there. Then switch the site to this new DB and test if everything works as expected. If it does not, you can easily revert, just connecting the site back to the old DB.
This is a safe approach IMHO, as switching DBs is just a matter of configuration if you have two separate DBs.
I am not sure though if your hosting is able to do it this way. Their support should be able to guide you on the best way to accomplish this.
Best Regards,
Otto
|
andraZD
|
Hi Otto,
the hosting company will help me next week since there are holidays here and we do not want to risk anything going wrong when full support staff is not available 🙂
Should I re-activate the plugin and turn off all the options before running the query?
Maybe even use that "clean up" option we have talke about if I already clicked it?
I am still getting random language 404 errors, most are from author pages for example:
sk/author/autorname1
hr/author/autorname1
hr/author/autorname2
de/author/autorname3
Where do you think this could be coming from? I have not even had this active long enough for any backlinks to be built to those pages so I am tryint to figure out where these hits are coming from.
Thanks, A.
|
Otto
WPML Supporter since 09/2015
Languages:
English (English )
Spanish (Español )
Timezone:
America/Argentina/Buenos_Aires (GMT-03:00)
|
Hello Andraž,
Thanks.
Regarding the 404's, it's hard to tell. IMHO, it's probably a bot crawling old indexes. If they keep appearing, may I kindly ask you please to open a new ticket for this new problem? In our experience, handling one issue per ticket leads to best results.
Regarding the cleanup and WPML reactivation. After the cleanup, we will need to check if with WPML 4.8.4 the same problem happens. This needs to be tested in a staging environment, of course. If it does happen again, we will need to raise the problem to our devs.
Best Regards,
Otto
|
andraZD
|
Hi Otto,
They tried and 1. and 2. execured, but 3 failed. So they were not able to continue.
Table doesn't exist error.
This addo already caused so many additional costs, time and trouble I have a headache and I wish i had never even tried to installed it. I have no idea if we will ever be able to fix this ...
|
Otto
WPML Supporter since 09/2015
Languages:
English (English )
Spanish (Español )
Timezone:
America/Argentina/Buenos_Aires (GMT-03:00)
|
Hello Andraž,
I am truly sorry for the inconveniences. I am checking with our second tier support to see if there is anything else we can do on our end.
I'll get back to you as soon as I get a reply.
Best Regards,
Otto
|
andraZD
|
We only had 1 shot at this. I have now already published new content so the databases are not the same anymore.
I thought this was a tested query and it works or i would not even tried at thsi point because they charges us quite a few hours of work and then it didn't even work ...
|
Otto
WPML Supporter since 09/2015
Languages:
English (English )
Spanish (Español )
Timezone:
America/Argentina/Buenos_Aires (GMT-03:00)
|
Hello Andraž,
I am truly sorry for all the trouble.
The query was tested. I ran it in my local development environment and it worked. That's how I was able to share some numbers of before/after.
I think that one of these two things happened:
The query runs in steps and creates a temporary table.
1.
It was run as three separate queries. In this case the temporary table is deleted.
2.
Step two failed due to server restrictions, and then it does not exists in the third part of the query.
In any case, if you are willing to, we can do the following:
- Provide us with a new copy of the DB
- We run the query on it
- We return the DB to you
- You test this new DB in your site
I am enabling a private reply in case you want to go this path and share a new DB copy.
Best Regards,
Otto
|
