Announcement

Collapse
No announcement yet.

New language pack overwriting my english phrases

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

  • #31
    maybe late?

    how about 3 years ..

    Bumping old threads is like writing in capslock.

    Comment


    • #32
      what a funny situation I find myself in now.

      Even re-importing vbulletin's native file is not adding the english language (\vbforum_4_4-0-7_VBF0EB12B0\upload\install\vbulletin-language.xml)


      Anybody found a solution ?

      I tried everything obvious, including deleting the english language and try to re-import it .......

      deleting any other language

      none worked.

      please help
      .

      Comment


      • #33
        Which language pack was this?

        To fix this, try running one of these queries:

        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;


        Or for MySQL 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:

        Admin CP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #34
          I tried this one:
          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

          But got 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 'AS p1 USING phrase AS p1 LEFT JOIN phrase AS p2 ON (p1.varname = p2.varname AND ' at line 1

          I run the following versions:
          • Apache/2.2.21 (Win64) PHP/5.3.8
          • MySQL klientversion: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $

          Comment

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