[SOLVED] as follows:
- copied over all 2.1.2 files to server
- did update install
- copied over the missing Resource Content from the local db to remote db using the MODx Manager / Editor
- exported Remote database, imported into Local database - missing Resource Content was still there
- exported new Local database and reimported it into the Remote database
- problem solved
------------------
Original problem
This occurs on the remote server after i move the database from my local pc (details below)
Environment:
- MySQL database
- Revo 2.1.2-pl
- Windows 7
- Firefox 5
Scenario:
- on my local disk, Container X had children Resources Y and Z
- both Resources Y and Z have data in the Resource Content field
- export the local database using phpMyAdmin, with the Add DROP TABLE checked
- on the remote site, clear the remote database by checking all records and using the Drop choice
- import the local database into the "blank" remote database
- login to the MODx manager on the remote site
- on the remote site, Edit child Resource Y or child Resource Z and both have nothing in their Resource Content field
- if i look at the MySQL Table site_content, content field, the data is there but it won’t show up in the Manager
- note: parent Container X has Resource Content and the content is transferred successfully
- usually when i View (Preview) the Resource the Resource Content shows up, however when i Edit the Resource the Resource Content file is empty. i have tried the above scenario multiple times and once the View (Preview) showed nothing in the Resource Content field
What i have tried:
- clearing my browser cache
- restarting my browser
- repair all Tables on the remote site with phpMyAdmin - all Tables said OK
- clearing the MODx site cache in the Manager for the remote site
- erasing all of the files/folders under the core/cache directory on the remote site
Thanks in advance for your help!
Steve
Edited to add this statement above:
- if i look at the MySQL Table site_content, content field, the data is there but it won’t show up in the Manager
- change title of problem to be more descriptive
Did you run Setup in upgrade mode on the new server?
Also, try deleting all the files in the core/cache directory.
If that doesn’t work, the odds are that one or more MODX files got corrupted or missed in the transfer.
yes, ran setup in upgrade mode on the new server
yes, erased core/cache
if i copy over the Resource Content manually from the local to remote the display is correct
the View mode always shows the Resource Content, it’s the Edit mode that doesn’t
