We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28582
    • 20 Posts
    I have built a revo site on my local mac, and all works fine. Have set up revo on linux host server to test local site out on clients hosting.

    When I import the local sql database it does so succesfully to live host, all looks fine on front end and can log into manager. However on most of the resources (web pages) that have content added, the content window is showing as empty (although the front end is displaying the correct content).

    Live host settings:

    MODX version: Revo 2.2.6-pl (traditional)
    ExtJS Version: 3.4.0
    Smarty Version: 3.0.4
    PHPMailer Version: 2.0.4
    MagpieRSS Version: 0.72
    Database type: mysql
    Database version: 5.1.68-cll
    Database charset: latin1
    Database name: realloca_modx
    Database server: localhost
    Table prefix: modx_

    Screengrab attached showing home page and blank home contents in manager

    url is www.reallocalflavour.co.uk


    The content is also displaying question mark character in place of apostrophes.

    Any help would be most appreciated
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Are you sure your remote database is set to use the same charset and collation as the local database?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 28582
        • 20 Posts
        yes, both local and remote sites are set to latin1 character set
          • 36926
          • 701 Posts
          Quote from: stewart36 at Mar 05, 2013, 03:43 AM

          The content is also displaying question mark character in place of apostrophes.

          Did you fix as can't see the question mark anymore on url.
            • 28582
            • 20 Posts
            I ended up copying the resource contents manually for each resource from my local install of revo to the remote install, and it all works fine.

            I am though mystified why site was showing content even though the resource contents were showing as blank resources

            Anyhow its fixed now

            thanks

              • 36926
              • 701 Posts
              Quote from: stewart36 at Mar 05, 2013, 06:34 AM
              I ended up copying the resource contents manually for each resource from my local install of revo to the remote install, and it all works fine.


              I was going to suggest manually doing a page to see if the manager showed the content to rule out there being a problem with install. Be interesting to compare the DB data for the content before you manually entered it with what it looks like after you manually entered it.

              Anyhow glad it's all working for you.

              Also not sure you aware but you still have "modx revolution" as your site_name so it's appearing in the browser title. It's one of those things i always forget about and don't notice as easy now due to the browser tabs cutting the title down.

                • 28582
                • 20 Posts
                Hi

                Thanks for your help, the site works ok now and I have updated the site name.

                thanks

                Stew