Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Integrating content from one Textpattern database to another
I’m working on the site design locally while my client adds article content to a remote installation— all the files are kept in sync with subversion, but the databases aren’t: the server version has up-to-date content, but my local version has all the correct Textpattern settings and plugins. I thought it would be easy to merge the content into my local server and then import the entire database into the remote host, but it’s not working too well:
- First, I tried dumping the ‘textpattern’ table of the remote version, and importing that into my local version, using phpMyAdmin’s import command. Those operations worked, but Textpattern would no longer load the Write tab. Everything else seemed to be okay— I could see the article list in Textpattern and the articles seemed to display properly on the front-facing site.
- After restoring from my local backup, everything worked fine again. I got the Write tab back, along with the local version of my content.
- I tried using the TextPattern Copyover script mentioned on this thread. This script successfully imported all content from the remote database, duplicating content that is present in both. But I get the same problem where Textpattern will not display anything when I attempt to load the Write tab.
- Again, restoring from my local backup, Textpattern works flawlessly.
What could be going on here? The database structure of both ‘textpattern’ tables is identical as far as I can see, but for some reason Importing the ‘textpattern’ table from by backup works and importing the ‘textpattern’ table from my dump from the remote server doesn’t.
Are there other methods of getting content from one TXP installation to another? My client has added 5276 articles to the database so far, so copying each manually isn’t an attractive option. Any ideas?
Offline
#2 2008-12-19 17:59:43
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Integrating content from one Textpattern database to another
Don’t know if this matters, but does the author of the ‘remote’ articles exist in your local install?
(I’ll remove your identical post in the other thread to avoid confusion.)
Offline
Re: Integrating content from one Textpattern database to another
Els wrote:
Don’t know if this matters, but does the author of the ‘remote’ articles exist in your local install?
You might be onto something. I’ll manually get the users in order and try again.
(I’ll remove your identical post in the other thread to avoid confusion.)
Thank you!
Offline
Re: Integrating content from one Textpattern database to another
Results: No change. I added all the Textpattern users from the remote installation into my local version using Textpattern’s Admin panel. I can view all the articles at textpattern/index.php?event=list, but clicking on the Write tab just gives me an empty screen.
Offline
Re: Integrating content from one Textpattern database to another
I solved the problem: the write tab disappearing was not due to any database mismatch problems, but seems to be due to cnk_section_tree which isn’t compatible with this site, which relies heavily on glz_custom_fields and sed_section_fields.
Also, Textpattern doesn’t care if the author of an article is in the user table— it will still display the article in edit view.
I won’t go through all the false troubleshooting paths I turned down, I’m just happy to have my site working again, with the data integrated! I wanted to update this thread in case it turns up in future searches for blank write tab.
Offline
Re: Integrating content from one Textpattern database to another
Oh, and the method I used to integrate the content was rss_admin_db_manager, which I found more reliable than phpMyAdmin.
Offline
Re: Integrating content from one Textpattern database to another
johnstephens wrote:
Oh, and the method I used to integrate the content was rss_admin_db_manager, which I found more reliable than phpMyAdmin.
A testament to Textpattern Plugins!
Piwik Dashboard, Google Analytics Dashboard, Minibar, Article Image Colorpicker, Admin Datepicker, Admin Google Map, Admin Colorpicker
Offline