Title: error on php log
Last modified: August 30, 2016

---

# error on php log

 *  Resolved [jorgitobg](https://wordpress.org/support/users/jorgitobg/)
 * (@jorgitobg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/)
 * 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://wordpress.org/plugins/pretty-link/](https://wordpress.org/plugins/pretty-link/)

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

 *  Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/)
 * (@cartpauj)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477861)
 * 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](https://wordpress.org/support/users/jorgitobg/)
 * (@jorgitobg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477862)
 * Hi Cartpauj,
 * Thanks for your answer.
 * Im afraid I have to ask my hosting first.
 * Regards,
 *  [hilmil](https://wordpress.org/support/users/hilmil/)
 * (@hilmil)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477903)
 * I am getting the same error log message. Can you advise exactly how to alter 
   tables? Thanks
 *  Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/)
 * (@cartpauj)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477904)
 * 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](https://wordpress.org/support/users/jorgitobg/)
 * (@jorgitobg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477912)
 * 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.

 * ![](https://ps.w.org/pretty-link/assets/icon-256x256.png?rev=2503434)
 * [PrettyLinks - Affiliate Links, Link Branding, Link Tracking, Marketing and Stripe Payments Plugin](https://wordpress.org/plugins/pretty-link/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pretty-link/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pretty-link/)
 * [Active Topics](https://wordpress.org/support/plugin/pretty-link/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pretty-link/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pretty-link/reviews/)

## Tags

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

 * 5 replies
 * 3 participants
 * Last reply from: [jorgitobg](https://wordpress.org/support/users/jorgitobg/)
 * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/error-on-php-log/#post-6477912)
 * Status: resolved