Announcement

Collapse
No announcement yet.

Where did this come from

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Where did this come from

    I use other languages.

    Sometimes the master phrase is in another language, though i have never changed.

    I have imported several languages from this site. Could these have brought in those changes to the master language ?

    Can i reset the master language ?
    Vote for these issues:

  • #2
    Sometimes languages enter phrases into the languageid 0, which is valued higher than languageid 0.

    Try this. Run this query:

    So for MySQL 4.0.x use this query:

    DELETE
    FROM phrase
    USING phrase AS p1
    LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
    AND p2.languageid = -1 )
    WHERE p1.languageid =0
    AND p2.languageid IS NOT NULL;

    And for 4.1.x and higher, use this query:

    DELETE
    FROM phrase AS p1
    USING phrase AS p1
    LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
    AND p2.languageid = -1 )
    WHERE p1.languageid =0
    AND p2.languageid IS NOT NULL;

    Then run this now:

    AdminCP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Thanks.

      The Run My SQL query on the vB Admin Panel did not let me run the query.

      I am faily new to this sort of thing. (I think) i managed to run a query from PHPMyAdmin and got
      Deleted rows: 476 (Query took 0.1936 sec)
      Vote for these issues:

      Comment


      • #4
        Well i am still seeing master language phrases in other languages
        Vote for these issues:

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X