Lou

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 43 total)
  • Author
    Posts
  • in reply to: Google Maps API errors with TEC Pro 4.4.30 #1594930
    Lou
    Participant

    I’m good now. Thanks for your help.

    in reply to: Google Maps API errors with TEC Pro 4.4.30 #1594532
    Lou
    Participant

    I should have also said that seems like things are fine for my use case now. I will leave the solution as it stands, deregistering tribe-gmaps from functions.php.

    in reply to: Google Maps API errors with TEC Pro 4.4.30 #1594526
    Lou
    Participant

    I have made the update on both sandbox and production servers, https://sandbox.steeplechasers.org/training/running-routes/ and https://steeplechasers.org/training/running-routes/ respectively.

    A previously configured single event view looks ok. I also configured a new event with a new venue https://sandbox.steeplechasers.org/events/test-event/ and it looks fine as well.

    In Events > Settings > Display, I allowed Map view and when looking at the user map view it doesn’t work (as I expected). I see white screen for map. (Inexplicably when I added Map view my default view changed from Month to List. Going back in to settings I changed the default view back to month, and this seemed to stick.)

    > Maybe things will work more than I said because of your theme loading the script.

    Note my theme doesn’t load the script “correctly” from a wordpress perspective. For this purpose, the google maps script is only loaded on the theme-specific template pages (i.e., using direct html, not wp_enqueue_script() ) which are involved with displaying the map. See https://sandbox.steeplechasers.org/training/running-routes/ and https://tinyurl.com/y9ovc9e8 for rendering of the two templates.

    Since Events Maps are working in most cases, I have to assume tribe-gmaps isn’t the only way TEC loads the google maps scripts, and somehow there is no conflict when tribe-gmaps is deregistered.

    Interestingly, when I go to the home page (or other random page, even the calendar overview) and inspect with developer tools I see no google maps script inclusion, but when I go to a page managed by TEC that displays a map (e.g., single event view) I do see the google maps scripts. I don’t have time to reverse engineer how Tribe does this, but seems better than always including the google maps scripts on all pages.

    in reply to: Google Maps API errors with TEC Pro 4.4.30 #1593613
    Lou
    Participant

    That’s unfortunate because we use some of that functionality.

    This is more of a basic wordpress question, but do you recommend a way to deregister ‘tribe-gmaps’ ONLY from certain pages?

    in reply to: Google Maps API errors with TEC Pro 4.4.30 #1592737
    Lou
    Participant

    deregister of ‘tribe-gmaps’ seems to have solved the problem. What features am I losing with that? Is it just the “view as map” view?

    BTW, I modified what was in https://theeventscalendar.com/knowledgebase/troubleshooting-google-maps/#conflicts to the following in my theme’s functions.php file. Seems as if the theme should verify the plugin is active before trying to deregister something, but maybe nothing bad will happen without the check.

    /**
     * Unregisters the Google Maps API script on Events Calendar PRO.
     */
    if ( is_plugin_active('events-calendar-pro/events-calendar-pro.php') ) {
    	add_action( 'wp_print_scripts', 'ecp_remove_google_maps_api', 100 );
    
    	function ecp_remove_google_maps_api() {
    		wp_deregister_script( 'tribe-gmaps' );
    	}
    }
    in reply to: Google Maps API errors with TEC Pro 4.4.30 #1592461
    Lou
    Participant

    Thanks for the pointers to the other errors.

    Yes for this page only is there a way to either disable The Events Calendar Pro or to disable its use of google maps?

    I’m not sure I understand the question, “If yes, maybe you had a custom code snippet in place that needs to be updated for the new way to load assets?” Are you talking about loading the google map? I am loading that directly as you saw. What do you recommend instead?

    Also, please recall this is a new problem with 4.4.30, if that helps.

    in reply to: no calendar display #1556664
    Lou
    Participant

    Heh. I’m the sysop for a digital ocean server.

    I did quick test and updated php memory_limit from 128M (default) to 256M, and it looks like things are ok.

    Not sure why I didn’t think of this.

    Thanks!

    in reply to: no calendar display #1555030
    Lou
    Participant

    I have been hacking away looking at this, and noticed the following

    Added the following to /the-events-calendar/src/Tribe/Templates.php just before return:

                        // which template?
                        $dbg_traceback = wp_debug_backtrace_summary();
                        write_log ("Tribe__Events__Templates::get_current_page_template: template = {$template}\n{$dbg_traceback}");

    I see the following in the log when the page is loaded successfully.

    [17-Jun-2018 19:46:33 UTC] Tribe__Events__Templates::get_current_page_template: template = /var/www/sandbox.steeplechasers.org/wordpress/wp-content/plugins/the-events-calendar/src/views/month.php
    require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/the-events-calendar/src/views/default-template.php'), tribe_get_view, tribe_get_current_template, Tribe__Events__Templates::get_current_page_template
    [17-Jun-2018 19:46:33 UTC] Tribe__Events__Templates::get_current_page_template: template = /var/www/sandbox.steeplechasers.org/wordpress/wp-content/plugins/the-events-calendar/src/views/month.php
    require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/the-events-calendar/src/views/default-template.php'), tribe_get_view, include('/plugins/the-events-calendar/src/views/month.php'), tribe_get_template_part, include('/plugins/the-events-calendar/src/views/month/content.php'), tribe_events_the_header_attributes, tribe_get_current_template, Tribe__Events__Templates::get_current_page_template
    

    I see the following when the page load fails

    [17-Jun-2018 19:10:47 UTC] Tribe__Events__Templates::get_current_page_template: template = /var/www/sandbox.steeplechasers.org/wordpress/wp-content/plugins/the-events-calendar/src/views/month.php
    require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/the-events-calendar/src/views/default-template.php'), tribe_get_view, tribe_get_current_template, Tribe__Events__Templates::get_current_page_template
    

    As you can see, when the page load fails, the second call to Tribe__Events__Templates::get_current_page_template (which dives into month.php) does not get executed.

    Please have your developers look at this and let me know some good places to place additional log traces.

    in reply to: no calendar display #1554551
    Lou
    Participant

    What does plugin-detective do other than disable other plugins? I’ve already done that and it seems like it’s the number of plugins not a specific plugin which seems to be causing this.

    Note as I said the events seem to work when I disable The Events Calendar PRO only.

    Like I said, this doesn’t feel like a plugin incompatibility to me, rather a timing issue.

    Anyway I did run plugin detective and it says the problem is with The Events Calendar Filter Bar. I believe that is because this one was the last one it tried to activate, and again that there are “too many” plugins active.

    I am comfortable debugging from the console, and can learn to debug the PHP if you have suggestions. I think this is something in The Events Calendar because those are the only pages I’ve seen affected by having “too many” plugins.

    BTW, I see uncompleted rendering on https://sandbox.steeplechasers.org/events/community/add as well if too many, with a different threshold than https://sandbox.steeplechasers.org/events

    in reply to: no calendar display #1554262
    Lou
    Participant

    Note also if I have all enabled, then disable The Events Calendar PRO, the problem goes away. So it definitely doesn’t seem like it’s a plugin incompatibility. At least to me it seems like a timing issue within TheEventsCalendar, or possibly WordPress itself. I’m not sure the inner workings on how javascript files get executed.

    Supporting the timing theory, when one particular plugin was deactivated the problem went away for the most part, but appeared occasionally.

    in reply to: no calendar display #1554115
    Lou
    Participant

    I’ve done some experimentation and it seems like the issue happens not because of a specific other plugin, but if there are “too many” other plugins active. E.g., if I disable Yoast SEO the problem goes away, but if I enable Yoast SEO and disable the All-in-One Migration plugins, the problem goes away. With all of those plugins enabled the problem is seen.

    When the problem is seen, for some reason tribe-events-ajax-calendar.js isn’t loading. Scroll down to see the console output for working and failure behaviors.

    If you can’t debug this yourself with a wpress file, please give me guidance.

    I have the following in my .htaccess file and do not see anything in php-error.log:

    # PHP error handling for development servers
    php_flag display_startup_errors on
    php_flag display_errors on
    php_flag html_errors on
    php_flag log_errors on
    php_flag ignore_repeated_errors off
    php_flag ignore_repeated_source off
    php_flag report_memleaks on
    php_flag track_errors on
    php_value docref_root 0
    php_value docref_ext 0
    php_value error_log /var/www/sandbox.steeplechasers.org/logs/php-errors.log
    # [see footnote 3] # php_value error_reporting 999999999
    php_value error_reporting -1
    php_value log_errors_max_len 0

    I have the following in my wp-config.php file:

    // Enable WP_DEBUG mode
    define( 'WP_DEBUG', true );
    
    // Enable Debug logging to the /wp-content/debug.log file
    define( 'WP_DEBUG_LOG', true );
    
    // Disable display of errors and warnings
    define( 'WP_DEBUG_DISPLAY', false );
    @ini_set( 'display_errors', 0 );
    
    // Use dev versions of core JS and CSS files (only needed if you are modifying these core files)
    define( 'SCRIPT_DEBUG', true );
    
    define('SAVEQUERIES', true);
    

    working events calendar console output

    
        JQMIGRATE: Migrate is installed with logging active, version 1.4.1
        2jsapi?ver=9278c226a478eb782512b572b7dbc93e:23 A parser-blocking, cross site (i.e. different eTLD+1) script, https://www.google.com/uds/?file=visualization&v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Cgeochart%2Ctimeline, is invoked via document.write. The network request for this script MAY be blocked by the browser in this or a future page load due to poor network connectivity. If blocked in this page load, it will be confirmed in a subsequent console message. See https://www.chromestatus.com/feature/5718547946799104 for more details.
        google.loader.f @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:23
        P.load @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:30
        google.load @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:18
        (anonymous) @ igsv-gvizcharts.js?ver=9278c226a478eb782512b572b7dbc93e:12
        (anonymous) @ igsv-gvizcharts.js?ver=9278c226a478eb782512b572b7dbc93e:128
        2jsapi?ver=9278c226a478eb782512b572b7dbc93e:23 A parser-blocking, cross site (i.e. different eTLD+1) script, https://www.google.com/uds/api/visualization/1.0/40ff64b1d9d6b3213524485974f36cc0/dygraph,format+en,default+en,ui+en,timeline+en,geochart+en,table+en,gauge+en,annotatedtimeline+en,controls+en,corechart+en,annotationchart+en.I.js, is invoked via document.write. The network request for this script MAY be blocked by the browser in this or a future page load due to poor network connectivity. If blocked in this page load, it will be confirmed in a subsequent console message. See https://www.chromestatus.com/feature/5718547946799104 for more details.
        google.loader.f @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:23
        (anonymous) @ ?file=visualization&v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Cgeochart%2Ctimeline:9
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: Tribe Events JS init, Init Timer started from tribe-events.js."]
        tribe-events.js?ver=4.6.18:70 TEC Debug: Browser and events settings information:
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-pro.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-bar.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-ajax-maps.js successfully loaded"]
    <strong>    tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-ajax-calendar.js successfully loaded, Tribe Events Init finished"]
        tribe-events.js?ver=4.6.18:70 Tribe JS Init Timer: 50.9609375ms</strong>
        util.js:226 Google Maps JavaScript API warning: NoApiKeys https://developers.google.com/maps/documentation/javascript/error-messages#no-api-keys
        Jw.j @ util.js:226
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:159
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:60
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:60
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        Sd @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        Rd.va @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        (anonymous) @ stats.js:1
    

    failure console output

    
        jquery-migrate.js?ver=1.4.1:23 JQMIGRATE: Migrate is installed with logging active, version 1.4.1
        2jsapi?ver=9278c226a478eb782512b572b7dbc93e:23 A parser-blocking, cross site (i.e. different eTLD+1) script, https://www.google.com/uds/?file=visualization&v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Cgeochart%2Ctimeline, is invoked via document.write. The network request for this script MAY be blocked by the browser in this or a future page load due to poor network connectivity. If blocked in this page load, it will be confirmed in a subsequent console message. See https://www.chromestatus.com/feature/5718547946799104 for more details.
        google.loader.f @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:23
        P.load @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:30
        google.load @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:18
        (anonymous) @ igsv-gvizcharts.js?ver=9278c226a478eb782512b572b7dbc93e:12
        (anonymous) @ igsv-gvizcharts.js?ver=9278c226a478eb782512b572b7dbc93e:128
        2jsapi?ver=9278c226a478eb782512b572b7dbc93e:23 A parser-blocking, cross site (i.e. different eTLD+1) script, https://www.google.com/uds/api/visualization/1.0/40ff64b1d9d6b3213524485974f36cc0/dygraph,format+en,default+en,ui+en,timeline+en,geochart+en,table+en,gauge+en,annotatedtimeline+en,controls+en,corechart+en,annotationchart+en.I.js, is invoked via document.write. The network request for this script MAY be blocked by the browser in this or a future page load due to poor network connectivity. If blocked in this page load, it will be confirmed in a subsequent console message. See https://www.chromestatus.com/feature/5718547946799104 for more details.
        google.loader.f @ jsapi?ver=9278c226a478eb782512b572b7dbc93e:23
        (anonymous) @ ?file=visualization&v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Cgeochart%2Ctimeline:9
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: Tribe Events JS init, Init Timer started from tribe-events.js."]
        tribe-events.js?ver=4.6.18:70 TEC Debug: Browser and events settings information:
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-pro.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 (2) ["TEC Debug: bootstrapDatepicker was just initialized in "tribe-events-bar.js" on:", j…y.fn.init]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-bar.js successfully loaded"]
        tribe-events.js?ver=4.6.18:92 ["TEC Debug: tribe-events-ajax-maps.js successfully loaded"]
        util.js:226 Google Maps JavaScript API warning: NoApiKeys https://developers.google.com/maps/documentation/javascript/error-messages#no-api-keys
        Jw.j @ util.js:226
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:159
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:60
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:60
        (anonymous) @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        Sd @ js?ver=9278c226a478eb782512b572b7dbc93e:63
        Rd.va @ js?ver=9278c226a478eb782512b572b7dbc93e:136
        (anonymous) @ stats.js:1
    
    in reply to: no calendar display #1549172
    Lou
    Participant

    The other plugin vendor is also looking at this, even though it seems to happen intermittently when the other plugin is disabled (which I think means their plugin is not the problem). They’ve asked me to make a .wpress file for them which is the format they use to backup the database and all the files, which can be restored using their plugin (All-in-One WP Migration). I can give you access to this file if you’d like to debug locally as well. I have it on a google drive, and could share it with an email address which is on google’s system, if you’d like.

    Note I will be back home and trying to debug this in earnest myself starting Sunday.

    If you want me to share this file (2GB), please supply a gmail/g suite address to share with. This file should not be shared with the world, as it has some private information within.

    in reply to: no calendar display #1548880
    Lou
    Participant

    Sorry for the delay. I am out of town and unable to reproduce until I get
    back. I hope to have something uploaded by Monday.

    Thanks for the help with this one.

    in reply to: no calendar display #1544746
    Lou
    Participant

    hmm, that didn’t format very well with the backticks in the text. If you want I can send these by email, but probably not until I get back from my vacation.

    in reply to: no calendar display #1544745
    Lou
    Participant

    Actually this problem happens occasionally even with the other plugin disabled. Now I think it is some kind of weird timing issue within The Events Calendar. The problem seems to happen at the page https://steeplechasers.org/events/ once in every 10-20 page loads (about).

    Interestingly I am seeing mariadb warnings immediately when the page paints successfully, but NO mariadb warnings when the page doesn’t paint. Or at least not for 20-30 seconds.

    successful page paint (immediate):

    180602 18:45:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTOwp_options(option_name,option_value,autoload) VALUES ('_transient_timeout_3ca87d56d185e548c065e61e68da87e2', '1527983102', 'no') ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload`)
    180602 18:45:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_3ca87d56d185e548c065e61e68da87e2’, ‘a:19:{i:0;O:8:\”stdClass\”:3:{s:2:\”ID\”;s:4:\”6951\”;s:14:\”EventStartDate\”;s:19:\”2018-05-28 08:30:00\”;s:12:\”EventEndDate\”;s:19:\”2018-05-28 10:30:00\”;}i:1;O:8:\”stdClass\”:3:{s:2:\”ID\”;s:4:\”8436\”;s:14:\”EventStartDate\”;s:19:\”2018-05-30 18:30:00\”;s:12:\”EventEndDate\”;s:19:\”2018-05-30 20:00:00\”;}i:2;O:8:\”stdClass\”:3:{s:2:\”ID\”;s:4:\”8398\”;s:14:\”EventStartDate\”;s:19:\”2018-05-31 17:00:00\”;s:12:\”EventEndDate\”;s:19:\”2018-05-31 20:00:00\”;}i:3;O:8:\”stdClass\”:3:{s:2:\”ID\”;s:4:\”8251\”;s:14:\”EventStartDate\”;s:19:\”2018-06-02 09:30:00\”;s:12:\”EventEndDate\”;s:19:\”2018-06-02 11:00:00\”;}i:4;O:8:\”stdClass\”:3:{s:2:\”ID\”;s:4:\”8255\”;s:14:\”EventStartDate\”;s:19:\”2018-
    180602 18:45:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_0a7a47111add6ac45e62a391f18ac748’, ‘1527983102’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)
    180602 18:45:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_0a7a47111add6ac45e62a391f18ac748’, ‘<script type=\”application/ld+json\”>\r\n[{\”@context\”:\”http://schema.org\”,\”@type\”:\”Event\”,\”name\”:\”Parkway Panda 5K\”,\”description\”:\”<p>ALL PROCEEDS TO BENEFIT PARKWAY ELEMENTARY\\\\\’S PTA Register by\\u00a0May 3rd\\u00a0to get T-shirt 5k: $20.00 per person on or before\\u00a0May 18, 2018. (Maximum: $75.00 per family) $25.00 per person thereafter or on race day (T-Shirt not included)  </p>\\\\n\”,\”url\”:\”https://steeplechasers.org/events/parkway-panda-5k-2018/\”,\”startDate\”:\”2018-05-28T08:30:00-04:00\”,\”endDate\”:\”2018-05-28T10:30:00-04:00\”,\”location\”:{\”@type\”:\”Place\”,\”name\”:\”Baker Park\”,\”description\”:\”<p>USATF Course Certification Map:
    180602 18:45:03 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_fe3701ddb17a4247f4f0c8bb00ca7249’, ‘1527983103’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)
    180602 18:45:03 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_fe3701ddb17a4247f4f0c8bb00ca7249’, ‘\n<div id=\”tribe-events-content\” class=\”tribe-events-month\”>\n\n <!– Month Title –>\n <h2 class=\”tribe-events-page-title\”>Events for June 2018</h2>\n \n <!– Notices –>\n \n <!– Month Header –>\n <div id=\”tribe-events-header\” data-title=\”Events Archive – Frederick Steeplechasers Running Club\” data-view=\”month\” data-date=\”2018-06\” data-baseurl=\”https://steeplechasers.org/events/month/\” data-redirected-view=\”\” data-default-mobile-view=\”month\” data-default-view=\”month\”>\n\n <!– Header Navigation –>\n \n\n<h3 class=\”screen-reader-text\” tabindex=\”0\”>Calendar Month Navigation</h3>\n\n<ul class=\”tribe-events-sub-nav\”>\n <li class=\”tribe-events-nav-previous\” a`

    page doesn’t paint (this is delayed 20-30 seconds and seems to repeat periodically):

    180602 18:49:09 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTOwp_options(option_name,option_value,autoload) VALUES ('_transient_timeout_slideshow-css-gallery162', '1527980748', 'no') ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload`)
    180602 18:49:09 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT… ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_slideshow-css-gallery162’, ‘s:586:\”a:19:{s:6:\”layout\”;s:10:\”responsive\”;s:9:\”resheight\”;s:2:\”30\”;s:13:\”resheighttype\”;s:1:\”%\”;s:12:\”resizeimages\”;s:1:\”Y\”;s:5:\”width\”;s:3:\”450\”;s:6:\”height\”;s:3:\”250\”;s:6:\”border\”;s:17:\”1px solid #CCCCCC\”;s:10:\”background\”;s:7:\”#000000\”;s:14:\”infobackground\”;s:7:\”#000000\”;s:9:\”infocolor\”;s:7:\”#ffffff\”;s:11:\”thumbactive\”;s:0:\”\”;s:6:\”unique\”;s:10:\”gallery162\”;s:9:\”wrapperid\”;s:27:\”slideshow-wrappergallery162\”;s:10:\”autoheight\”;s:5:\”false\”;s:10:\”thumbwidth\”;s:3:\”100\”;s:11:\”thumbheight\”;s:2:\”75\”;s:11:\”sliderwidth\”;i:5610;s:16:\”infohideonmobile\”;s:1:\”1\”;s:17:\”thumbhideonmobile\”;s:1:\”1\”;}\”;’, ‘no’) ON DUPLICATE KEY UPDATE optio

Viewing 15 posts - 1 through 15 (of 43 total)