Problem with transferring site

Hangin' Around Joined: Nov 04, 2007 Posts: 34

Hi,

I am currently running two websites. One which is the actual site, the other runs on a different domain and I only use that to test and play around.

Now on the "test" domain I've installed the latest 2.30.01 On the "live" site version 2.20.01 is running.

I am now building up the site on the test domain as a new site with 2.30.01. What I want to do when it's finished is transfer the new site from the "test" domain to the "live" domain. I want to remove the current database and ftp files from the "live" site and import the database from the "test" site and transfer the ftp files from the "test" to the "live" site. And then import the current nuke_users table from the live domain.
So I have a brand new site with the latest ravennuke and all users can still use there own logins.

I already tried to import the nuke_users table. Works perfectly.

Now here is my only problem so far. What I also tried is importing the database from the current "live" site to the "test" site. Just to see if I could do that ok. The database is transferred ok. But then when I open the "test" site it automatically transfers me to the current "live" site.

So apparently if I am going to import the new database from the "test" site to the "live" site there are some other settings I need to change to avoid people visiting my site being redirected to the "test" site.
Or maybe I just did something wrong?

Can someon pls guide me a bit here on what the best way is to transfer my site? Settings I need to change after transferring the database to the other site etc? Cause as it seems now to me, when I remove the database and import the one from the "test" site, people will be redirected to the "test" site. Could this be caused by the two sites haveing a different name for the database?

tnx in advance

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

2 main places to look at first. Check the Site URL in Preferences and the Domain Name in the Forum Admin.

Posted: Tue Jun 16, 2009 1:56 pm

Raven wrote:

2 main places to look at first. Check the Site URL in Preferences and the Domain Name in the Forum Admin.

Ok, tnx alot for the fast reply.
Will keep that in mind when transferring the stuff. Tnx again.

registered · Posted: Wed Jun 17, 2009 6:28 am

eagleeye1000, actually, if it were my own site, this is what I would do:

1. Take a copy of the current site and import it into my test site DB.

2. Use the rndb_upgrade.php script (as well as the NukeSentinel(tm) step) in the INSTALLATION directory to upgrade the db to 2.3.1 level.

3. Using the test domain, test out all your features and any file customizations to ensure everything is running smoothly. If you make any DB changes (outside of step 2), make sure to note those for the following steps. Once you are satisfied that everything is working properly and you are ready to cut over continue:

4. Make a backup of your current site database AND files! DO NOT SKIP THIS STEP!

5. Make sure you are logged in as Admin, then using NukeSentinel(tm), shut off your site (the "Site Switch").

6. Copy/FTP over all the 2.3.1 files to the main domain and run the same rndb_upgrade.php and other db update steps that you did previously for your testing.

7. Test key areas of your site to make sure everything looks like it went well and then you can turn the site back on.

Before you do any of this, as these are just high-level steps for your specific situation, read the section in the HowToInstall manual on Upgrading as there are key FCKEditor considerations to be aware of as well as some other things. In other words, you will need to meld those ideas into the overall "plan".

Posted: Wed Jun 17, 2009 12:25 pm

guys I am trying montego's route now but run into the same problem.

I put all ftp files and the database of the live site on the test site. And then I get stuck already.

Now when I open the test site it brings me to the live site. Also when I try to open www.mytestsite.com/admin.php to change the URL preference as raven adviced it opens the actual admin page of the live site...
How can I set the URL good now for my test site domain?

Is it set somewhere in a config file also?

tnx in advance.

Posted: Wed Jun 17, 2009 1:20 pm

ok found it in the database nuke_config table and nuke_bbconfig

will continue with montego's steps now.

Posted: Wed Jun 17, 2009 1:35 pm

eagleeye1000 wrote:

ok found it in the database nuke_config table and nuke_bbconfig

will continue with montego's steps now.

Posted: Wed Jun 17, 2009 2:27 pm

ok getting closer...

I managed to update the site on the test domain to the latest ravennuke.

Bumped into this error now.....
When I am in the admin control page it opens fine. But when I click a button like "blocks" the page opens and the bottom of the page disappears and the theme frame on the right side disappears. The bottom disappearing happens on all teams. The right side of the frame only disappears on "smaller" themes.

Looking at my live site it seems it's that boxes on the pages which look like Word text editors. Because on the test site those aren't displayed. As soon as one of those editors should be displayed the frame is pushed out to the right (smaller themes only) and the editor field isn't visible, along with all the rest that should be shown below it (on all themes)

Here is an example of the editor box I mean, shown correct on the live site:

Only registered users can see links on this board! Get registered or login!

I don't know if that editor box is a mod that was added to my site (didn't make the current one myself) or that it comes default with ravennuke.

On the update the following errors where shown, but those don't look like a problem to me:

CREATE TABLE `nuke_bbattachments` (`attach_id` mediumint( Cool

UNSIGNED DEFAULT '0' NOT NULL, `post_id` mediumint( Cool

UNSIGNED DEFAULT '0' NOT NULL, `privmsgs_id` mediumint( Cool

UNSIGNED DEFAULT '0' NOT NULL, `user_id_1` mediumint( Cool

NOT NULL, `user_id_2` mediumint( Cool

NOT NULL, KEY `attach_id_post_id` (`attach_id`, `post_id`), KEY `attach_id_privmsgs_id` (`attach_id`, `privmsgs_id`), KEY `post_id` (`post_id`), KEY `privmsgs_id` (`privmsgs_id`)) TYPE=MyISAM Succeeded.

ALTER TABLE `nuke_bbforums` ADD `auth_download` TINYINT(2) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'auth_download'
ALTER TABLE `nuke_bbauth_access` ADD `auth_download` TINYINT(1) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'auth_download'
ALTER TABLE `nuke_bbposts` ADD `post_attachment` TINYINT(1) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'post_attachment'
ALTER TABLE `nuke_bbtopics` ADD `topic_attachment` TINYINT(1) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'topic_attachment'
ALTER TABLE `nuke_bbprivmsgs` ADD `privmsgs_attachment` TINYINT(1) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'privmsgs_attachment'
UPDATE nuke_users_config SET `config_value` = '2.30.01' WHERE `config_name` = 'version' LIMIT 1 Succeeded.

AND THESE FOR THE SENTINEL UPDATE

- Insert of dump directory succeeded
Insert list harverster into nuke_nsnst_config: list harvester insert failed
Insert list referer into nuke_nsnst_config: list referer insert failed
Insert list string into nuke_nsnst_config: list string insert failed
Create nuke_nsnst_harvesters: harvester table creation failed
Create nuke_nsnst_referers: FAILED

Create nuke_nsnst_strings: FAILED

Any help on where to sort this issue greatly appreciated.

tnx

Posted: Wed Jun 17, 2009 3:04 pm

ahhhh... found the solution on the site here. ...

I just renamed the folder FCEditor to fckeditor and the problem is gone. Took a while for me to figure out that text editor was knows as FCKeditor Sad

Will need to improve my searching skills.

If someone could pls confirm about the errors I got on the update process are not to worry about, tnx.

small donation on it's way, you guys do great work. My respect for all your support tnx alot.

Posted: Thu Jun 18, 2009 7:14 pm

These errors could be caused from either having run the upgrade scripts multiple times, or, it is also possible that you already had the attachment mod on your 2.20 site as well as a later NukeSentinel?

If everything seems to be working fine, I'd be inclined to suspect one of the above and not to worry.

Posted: Fri Jun 19, 2009 11:31 am

I did indeed install the attachment mod and updated NukeSentinel a while ago. So that should be it.

Tnx alot for your help.