are you using the latest version of Leaflet Maps Marker? In addition: do you know if you are using mySQL in a clustered edition? A few versions ago I added backticks (`) to all SQL queries as clustering got a reserved keyword for mysql clustered edition and adding backticks solved that issue….
Thread Starter
Anonymous User
(@anonymized-14169293)
Thanks for your fast response.
All my plugins are updated.
– Web Server: nginx/1.6.2 – Ubuntu 14.04.1 LTS
– Server version: 5.6.21-70.1 – Percona Server (GPL), Release 70.1, Revision 698
– mysql Ver 14.14 Distrib 5.6.21-70.1, for debian-linux-gnu (x86_64) using EditLine wrapper
About the clustered edition, I don’t really know about it.
mhhhh, not sure what might be causing this. Would have to take a closer look (for pro customers I also offer to directly debug the issue on your server)…
Thread Starter
Anonymous User
(@anonymized-14169293)
I understand, I’m not a PRO customer, but would be great if we can fix it.
Feel free to tell me if I can help you.
The plugin is working great, this error is just at log-level issue.
thanks for the info. So that I understand you correctly: the plugin is working without any issues (especially layer map updates) and the error you described is only in the PHP log file?
Thread Starter
Anonymous User
(@anonymized-14169293)
That’s right!!
The plugin is working without any issues, I see this error only in my logs (PHP and NGINX error logs).
Hi again,
did a deeper look into the code & think I found (and fixed) an issue that could be related to these log entries: the dbdelta()-function that is used to update the database tables for Leaflet Maps Marker and that is run once a day (controlled by a transient) throws errors as I also added backticks to the field names there but as I just read now according to the WordPress codex backticks are not supported by dbdelta().
Can you please test if the following fix works?
1. replace /inc/install-and-updates.php with code from https://raw.githubusercontent.com/robertharm/Leaflet-Maps-Marker/e3af95b67d64214ba69881928fe6223042a94c2f/inc/install-and-updates.php
2. open leaflet-maps-marker.php and find
function lmm_install_and_updates() {
//info: set transient to execute install & update-routine only once a day
$current_version = "v394"; //2do - mandatory: change on each update to new version!
$schedule_transient = 'leafletmapsmarker_install_update_cache_' . $current_version;
$install_update_schedule = get_transient( $schedule_transient );
if ( $install_update_schedule === FALSE ) {
$schedule_transient = 'leafletmapsmarker_install_update_cache_' . $current_version;
set_transient( $schedule_transient, 'execute install and update-routine only once a day', 60*60*24 );
include('inc' . DIRECTORY_SEPARATOR . 'install-and-updates.php');
}
}
3. temporarily replace this function with
function lmm_install_and_updates() {
include('inc' . DIRECTORY_SEPARATOR . 'install-and-updates.php');
}
4. open the page “liste all markers” and check if the error log still occurs.
5. restore the original function lmm_install_and_updates() {…}
Let me know if that worked for you!
best,
Robert
Thread Starter
Anonymous User
(@anonymized-14169293)
Seems like it worked all right.
Now I’m not getting the error in logs.
Now I have to restore to the original functions (both), I suppose you’re going to include this in the next plugin update. Right?
great! thanks a lot for reporting!
will be included in the next release, available probably this weekend…
best,
Robert
Thread Starter
Anonymous User
(@anonymized-14169293)
Thanks a lot Robert for your help.
You really bend over backwards with the plugin users.
Regards.
Thread Starter
Anonymous User
(@anonymized-14169293)
Hi Robert,
Here again because after the latest plugin update release, I’m getting exactly the same error in my server logs.
Thanks in advance.
Best regards.
Hi,
I had to re-add the backticks to the wpdelta() update function for clustering, as otherwise the script wouldnt work on mysql clustering editions. Anyway the error log entries should be reduced, as all other columns for markers and layers do not have a backtick anymore, which is responsible for this php error log entry. In addition, this should only occur once a day.
There is an open support core ticket regarding this issue, hope that it will be resolved soon .
best,
Robert
Thread Starter
Anonymous User
(@anonymized-14169293)
I understand and hope we can see this issue fixed, I’m obsessed with having my server free of errors, but sometimes it’s acceptable due to the complicated development process.
I appreciate your job and support.
Thanks for you understanding – believe me, I am at least as well obsessed with keeping my plugin free of any PHP erros or warnings – nevertheless in this case there is unfortunately no workaround yet; I really hope that the core dev guys can sort out the bug with wpdelta() – for details see my trac ticket at https://core.trac.ww.wp.xz.cn/ticket/30655 respectively https://core.trac.ww.wp.xz.cn/ticket/20263 – perhaps you could also add a comment at the second ticket that you would prefer a fix for this issue 😉
best,
Robert
