Russian Language not working / Cant add Query to the phpmyAdmin

  • Resolved Vmialik

    (@vmialik)


    11 years, 5 months ago

    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.

    ALTER TABLE ‘DATABASEPREFIX’_topbar_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

    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.

    https://www.ads-software.com/plugins/wp-topbar/

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

    (@rfgoetz)

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

    Bob

    Thread Starter Vmialik

    (@vmialik)

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

    Another concern right now rgtsf.org shows english notification and rgtsf.org/ru shows the Russian. Can I make it so that any page on rgtsf.org/ru/… 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 rfgoetz

    (@rfgoetz)

    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”

    Bob

    Thread Starter Vmialik

    (@vmialik)

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

    Plugin Author rfgoetz

    (@rfgoetz)

    Maybe this will work?

    https://www.ads-software.com/plugins/ninja-page-categories-and-tags/

    Thread Starter Vmialik

    (@vmialik)

    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.