Error when updating wp_revslider_static_slides

  • Resolved newwithtags

    (@newwithtags)


    4 years, 2 months ago

    Hello, Jakub,

    Congratulations, this plugin is very straightforward and performs lovely, even when analysing +55.000 images.
    I have noticed the following error in the wp-admin error log:

    [24-Mar-2022 00:32:37 UTC] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' for query 
					UPDATE wp_revslider_static_slides 
					SET layers = REPLACE( layers, '/poveștile-bucureștiului-curs-în-4-întâlniri-550x468.png', '/poveștile-bucureștiului-curs-în-4-întâlniri-550x468.jpg') 
					WHERE layers LIKE '%/poveștile-bucureștiului-curs-în-4-întâlniri-550x468.png%'
				 made by do_action('wp_ajax_convert_old_png'), WP_Hook->do_action, WP_Hook->apply_filters, png_to_jpg->convert_old_png, png_to_jpg->update_image_data

    While I don’t think this error is an issue for us, as I’m converting old images that are no longer used in the revolution slider, perhaps you want to know about it.

    Kind regards,
    Cristina.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author kubiq

    (@kubiq)

    4 years, 2 months ago

    Hello,

    thank you,

    this error can not appear on new installations, but old WordPress versions allow you to upload files with accent characters in filenames – this was causing a lot of problems also during migration, but also for optimization plugins…

    If more people will report some problems connected with this, then I will maybe invest some time to solve this, but right now I’m very busy, so solving some old problems caused by old WP uploads is not my priority

    Thanks and have a nice day 😉
    JN

    Thread Starter newwithtags

    (@newwithtags)

    4 years, 2 months ago

    Hello, JN,

    Thank you for taking the time to explain the issue which is causing the error.
    I understand, and it is also not a problem for me at this point.
    Once again, congratulations and thank you for a super-efficient plugin.

    Kind regards,
    Cristina.

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

The topic ‘Error when updating wp_revslider_static_slides’ is closed to new replies.