Announcement

Collapse
No announcement yet.

english language phrase won't restore

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

  • [Forum] english language phrase won't restore

    hello
    i upgraded from 3.8 to 4.1 yesterday
    i forgot to delete my arabic language first
    after upgrade the Arabic is the only one language stayed
    no English
    tried to restore it by tools.php and creat empty language names en
    but still with the Arabic phrase
    i tried to install any language instead but also it installed with the arabic phrase too
    what can i do ?

  • #2
    Try this. Reupload the original vbulletin-language.xml file to the install directory. Then upload the tools.php script in the 'do_not_upload' folder of the vB zip file to your Admin CP directory and run it from your browser. Then reimport the vbulletin-language.xml file. Immediately remove tools.php when you are done.

    Then run this in the Admin CP:

    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


    • #3
      Originally posted by Steve Machol View Post
      Try this. Reupload the original vbulletin-language.xml file to the install directory. Then upload the tools.php script in the 'do_not_upload' folder of the vB zip file to your Admin CP directory and run it from your browser. Then reimport the vbulletin-language.xml file. Immediately remove tools.php when you are done.

      Then run this in the Admin CP:

      Admin CP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]
      that's what i did already
      tried to restore it by tools.php and creat empty language names en
      but still with the Arabic phrase

      Comment


      • #4
        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


        • #5
          thank you
          i did that and got this message
          #1146 - Table 'mysite_DB.phrase' doesn't exist

          Comment


          • #6
            You need to edit that query with the appropriate table prefix you are using for your database.
            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


            • #7
              what ?
              table prefix ?
              what that table ?
              which part ?
              my database name is like this
              mysite_vb

              Comment


              • #8
                What do you have set for the table prefix in your vB config.php file?
                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


                • #9
                  databa_vbaccsess

                  Comment


                  • #10
                    That is your table prefix? What is the complete line?
                    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


                    • #11
                      $config['Database']['tableprefix'] = 'databa_vb';

                      Comment


                      • #12
                        Then the queries would be:

                        For MySQL 4.0.x use this query:

                        DELETE
                        FROM databa_vbphrase
                        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 databa_vbphrase 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;
                        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


                        • #13
                          the same message
                          #1146 - Table 'databa_vb.phrase' doesn't exist
                          did you mean
                          DELETE
                          FROM databa_vbphrase AS p1
                          USING databa_vbphrase 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;

                          MySQL version 5.0.90

                          Comment


                          • #14
                            Originally posted by Steve Machol View Post
                            DELETE
                            FROM databa_vbphrase 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;
                            There's no "." in the able name that Steve provided. Please run the above query.
                            Andrew Elkins
                            Former vBulletin Developer

                            Please do not PM me for support, please use the support system.

                            #1 rule before doing anything to a live site, Backup, Test and Re-Test.

                            Comment


                            • #15
                              Originally posted by Andrew Elkins View Post
                              There's no "." in the able name that Steve provided. Please run the above query.
                              i can't reach you
                              what is the "." mean
                              and where is the above queries ?
                              i see its all the same queries

                              Comment

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