Title: MySQL Error Log
Last modified: August 22, 2016

---

# MySQL Error Log

 *  Anonymous User
 * (@anonymized-14169293)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/)
 * I’m getting about 40 error log daily with this:
 * FastCGI sent in stderr: “PHP message: Error You have an error in your SQL syntax;
   check the manual that corresponds to your MySQL server version for the right 
   syntax to use near ‘clustering `clustering` tinyint(1) unsigned NOT NULL’ at 
   line 1 de la base de datos de WordPress para la consulta ALTER TABLE qrwpmu_leafletmapsmarker_layers
   CHANGE COLUMN clustering `clustering` tinyint(1) unsigned NOT NULL realizada 
   por do_action(‘admin_init’), call_user_func_array, Leafletmapsmarker->lmm_install_and_updates,
   include(‘/plugins/leaflet-maps-marker/inc/install-and-updates.php’), dbDelta,
   W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor-
   >query, W3_Db->default_query” while reading response header from upstream
 * [https://wordpress.org/plugins/leaflet-maps-marker/](https://wordpress.org/plugins/leaflet-maps-marker/)

Viewing 14 replies - 1 through 14 (of 14 total)

 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543521)
 * 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)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543534)
 * 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.
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543544)
 * 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)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543546)
 * 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.
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543548)
 * 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)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543549)
 * That’s right!!
    The plugin is working without any issues, I see this error only
   in my logs (PHP and NGINX error logs).
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543628)
 * 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](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)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543643)
 * 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?
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543645)
 * 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)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543647)
 * Thanks a lot Robert for your help.
    You really bend over backwards with the plugin
   users.
 * Regards.
 *  Thread Starter Anonymous User
 * (@anonymized-14169293)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543824)
 * 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.
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543825)
 * 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)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543826)
 * 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.
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543827)
 * 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.wordpress.org/ticket/30655](https://core.trac.wordpress.org/ticket/30655)
   respectively [https://core.trac.wordpress.org/ticket/20263](https://core.trac.wordpress.org/ticket/20263)–
   perhaps you could also add a comment at the second ticket that you would prefer
   a fix for this issue 😉
    best, Robert

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘MySQL Error Log’ is closed to new replies.

 * ![](https://ps.w.org/leaflet-maps-marker/assets/icon.svg?rev=970936)
 * [Leaflet Maps Marker (Google Maps, OpenStreetMap, Bing Maps)](https://wordpress.org/plugins/leaflet-maps-marker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/leaflet-maps-marker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/leaflet-maps-marker/)
 * [Active Topics](https://wordpress.org/support/plugin/leaflet-maps-marker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/leaflet-maps-marker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/leaflet-maps-marker/reviews/)

## Tags

 * [log](https://wordpress.org/support/topic-tag/log/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 14 replies
 * 2 participants
 * Last reply from: [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/mysql-error-log/#post-5543827)
 * Status: not resolved