error on php log

  • Resolved jorgitobg

    (@jorgitobg)


    9 years, 3 months ago

    Hi,

    Im receiving plenty of errors on php.log from pretty link plugin:

    ———————————————-
    Aug 26 01:58:15 blanca.wsynth.net ool www: Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT * FROM wp333_prli_links WHERE slug=’mensaje-de-mer?????ousa-gramuglia’ realizada por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, prli_redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug
    Aug 26 02:28:06 blanca.wsynth.net ool www: Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT * FROM wp333_prli_links WHERE slug=’meditacion-equinocio-de-septiembre?????’ realizada por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, prli_redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug
    ———————————————-

    Any idea how to fix this? is flooding my database.

    Regards

    https://www.ads-software.com/plugins/pretty-link/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author cartpauj

    (@cartpauj)

    You may need to alter your tables so they are using the same collation

    alter table <some_table> convert to character set utf8 collate <some_character_set>;

    Thread Starter jorgitobg

    (@jorgitobg)

    Hi Cartpauj,

    Thanks for your answer.

    Im afraid I have to ask my hosting first.

    Regards,

    I am getting the same error log message. Can you advise exactly how to alter tables? Thanks

    Plugin Author cartpauj

    (@cartpauj)

    I would recommend having your host help you as well. Give them this query as a starting point though.

    alter table <some_table> convert to character set utf8 collate <some_character_set>;

    The parts in <>’s need to be changed to reflect your actual setup.

    Thread Starter jorgitobg

    (@jorgitobg)

    Hi,

    I try to alter al pri tables, but still same errors.. this is the used SQL:

    alter table wp333_prli_clicks convert to character set utf8 collate utf8_general_ci;

    This is the table config:

    ———————————————-
    wp333_prli_clicks 1,424 InnoDB utf8_general_ci 1.5 MB
    wp333_prli_groups 5 InnoDB utf8_general_ci 32 KB
    wp333_prli_links 9 InnoDB utf8_general_ci 144 KB
    wp333_prli_link_metas 0 InnoDB utf8_general_ci 48 KB
    ———————————————-

    Any idea what is wrong?

    Regards,

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘error on php log’ is closed to new replies.