We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 38058
    • 25 Posts
    I wanted to have two projects to work on so in the wamp www. I made a new folder in that folder I put the modx files and folders in it. I went through the database process having a different database with a different name and log in info. When I go through the setup and add in the connection information I get this. I am connected to the database just fine. When I click on (Create or test selection of your database) I get (Checking database: Table prefix is already in use in this database ) I have done this before but it worked and I don't remember what I did different the first time.

    Thanks

    Rocky
      • 3749
      • 24,544 Posts
      If you copied the config file, it would have the connection to the other DB in it unless you edited it.



      ---------------------------------------------------------------------------------------------------------------
      PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
      MODx info for everyone: http://bobsguides.com/modx.html
        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 38058
        • 25 Posts
        which config file and where is it?

        Thanks

        Rocky
          • 3749
          • 24,544 Posts
          ---------------------------------------------------------------------------------------------------------------
          PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
          MODx info for everyone: http://bobsguides.com/modx.html
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting
            • 38058
            • 25 Posts
            The new one revolution 2.2
              • 3749
              • 24,544 Posts
              In Revolution, the file is core/config/config.inc.php


              ---------------------------------------------------------------------------------------------------------------
              PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
              MODx info for everyone: http://bobsguides.com/modx.html
                Did I help you? Buy me a beer
                Get my Book: MODX:The Official Guide
                MODX info for everyone: http://bobsguides.com/modx.html
                My MODX Extras
                Bob's Guides is now hosted at A2 MODX Hosting
                • 38058
                • 25 Posts
                the table prefix for the one project is modx_ so what should the other one be and how do I change it.
                  • 3749
                  • 24,544 Posts
                  It's fine if they have the same table prefix, as long as the database name is different for each one.

                  Your post says that you created new database name for the second project, in which case all you have to do is change the database name in the config file for the second project to the name of its DB and run setup again on the second project. But it will do a new install and won't contain any work you did on the first project.

                  Does everything in your first project look OK? It should have done an upgrade install, so most of it should be fine although changes you made to policies and permissions might have been reverted depending on how you did them.

                  You'll need to explain more about what you're trying to do before I can advise you further. Do you want to copy all the work you did on the first project into the second one before working on it? Or do you just want a second, clean install of MODX?


                  ---------------------------------------------------------------------------------------------------------------
                  PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
                  MODx info for everyone: http://bobsguides.com/modx.html [ed. note: BobRay last edited this post 14 years, 8 months ago.]
                    Did I help you? Buy me a beer
                    Get my Book: MODX:The Official Guide
                    MODX info for everyone: http://bobsguides.com/modx.html
                    My MODX Extras
                    Bob's Guides is now hosted at A2 MODX Hosting
                    • 38058
                    • 25 Posts
                    I am starting over from scratch with both projects I decided to go through all the tutorials and make sure I was doing everything right and I want to use a different template then before. I have two db's with different names different ID's and passwords. The first one worked as usual but the second one stops at Create or test selection of your database. At that point it says Table prefix is already in use in this database. It doesn't finish so there isn't a file called config.inc.php only a gitignore. I have done a clean install of Modx 2.2 [ed. note: climberman last edited this post 14 years, 8 months ago.]
                      • 3749
                      • 24,544 Posts
                      OK. You only need to work on the second one then.

                      Here's what I think is happening, BTW. The config.core.php files in the second site are still pointing to the other site, so you're running the second site on the first site's core. The fact that there's no config file in the second site tells MODX that it's a new install, but somewhere along the line, it's loading the config.inc.php file from the first site -- which is pointing at the first site's db, which already has stuff in, it so MODX is aborting the install.

                      Since you're doing a clean install. I would start over and delete all the files in the second site. Then put the files there from the MODX .zip file rather than from the first site.

                      Then look in the DB of the second site in PhpMyAdmin and see if there are tables there (there shouldn't be). If so, drop them all (leaving the DB there). Be absolutely sure that you're in the right DB when you do this.

                      Setup should then work on the second site if you have the credentials right.

                      If you have trouble, you might have to create an empty core/config/config.inc.php file for the second site, but probably not.

                      The moral is that if you want a clean install of MODX, always use the files from the MODX .zip download rather than those from another site. smiley



                      ---------------------------------------------------------------------------------------------------------------
                      PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
                      MODx info for everyone: http://bobsguides.com/modx.html
                        Did I help you? Buy me a beer
                        Get my Book: MODX:The Official Guide
                        MODX info for everyone: http://bobsguides.com/modx.html
                        My MODX Extras
                        Bob's Guides is now hosted at A2 MODX Hosting