- This topic has 22 replies, 2 voices, and was last updated 2 years, 9 months ago by arthos.
April 5, 2018 at 12:59 pm #36245arthosMember
I have a client’s site with GMaps Pro, and did the requested update this morning (to version 7).
I use Wordmove (https://github.com/welaika/wordmove/) to synchronize between local and production servers, but since the update, an error stops the DB synchronisation between them. This Ruby tool can’t search and replace through the SQL dump because of invalid data – which never occured until now.
It occurs at the line of inserting WPGMaps data to the DB. I asked around, there were no additions to the marker’s list, so it should work (since it worked before the update).
Error returned when trying to import the dump with WP CLI is :
ERROR at line 960 in file: 'dump.sql': Unknown command '\\'.
Any idea of how I could get this working ?
Thanks by advance.
Best regards.April 5, 2018 at 2:21 pm #36248PerryModerator
Thanks for getting in touch, sorry to hear about this issue.
Can you please send me the dump.sql file?
– PerryApril 5, 2018 at 4:41 pm #36257arthosMemberThis reply has been marked as private.April 6, 2018 at 10:05 am #36302PerryModerator
Yes, it sounds like there is bad UTF data in there indeed.
I don’t know if you tried to attach the file but it didn’t come through – could you possibly upload it to Google Drive and get back to me with a link?
We may be able to recover and correct the data for you.
– PerryApril 6, 2018 at 11:20 am #36306arthosMemberThis reply has been marked as private.April 6, 2018 at 1:43 pm #36317PerryModerator
I can’t even import this with phpMyAdmin, I’d say this is quite broken.
Do you have the source data from before you imported this into WP Google Maps?
– PerryApril 6, 2018 at 1:54 pm #36318arthosMemberThis reply has been marked as private.April 6, 2018 at 2:49 pm #36319PerryModerator
Thanks, which table(s) would I find the source data in?
– PerryApril 6, 2018 at 3:13 pm #36320arthosMember
The legit data is at line 7309, the dbprefix-‘_wpgmza_maps’ table inserts.
It’s a full export of a staging site, where we entered (manually) 70+ agencies. This file worked like a charm (you helped me make the site appear really fine).
It got corrupted when I upgraded to the last version of WPGMaps Pro and the export did not go well (see the same table in the previous file transmitted via wetransfer.com).
LApril 6, 2018 at 4:12 pm #36323PerryModerator
I’m having issues with my web server at the moment and can’t restart right at this moment,
Just a quick thought, have you tried exporting from phpMyAdmin and if so is the data still munged?
Does it display correctly in phpMyAdmin?
– PerryApril 6, 2018 at 4:20 pm #36325arthosMember
Well, no, as I mentioned, I was in a hurry and did start from the staging backup I sent you. It’s all sorted now (took me a while).
I’ve sent the files in order to help you reproduce that bad behavior. WPGMaps Pro is the only plugin that had to be updated at that moment, and the corruption followed the update : it doesn’t mean it comes from the update, it’s just a clue. In case it’d be because of the update, I hope my files would help ; in case it’s not, well, sorry for wasting your time… 🙂
LApril 9, 2018 at 8:57 am #36387PerryModerator
Not at all it’s never a waste of time 🙂
Would you be kind enough to upload that file to Google Drive? Your attachment didn’t come through.
I’d like to compare the new file with the old one so I can figure out what went wrong here.
We’re very grateful for your time, thanks again!
– PerryApril 9, 2018 at 8:26 pm #36442arthosMemberThis reply has been marked as private.April 10, 2018 at 11:33 am #36473PerryModerator
I would need to see the *source data*, eg the data you used to make these maps and markers, rather than the whole dump which appears to only contain the broken data.
If that’s not possible, please use a text editor such as Notepad++ and remove all the control characters on line 960.
Notepad++ is showing the following control characters:
If you go to that line you’ll be able to see them clearly and remove them.
If you do have the source data, I’d be interested in a copy so we can analyse what went wrong here.
Does that help?
– PerryApril 10, 2018 at 11:52 am #36475arthosMemberThis reply has been marked as private.
- You must be logged in to reply to this topic.