Problems cloning site

[bts420]

I want to clone my production vbulletin forum to a test forum for testing and backup purposes.

so basically I want to create an exact duplicate to a new database and location.

Production
db = vb_prod
url = /mysite/forums

Test Site
db = vb_test
url = /testsite/forums

So here are the steps I've taken

- Dump vb_prod using phpmyadmin
- Edited dump vb_prod.sql and changed all occurences of "mysite/" to "testsite/"
- Restored vb_prod.sql to database vb_test using bigdump.php
- Copy all forum files from /mysite to /testsite
- Edited config.php and updated the database information

Unfortunately I must have missed somthing because this is not working. I get the following error when I try and access the testsite


Warning: array_keys(): The first argument should be an array in /includes/functions.php on line 4840

Warning: preg_replace(): Empty regular expression in /includes/functions.php on line 4840

Any thoughts

[Dave Hawley]

Can't help much with the errors sorry, but make sure you block all bots with a robots.txt file so SE don't pick the Test site over the real one.

[Dismounted]

They can't, all test forums must not be able to be viewed by the public.

[bts420]

Last night I basically redumped the database, and reimported and everything worked. Must of had either a bad export or a bad import the first round.

And yes, my test site is behind an htaccess

[WetWired]

I don't have the same version as you, but there's only one line in functions.php which has both a preg_replace and array_keys call on the same line. Judging from that, I'd guess that your datastore is corrupted. I'd strongly advise against the search and replace in the SQL file. Try importing the original export, then running the tools script from the "do not upload" folder (put it in admincp or install directory) to change the cookie domain, if needed (delete it once you're done). You can then login and change any other settings.

[bts420]

Hey wetwired, thanks for the post.

Here is the problem with not editing the SQL. I have vbadvanced installed. Unfortunately it is littered all over the place with the url. The thing that really sucks is that if I go and change the URL via admincp it catches a few but there were still tonnes of references to mysite/ getting mixed into my testsite/ forum.

I admit I am pretty much brand new to vbulletin. I'm converting over from phpbb. With phpbb I simply dumped the database, restored it to the new database and changed one setting. Easy as pie to clone or move the site.

Maybe there is a better way to do this I'm not sure. I might actualy go make a post at vbadvanced because this was a pain in the butt. The 2nd round I actually did not change the sql and I manually went into admincp and change the forum url and the vbadvanced url. Then I ended up spending another hour continually finding that my test site was transferring over the production site because all those damn references were not changed.
I had to update all my smilie, graphic references, html page references, etc. I'm still not sure if I got them all.

Actually I just went through the sql again and I had 78 references to the url in the following tables

vb_adv_pages
vb_datastore
vb_icon
vb_smilie
vb_template

Only 1 of these was vbadvanced, although there were a few vbadvanced related items in the other tables.

So my question then is, is there an easy way to change the site url from admincp and have it update all references easily?

[SCRIPT3R]

why not just use ImpEx?

[WetWired]

Only thing I can suggest, is if the import without the replace doesn't give you those errors, do to the replace on everything but the datastore table (as the datastore may not deserialize properly if it is tampered with), then go and make meaningless changes to various option pages to get the datastore rebuilt.

[Dave Hawley]

Originally Posted by Dismounted

They can't, all test forums must not be able to be viewed by the public.

Sorry, don't know what you mean. But anyone COULD upload a "test" forum to their domain and if SE crawl it they MAY pick the test site over the real one.

[Dismounted]

The vBulletin license agreement states that all test forums must be secured in a way that the public cannot access. As soon as the directory is secured from the public, this renders all SE crawls useless to the test forum.