We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

data is showing in database but not showing in manager & on the site

    • 4310
    • 2,310 Posts
    bunk58 Reply #11, 17 years, 6 months ago
    Which database Modx uses is defined in the first few lines of =>
    manager/includes/config.inc.php
    $database_type = 'mysql';
$database_server = 'localhost';
$database_user = 'my-username';
$database_password = 'my_password';
$database_connection_charset = '';
$dbase = '`my_db`';
$table_prefix = 'modx_';

    If you didn’t change the database info there, then maybe your still using the old database.
      • 26903
      • 1,336 Posts
      shamblett Reply #12, 17 years, 6 months ago
      Ok, it looks like the database ’rallyday_modx’ is the one MODx is talking to if indeed the lines you posted are in the config.inc.php MODx is using , but the one you are looking at doesn’t seem to be that one, or you’d see your new document, what tool do you use to ’look at’ your database? Also what control panel are you using?
        Use MODx, or the cat gets it!
        • 14153
        • 10 Posts
        Jily Reply #13, 17 years, 6 months ago
        Ups I did, and now I see what the mistake is.

        The content from the old server is in a table called: modx_site_content, and the new content is in site_content table. So I actualy have everything in the same database, just in different tables. Som with the prefix modx_ in front (Which is the once I would like to use, and some without.

        Do you know how I get ModX to use the modx_site_xxxx tables instead of the others? How do I fix this the best way?
          • 3647
          • 177 Posts
          bluespark Reply #14, 17 years, 6 months ago
          As bunk58 said, look at your config file and change the table prefix setting.
          Change the file and clear the cache then try again.
          This should do it I think, but others would know better.
          Mark
            • 14153
            • 10 Posts
            Jily Reply #15, 17 years, 6 months ago
            Thank you very much everyone for helping me seeing the problem! The data imported had a different prefix, why just changing this in the config file helped! I much appreciate it!
              • 3749
              • 24,544 Posts
              BobRay Reply #16, 17 years, 6 months ago
              I’m glad you got it worked out. smiley
              I should have mentioned the table prefix earlier.
                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