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
-
☆ 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?
yes, both local and remote sites are set to latin1 character set
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
Hi
Thanks for your help, the site works ok now and I have updated the site name.
thanks
Stew