MYSQL ERROR 1267

  • Resolved m0r0mete

    (@m0r0mete)


    1 year, 10 months ago

    Hi. I suddenly have an mysql error:

    ERROR: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation ‘=’

    CALLER: SELECT IFNULL(zone_name,’Other Zones’)zone,method_id,instance_id ,IFNULL((SELECT option_value
    FROM wpyg_options o
    WHERE o.option_name LIKE ‘woocommerce_f%settings’
    AND o.option_name=CONCAT(‘woocommerce_’,m.method_id,’_’,m.instance_id,’_settings’)),’a:1:{s:5:”title”;s:7:”Default”;}’)meta
    FROM wpyg_woocommerce_shipping_zone_methods m
    LEFT JOIN wpyg_woocommerce_shipping_zones z
    ON m.zone_id=z.zone_id
    ORDER BY z.zone_order, m.method_order;

    Your plugin worked fine a couple of days ago when I installed and then it stopped working. It was prior to the latest update so it’s not related to this.

    • This topic was modified 1 year, 10 months ago by m0r0mete.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author rerm

    (@rermis)

    Hi @m0r0mete,

    Thank you for reporting this sql error. I have been unable to replicate, but can you provide the MySQL version your site is on? It can be found under…

    WooCommerce > Status > Server Environment

    I look forward to resolving this for you.

    Thread Starter m0r0mete

    (@m0r0mete)

    MySQL version:5.5.5-10.5.18-MariaDB-cll-lve

    Plugin Author rerm

    (@rermis)

    Hi @m0r0mete,

    I believe this might be fixed in version 1.4.12 released just now. Ship method retrieval in admin settings was updated to avoid collation conflicts.

    If this does not resolve your issue please respond here to let us know.

    Thank you!

    Thread Starter m0r0mete

    (@m0r0mete)

    Hi Rerm. Yes, the mysql error is gone now but there is another issue. Prior to the mysql error, the shipping estimate date was displayed in the cart page and checkout page. Now it doesn’t show anywhere. Did not tested in emails.

    Plugin Author rerm

    (@rermis)

    Hi @m0r0mete

    The last update contained a single change, and that was to this query that only runs on the admin settings page. Can you check that the plugin settings populate correctly (and shipping method dropdown loads for each method)? The query populates these dropdowns.

    If the plugin settings were saved before this update when the dropdowns could not populate, the methods potentially could have been disassociated from the rules. To fix this, return to settings, verify each method, and resave.

    Thread Starter m0r0mete

    (@m0r0mete)

    Yes, it’s working now. Was actually my fault, a css issue. One suggestion. It would be nice if there were an option or shortcode to use on product page, something like “Order today and get it by ….” This should be displayed under the add to cart button.

    Thanks for your help.

    Plugin Author rerm

    (@rermis)

    Hi @m0r0mete,

    Great to hear it is resolved.

    I appreciate the recommendation for supporting estimates on the product page. This feature has been requested by others, so the good news is it will likely get added to a list of upcoming features. The exact logic is still to be scoped.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘MYSQL ERROR 1267’ is closed to new replies.