• Skip to main content
  • Skip to forum navigation

StudioPress

  • Shop for Themes
  • My StudioPress

Forum navigation

  • Home
  • General Genesis Discussions
  • StudioPress Themes
  • Genesis Blocks
    • Genesis Blocks
    • Genesis Custom Blocks
  • Retired Themes
  • FAQs
  • Forum Rules
  • Internationalization and Translations
  • Forum Bugs and Suggestions
  • Forum Log In

Are You Using The WordPress Block Editor?

Genesis now offers plugins that help you build better sites faster with the WordPress block editor (Gutenberg). Try the feature-rich free versions of each plugin for yourself!

Genesis Blocks Genesis Custom Blocks

WP Database Error

Welcome!

These forums are for general discussion on WordPress and Genesis. Official support for StudioPress themes is offered exclusively at My StudioPress. Responses in this forum are not guaranteed. Please note that this forum will require a new username, separate from the one used for My.StudioPress.

Log In
Register Lost Password

Community Forums › Forums › Archived Forums › General Discussion › WP Database Error

This topic is: not resolved

Tagged: WP Database Error

  • This topic has 4 replies, 3 voices, and was last updated 7 years, 12 months ago by milada.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • May 22, 2017 at 7:51 am #206834
    milada
    Member

    Hallo all,

    when posting a post (in private) in Czech, I got this:

    Chyba databáze WordPressu: [Illegal mix of collations for operation ' IN ']
    SELECT target.post_id, sum(target.weight * log(85 / least(85, freqs.freq))) as score FROM wp_xixe_wp_rp_tags as target, (SELECT label, count(1) as freq FROM wp_xixe_wp_rp_tags WHERE label IN ('C_recepty', 'C_Šťávy', 'A_vera', 'A_chia', 'A_alo', 'A_96', 'A_pro', 'A_vu', 'A_va', 'A_cca', 'A_dal', 'A_ji', 'A_gel', 'A_ml', 'A_al', 'A_a', 'A_se') GROUP BY label ) as freqs WHERE target.post_id NOT IN ('5827') AND target.label=freqs.label AND target.label IN ('C_recepty', 'C_Šťávy', 'A_vera', 'A_chia', 'A_alo', 'A_96', 'A_pro', 'A_vu', 'A_va', 'A_cca', 'A_dal', 'A_ji', 'A_gel', 'A_ml', 'A_al', 'A_a', 'A_se') GROUP BY target.post_id ORDER BY score desc, target.post_id desc LIMIT 12;

    at the top of the page when viewing the post on web.
    Both C_recepty', 'C_Šťávy' refer to categories, under which this post is published.
    I was told to remove the special characters to change it to "Stavy", but I already have some posts under "Šťávy" and this is the first time this error message appears.
    Do you have an idea how to get rid of this?
    Thank you very much in advance!

    Milada

    http://moreyouthfulskin.com/cs/stava-zariva-plet/
    May 22, 2017 at 7:57 am #206836
    Victor Font
    Moderator

    You need to use the same collation for all of your tables in the database. If you have access to PHPMyAdmin, you'll be able to fix this. If not, you should open a support ticket with your host. This is not something we can help you with. It has nothing to do with Genesis or Studio Press themes.


    Regards,

    Victor
    https://victorfont.com/
    Call us toll free: 844-VIC-FONT (842-3668)
    Have you requested your free website audit yet?

    May 22, 2017 at 8:16 am #206838
    milada
    Member

    Thank you for your prompt reply and information,

    Milada

    May 24, 2017 at 6:28 am #206918
    rahul3414
    Member

    can you try wp optimize plugins ?
    banglarmukh

    May 24, 2017 at 8:01 am #206921
    milada
    Member

    thank you for your reply, I have hired a developer,

    Milad

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • The forum ‘General Discussion’ is closed to new topics and replies.

CTA

Ready to get started? Create a site or shop for themes.

Create a site with WP EngineShop for Themes

Footer

StudioPress

© 2025 WPEngine, Inc.

Products
  • Create a Site with WP Engine
  • Shop for Themes
  • Theme Features
  • Get Started
  • Showcase
Company
  • Brand Assets
  • Terms of Service
  • Accptable Usse Policy
  • Privacy Policy
  • Refund Policy
  • Contact Us
Community
  • Find Developers
  • Forums
  • Facebook Group
  • #GenesisWP
  • Showcase
Resources
  • StudioPress Blog
  • Help & Documentation
  • FAQs
  • Code Snippets
  • Affiliates
Connect
  • StudioPress Live
  • StudioPress FM
  • Facebook
  • Twitter
  • Dribbble