Number of markers

Hi sgibert,

I would need some extra info by you.

1) Have you space in your MySql database yet ? If you can create new post or pages you have enough space yet.
2) Are you running last plugin version?
3) Are you using a Western language ?
4) Are you using a lot of information for the marker popup and/or dim ?

This can be related to the quota of information reached for markers’ information storage.

That’s what you should kindly check:

1) Changing the 70th marker with another one will change the situation ? Try just placing name, lat and long.
2) Each markers’ type of information (name, lat, long, dim and popup ) uses a longtext fieldset in MySql database for each map, and the information are serialized (so all together each field of db ).

So all markers’ name will be stored together in the same field, as well as lat, long, dim and popup.

In other words maybe you exceededs the LONGTEXT fieldset ( which is a bit weird as it can contains 4gb – this values can change in some configuration ) probably for the popup fields.

…In order to count byte quantity of your field syou can use some online tools like : https://mothereff.in/byte-counter

Thanks for the quick reply.
1) yes, i do have enough room on the DB, it’s only 2.9Mb when i extract it and my limit my much higher
2) yes I am running the latest version
3) I am using both english and chinese. Chinese works well though so it shouldn’t be the issue
4) the dim are empty but the popup all have a line of text, at most 60 characters

regarding the things to check:
1) I did try some other text, what happens it that it register the name and lat, but not long and after once i saved. so the marker only has name and lat which then doesn’t display…
2) at most i have less than 5,000 characters in the values for wp_postmeta: _rvm_marker_name, _rvm_marker_lat, _rvm_marker_long, _rvm_marker_link, _rvm_marker_dim, _rvm_marker_popup

I tried on different servers and they all return the exact result.
Any help (files ? )I can provide to fix this and continue improving the great work ?

Steven

Hi Steven,

So basically long data of 70th marker is not recorded on DB ? If one of these three data ( name, lat and long miss marker should not be saved at all ), so this would be weird.

Can you please copy and send me over the serialized of wp_postmeta with markers not working so I can have a look myself.

Could you even check max_allowed_packet in MySql conf ? As far as I know it manages LONGTEXT column storage capability.

Hi Enrico,

I can’t send long pieces of text here.
Could you share your email with me? –?steven{{{@}}}glowin.co

for mysql: max_allowed_packet 16777216

Thanks,
Steven

[Large code excerpt removed by moderator per forum rules. Please use the pastebin for all large code excerpts. It works better anyway.]

https://pastebin.com/njPUdm5S

Here it is

Another piece of information.
I filled in the data directly into the database with the following:
https://pastebin.com/85Md1EzM
and it works.

in the wordpress admin, when i go into the map, I can see all the entries without an issue but making an update create the same issue, the 70th markers is half filled in and all the one after disappear.

Hope this helps.

Steven

Thanks Steven !

I’ll check on my side as well.
It make me thinking could be an issue in the buffer or memory allocated for writing into DB.

I’ll check, thanks again for your feedback

Hi Steven,

I’ve not forgotten to check, I was just busy with last release !

I’ll come back to you anyway, good or bad news ??

Thanks a ton!
Hopefully with good news. Let me know anyway I can help
Steven

Hi Steven,

finally I have an explanation for that.

PHP, by default, is set to accept only one thousand of parameters sent by a form.

Considering the fact that main settings, subdivisons ( old Regions/Countries) and markers fields are sent as a whole, it means that unfortunately you reached this quota !

I tried this plugin : https://www.ads-software.com/plugins/wp-max-submit-protect/

which basically alerts you when this limit is reached.

That’s why it works when you insert it manually into DB.

I guess a workaround is working on the php.ini settings ( here an explanation : https://docs.woothemes.com/document/problems-with-large-amounts-of-data-not-saving-variations-rates-etc/ ).

Please let me know if you are able to solve it.

Feel free to contact me again on this and best luck !