Tweet
Is there a way to export the CMS data from a development database and restore to active site.
-
-
If you export all the tables that start cms_ you will have a working CMS. There are five issues I know of:
- If the userid of the author on the live site is different from the id on the dev site you should run an sql query to fix.
- Attachments in the database won't come across. If they are in the file system you should be able to copy them. I have not tested this- I encourage you to do so with a small test.
- You will need to reindex after the move.
- Any template edits or phrases will need to be moved separately. You can export phrases and templates from dev and re-import into live site.
- You will lose comments. The comments threads should be automatically recreated. Please test and verify.
Please- I'm not tech support. Don't send your problem reports to me unless I've asked you to. -
That's what I did, but no sections or articles will display on the cms home page.
They do display if you click on them from the cms admin.
Comment
-
It would be SWEET if this was more of an automated process (export out into a file for import). I could move all my web pages into CMS articles in my test site, export them.....upgrade my 3.8.4 site and import the articles. 8)
As it is now, there will be a ton of copy / pasting going on once I go live. LOLComment
-
Read this and change setting accordingly.
Please- I'm not tech support. Don't send your problem reports to me unless I've asked you to.Comment
-
Please- I'm not tech support. Don't send your problem reports to me unless I've asked you to.Comment
-
The problem is that the problem doesn't happen on a fresh install. It happens only on my live forum.
Here is what home page shows after importing cms tables:
PHP Code:The default route 'content' is not valid on line 354 in /home/jacek/public_html/vb/router.php
#0 /home/jacek/public_html/vb/router.php(318): vB_Router::getDefaultRoute(404)
#1 /home/jacek/public_html/vb/router.php(207): vB_Router::newRoute('content')
#2 /home/jacek/public_html/vb/bootstrap.php(58): vB_Router::getResponse()
#3 /home/jacek/public_html/content.php(30): require_once('/home/jacek/pub...')
#4 {main}
Fatal error: The default route 'content' is not valid on line 354 in [path]/vb/router.php in [path]/vb/vb.php on line 287
#0 vb_error_handler(256, The default route 'content' is not valid on line 354 in /home/jacek/public_html/vb/router.php , /home/jacek/public_html/vb/vb.php, 287, Array ([exception] => vB_Exception_Critical Object ([] => ,[] => ,[] => ,[] => ,[] => ,[] => ,[] => The default route 'content' is not valid,[] => ,[] => 0,[] => /home/jacek/public_html/vb/router.php,[] => 354,[] => Array ([0] => Array ([file] => /home/jacek/public_html/vb/router.php,[line] => 318,[function] => getDefaultRoute,[class] => vB_Router,[type] => ::,[args] => Array ([0] => 404)),[1] => Array ([file] => /home/jacek/public_html/vb/router.php,[line] => 207,[function] => newRoute,[class] => vB_Router,[type] => ::,[args] => Array ([0] => content)),[2] => Array ([file] => /home/jacek/public_html/vb/bootstrap.php,[line] => 58,[function] => getResponse,[class] => vB_Router,[type] => ::,[args] => Array ()),[3] => Array ([file] => /home/jacek/public_html/content.php,[line] => 30,[args] => Array ([0] => /home/jacek/public_html/vb/bootstrap.php),[function] => require_once))),[code] => 256)) called at [(null):0] #1 trigger_error(The default route 'content' is not valid on line 354 in /home/jacek/public_html/vb/router.php , 256) called at [/home/jacek/public_html/vb/vb.php:287] #2 vB::handleException(vB_Exception_Critical Object ([] => ,[] => ,[] => ,[] => ,[] => ,[] => ,[] => The default route 'content' is not valid,[] => ,[] => 0,[] => /home/jacek/public_html/vb/router.php,[] => 354,[] => Array ([0] => Array ([file] => /home/jacek/public_html/vb/router.php,[line] => 318,[function] => getDefaultRoute,[class] => vB_Router,[type] => ::,[args] => Array ([0] => 404)),[1] => Array ([file] => /home/jacek/public_html/vb/router.php,[line] => 207,[function] => newRoute,[class] => vB_Router,[type] => ::,[args] => Array ([0] => content)),[2] => Array ([file] => /home/jacek/public_html/vb/bootstrap.php,[line] => 58,[function] => getResponse,[class] => vB_Router,[type] => ::,[args] => Array ()),[3] => Array ([file] => /home/jacek/public_html/content.php,[line] => 30,[args] => Array ([0] => /home/jacek/public_html/vb/bootstrap.php),[function] => require_once)))) called at [(null):0]
Comment
-
Hey Milas,
I will need to do this also (if I ever get vb 4 working) - did you manage it in the end?Comment
-
Back then I had to revert to a backup of my vbulletin to get everything working again. After I rerun upgrade script everything was fine. Whole glitch was caused by infamous "out of memory" error during upgrade.
Last month I stopped using vBulletin completely and I switched to what VB should have become.Comment
-
Will this site upgrade to 5.0 when it goes gold? If yes, what will you do with the CMS you are utilizing here?
Comment