Move topics and members from an old forum to a new forum

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ABDUR7MAAN
    Senior Member
    • Sep 2013
    • 139
    • 5.3.x

    Move topics and members from an old forum to a new forum

    Good evening
    How are you doing
    I have a forum where there are no posts, no sections, no new members
    I want to transfer to him the sections and topics and replies and members and groups of members of another forum
    What are the tables responsible for this
    The two forums are working on the vb5
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    You cannot just move tables from one database to another and expect vBulletin to work. Many tables rely on records in other tables and your indexes will not line up.

    If you have a site with no forums, posts, or members then you should just copy the entire database and modify it to fit the new site.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • ABDUR7MAAN
      Senior Member
      • Sep 2013
      • 139
      • 5.3.x

      #3
      Originally posted by Wayne Luke
      You cannot just move tables from one database to another and expect vBulletin to work. Many tables rely on records in other tables and your indexes will not line up.

      If you have a site with no forums, posts, or members then you should just copy the entire database and modify it to fit the new site.

      The reason for my desire to do this is that when I upgrade from the 4vb or vb3, even after changing the encoding to utf-8, a lot of menus and phrases appear in symbols

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73976

        #4
        copying content from one database to another isn't going to resolve that issue. What locale are you using? If you are using Arabic, you need to use UTF-8. Not Windows-1256, or ISO-8859-1. UTF-8.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • ABDUR7MAAN
          Senior Member
          • Sep 2013
          • 139
          • 5.3.x

          #5
          The language used Arabic
          Base encoding before upgrade utf8

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73976

            #6
            And the locale of your language in the AdminCP?
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • ABDUR7MAAN
              ABDUR7MAAN commented
              Editing a comment
              I will give you a detailed picture of the problem when I return home

            • Wayne Luke
              Wayne Luke commented
              Editing a comment
              Don't need a picture. Rarely do customers submit images that show a detailed picture of their problem. They are cropped and don't show the information that we ask for. Pictures are not good for troubleshooting.

              Answering my question is good for troubleshooting.

              What is the value of the LOCALE field in your AdminCP for your Language?
          • ABDUR7MAAN
            Senior Member
            • Sep 2013
            • 139
            • 5.3.x

            #7
            I do not know what happened (LOCALE)
            But the default language for the site is Arabic and a control panel that works in Arabic
            Pictures of the problem :
            Click image for larger version

Name:	33432242.PNG
Views:	167
Size:	58.8 KB
ID:	4391824
            Click image for larger version

Name:	5454353543.PNG
Views:	65
Size:	69.0 KB
ID:	4391825

            The Arabic language file has been tested on a new forum and the language works well and does not show these symbols

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73976

              #8
              Like I said above. Images provided tell me nothing about how to solve your problem. They just show the problem. One I am actually quite familiar with.

              You need to edit your language in the AdminCP and tell my what the value for LOCALE is. Until you do that, there is absolutely no way to help you.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • ABDUR7MAAN
                Senior Member
                • Sep 2013
                • 139
                • 5.3.x

                #9
                Originally posted by Wayne Luke
                Like I said above. Images provided tell me nothing about how to solve your problem. They just show the problem. One I am actually quite familiar with.

                You need to edit your language in the AdminCP and tell my what the value for LOCALE is. Until you do that, there is absolutely no way to help you.
                Where do I find value for LOCALE?
                So I can provide them for you

                Comment

                • Wayne Luke
                  vBulletin Technical Support Lead
                  • Aug 2000
                  • 73976

                  #10
                  In the AdminCP by eding your ARABIC language under Languages & Phrases.

                  This isn't a new issue of yours. I have been asking for the character set and locale of your Arabic language for months and you keep giving images that don't help then going on tirades because you don't get the support you're asking for.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment

                  • ABDUR7MAAN
                    Senior Member
                    • Sep 2013
                    • 139
                    • 5.3.x

                    #11
                    I do not know why you get annoyed and complain when I ask for a problem and I want to solve it ...

                    The option you requested has no empty values

                    Click image for larger version

Name:	45354335.PNG
Views:	149
Size:	16.7 KB
ID:	4391834

                    Comment

                    • Wayne Luke
                      vBulletin Technical Support Lead
                      • Aug 2000
                      • 73976

                      #12
                      As stated before to use Arabic with vBulletin 5, you need to use a Locale for Arabic with UTF-8. https://docs.oracle.com/cd/E23824_01...033/glset.html

                      You need to use a UTF-8 Character set on the language.

                      It is annoying asking the same question over and over again and getting ignored while you complain about not getting support in my private message box and tickets. Once the questions are answered, we can provide support.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API

                      Comment

                      • ABDUR7MAAN
                        Senior Member
                        • Sep 2013
                        • 139
                        • 5.3.x

                        #13
                        The forum is encoded by utf-8
                        The UTF-8 language file is also available


                        Since you are the one who programmed the script that you must have knowledge
                        That vbulletin5 does not use utf-8 encoding, it uses another encoding (utf8mb4_general_ci).
                        This is the cause of the problem if on your words it is used (utf-8) these symbols do not appear.

                        The problem is an encoding incompatibility utf-8 with an encoding utf8mb4_general_ci

                        Comment

                        • Wayne Luke
                          vBulletin Technical Support Lead
                          • Aug 2000
                          • 73976

                          #14
                          I don't care what your database settings are right now. Every single MYSQL database uses UTF-8 to store the data. The Character Set and Collation are how it presents that data in queries and how it sorts the data. They have nothing to do with how it is actually stored.

                          The settings I am talking about are in vBulletin and unless you change them, you will never get Arabic working on your site. Yes, I know the programming. Yes, I know how to fix the issues. I simply don't know how to help you because you don't listen to me. At this point, you will be better off reverting to your older version of vBulletin and using it. I simply can't help you with this issue.
                          Translations provided by Google.

                          Wayne Luke
                          The Rabid Badger - a vBulletin Cloud demonstration site.
                          vBulletin 5 API

                          Comment

                          • ABDUR7MAAN
                            Senior Member
                            • Sep 2013
                            • 139
                            • 5.3.x

                            #15
                            Originally posted by Wayne Luke
                            I don't care what your database settings are right now. Every single MYSQL database uses UTF-8 to store the data. The Character Set and Collation are how it presents that data in queries and how it sorts the data. They have nothing to do with how it is actually stored.

                            The settings I am talking about are in vBulletin and unless you change them, you will never get Arabic working on your site. Yes, I know the programming. Yes, I know how to fix the issues. I simply don't know how to help you because you don't listen to me. At this point, you will be better off reverting to your older version of vBulletin and using it. I simply can't help you with this issue.

                            You asked me to convert the database encoding to UTF8 before the upgrade process
                            And use a file for Arabic language encoded UTF8
                            All these actions are done as you requested
                            However, the problem is still ongoing
                            This only has one explanation that the program does not handle well with the codec UTF8 .

                            Comment

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