Hi,
I have two identical websites. The second one is a last copy where a added new modules, views and more - development site ;) But i don't update any nodes/pages etc.
After some time, I wanted to update the content from production site to my "development site".
I can't migrate all tables from production database, becouse its override my new views, content types etc.
That I did copy the following tables:
- node
- node_revision
- files
- content_field_images (custom field for images - type: file)
- content_field_videos (custom field for videos - type: Embedded Video)
- term_node
- url_alias
- content_type_story
After that, in lists (for example: News nodes) a have many duplicates!
For example:
If node have 3 values in field "field_images" - the node is displayes 3 times in list :/
something like that:
----------------------------------------------
Node 1 title - image 1
----------------------------------------------
Node 1 title - image 2
----------------------------------------------
Node 1 title - image 3
----------------------------------------------
Node 2 title - image 4
---------------------------------------------
Node 2 title - image 5
----------------------------------------------
Node n title - image n
----------------------------------------------
But it should be like this:
----------------------------------------------
Node 1 title - image 1
----------------------------------------------
Node 2 title - image 4
----------------------------------------------
Node n title - image n
----------------------------------------------
In addition, on the node edit/node preview, a see only first (one) image.
Any ideas what could be wrong? Perhaps i copy wrong tables?
ps. Sorry for my week english :(
Comments
This is a really unfortunate
This is a really unfortunate situation that there is really no good way to move just configuration or just the content between sites.
Do you have any backups of the DEV server? Then, restore a backup and make sure your views are imported.
There is a module I used a few months ago, Deploy, they let you deploy content to a site without raw database syncing. It was a little difficult to setup but worth it.
For a db change, try copying all tabes that start with "field_", node, authmap, user.
Variable table contains all configuration. System table contains all the module information.
Clear caches in both sites before doing this. Good luck!
PS. It's weak not week ;)
// Ayesh
SOLVED!
I found a solution!
Backup done with my way was correct, but...
I don't realize that the options in my CCK filefield could by wrong. I found that "Number of values:" was set to 1.
I change it to "no limit" and that's work - now everything is correct!
www.kreation.pl