Support » Plugin: WP-TopBar » Russian Language not working / Cant add Query to the phpmyAdmin

  • Resolved Vmialik


    My TopBar does not support my local language

    So I tried to add this:

    The problem is with your table collation. You need to change the collation to utf8_general_ci.

    Run this query from your phpMyAdmin to change the collation.


    Of course, make a backup of your table first!

    Get this error:

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”DATABASEPREFIX’_topbar_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_’ at line 1

    Whats up? Maybe I need to run this in specific SQL table or what? I am in the right database.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Bob


    Change the word “DATABASEPREFIX” with the database prefix in wp-config.php


    Great I thought that might be it, but I wanted to check thanks for a quick reply Bob.

    Another concern right now shows english notification and shows the Russian. Can I make it so that any page on… would show one notification ie russian for all the pages under that directory. Otherwise I have to do it manually for each page and this is not sustainable thanks

    Plugin Author Bob


    You can use the “Category ID” option on the Control tab to include/exclude based on Category.

    Create a new Category called “Russian”.
    Assign the new “Russian” category to every page and post that is in Russian.

    For each TopBar, on the Control Tab:

    Set those that are in Russian to be “include”
    Set those that are not in Russian (English?) to “exclude”


    Ok i see so I can do that for posts, but for pages I would have to manually add them correct?

    Plugin Author Bob


    Yea thats an option thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Russian Language not working / Cant add Query to the phpmyAdmin’ is closed to new replies.