Moving Server

[Cypher7]

ah... that's a good idea, using phpMA seems to be the way to do it.

Will that change the strings like www.olddomain.com/forum/index.php?topic=1234 or only the exact text I search for?  ie. www.olddomain.com ?

Im trying to get out of moving the board but looks like its going ahead... The only think I was worried about was the links from other fourms etc and internal posted links...

Thanks for that guys...

[Elissen]

If your doing http://www.olddomain.com/forum/index.php?topic=1234 then you have to do that for every topic and post . If you move over your whole site you can do www.olddomain.com and if your only want to do the forum then www.olddomain.com/forum (of course then also replace by www.newdomain.com/forum)

[Cypher7]

If your doing http://www.olddomain.com/forum/index.php?topic=1234 then you have to do that for every topic and post . If you move over your whole site you can do www.olddomain.com and if your only want to do the forum then www.olddomain.com/forum (of course then also replace by www.newdomain.com/forum)

ah no you kinda misunderstoon what I meant...!  What I meant was, if I used;

UPDATE smf_messages
SET body = REPLACE(body, 'www.olddomain.com', 'www.newdomain.com');

would that change in my sql database the line http://www.olddomain.com/forum/index.php?topic=1234 to http://www.newdomain.com/forum/index.php?topic=1234

or would it just change www.olddomain.com  to  www.newdomain.com !? like an "exact match" find and replace!?

get my drift!?!?

[Elissen]

sorry about that. REPLACE is case-sensitive (I think), but it does match on parts of a word.

From http://dev.mysql.com/doc/mysql/en/string-functions.html

REPLACE(str,from_str,to_str)

Returns the string str with all occurrences of the string from_str replaced by the string to_str.

mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
        -> 'WwWwWw.mysql.com'

This function is multi-byte safe.

[Mucgie]

I've followed these instructions, but now the template I was using before (which absolutely no problems) has this at the bottom "Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is using an ILLEGAL copy of SMF! " and there is no text on my buttons or on the navbars at the bottom - I'm totally lost, does anyone know what's wrong?

http://www.well-of-dreams.com/thewell/index.php [nofollow]

[[Unknown]]

Your language files are missing.  This could mean:
  - the default theme's directory is still wrong.  Note I said *DEFAULT*, not the one being used on your site currently.
  - the files weren't uploaded (properly) on the new server.
  - another problem.

Try correcting your paths with repair_settings.php.  What is repair_settings.php?  If that doesn't help, upload the files in Themes/default/langauges again.

-[Unknown]

[Aftiel]

edit: Ok I have uploaded all the forum stuff and the sql database backup. Now to figure out where to go from there.

[KG4ONJ]

I am having trouble after a server move.  I copied all the files from one server to the other, downloaded the dbase, imported it onto the new server and ran repair_settings.  When I go to the URL for the forum (www.sullivaneastalumni.com/1993/forum) I get this error page:

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

When I run repair_settings I get this error in red at the top of the page:

"Some settings are not being shown because the MySQL connection information is incorrect."

Furthermore, I only have three paths at the bottom:
Forum URL
Forum Directory
Sources Directory

I figure that either my paths are screwed up or that I imported the database improperly.  Any suggestions?  I'm using v. 1.0.5

Thanks!

[dtm.exe]

I am having trouble after a server move.  I copied all the files from one server to the other, downloaded the dbase, imported it onto the new server and ran repair_settings.  When I go to the URL for the forum (www.sullivaneastalumni.com/1993/forum) I get this error page:

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

When I run repair_settings I get this error in red at the top of the page:

"Some settings are not being shown because the MySQL connection information is incorrect."

Furthermore, I only have three paths at the bottom:
Forum URL
Forum Directory
Sources Directory

I figure that either my paths are screwed up or that I imported the database improperly.  Any suggestions?  I'm using v. 1.0.5

Thanks!

Either you username, password, or database name is wrong.  Use repair_settings to fix that.

[thetzfreak]

Having trouble moving servers

First of all, I moved all of my files (without doing anything else), and the template was installed and being used, but it was all screwed up. Then, I went to phpmyadmin, and I can't find any import button.



Import? Anyway, my posts were still there and all, so I tried playing around with the template a bit, trying to install it again. Then, everything just COMPLETELY messed up, and I just deleted everything from the server and put it back, just like I did before. NOW, there is no template at all, just white with the different text. I tried deleting all the templates and installing my original one from scratch, and I get the same problem as someone else: no images or anything, and it says this is an ILLEGAL copy and to report it on the bottom of the page.

Someone PLEASE help me... what should I do? I don't see anywhere to upload my original sql file anywhere, or something like that.

Also, when it says on the top of the page, "The default theme's directory is wrong, please correct it by clicking this text." i go there and thange the destination folders to the correct template, but nothing happens. It also says for the templates that:  (warning, this path is not correct!)

Thanks!

[dtm.exe]

Having trouble moving servers

First of all, I moved all of my files (without doing anything else), and the template was installed and being used, but it was all screwed up. Then, I went to phpmyadmin, and I can't find any import button.

Import? Anyway, my posts were still there and all, so I tried playing around with the template a bit, trying to install it again. Then, everything just COMPLETELY messed up, and I just deleted everything from the server and put it back, just like I did before. NOW, there is no template at all, just white with the different text. I tried deleting all the templates and installing my original one from scratch, and I get the same problem as someone else: no images or anything, and it says this is an ILLEGAL copy and to report it on the bottom of the page.

Someone PLEASE help me... what should I do? I don't see anywhere to upload my original sql file anywhere, or something like that.

Thanks!

See that dropdown box?  Click it and select the database.

[thetzfreak]

Right... my database isn't there. I do not have any databases or usernames on the new server. There is nothing there except for test.

Thanks for the quick reply

What should I do?

[dtm.exe]

Right... my database isn't there. I do not have any databases or usernames on the new server. There is nothing there except for test.

Thanks for the quick reply

What should I do?

You have to create a database to import your old into.

cPanel > MySQL Databases

From there, create a database, add a user, add the user to the database, etc.

[thetzfreak]

Alright, so I made a username and database, chose the database from the list, now what? There's a box saying:Create new table on database ...

Then I enter name and number of fields. What should I do? How do I import my sql file? Sorry for being a noob at this =\

[dtm.exe]

Alright, so I made a username and database, chose the database from the list, now what? There's a box saying:Create new table on database ...

Then I enter name and number of fields. What should I do? How do I import my sql file? Sorry for being a noob at this =\

Open phpMyAdmin, click on the dropdown box, select the database, click on the "Import" tab.  Import the SQL file from there and run repair_settings.

What is phpMyAdmin?
What is repair_settings.php?

[thetzfreak]

Ok, I did all that, and thanks for that help so far. Now, I'm back to that other problem I told you about before... it says:

The default theme's directory is wrong, please correct it by clicking this text.

Also, the template is screwed up, like I said before. Please have a look:

http://everythinghalo.com/forum/index.php

Thanks. That is not the way it should look. It SHOULD look like this:



Sorry, it's a bit cut off on the top, but it's the best picture I have. Also, I don't like that error message on top, naturally

Thanks.

EDIT: Basically, it's using the form of the top of the default template, but it's supposed to be different.

[dtm.exe]

Ok, I did all that, and thanks for that help so far. Now, I'm back to that other problem I told you about before... it says:

The default theme's directory is wrong, please correct it by clicking this text.

Also, the template is screwed up, like I said before. Please have a look:

http://everythinghalo.com/forum/index.php

Thanks. That is not the way it should look. It SHOULD look like this:



Sorry, it's a bit cut off on the top, but it's the best picture I have. Also, I don't like that error message on top, naturally

Thanks.

EDIT: Basically, it's using the form of the top of the default template, but it's supposed to be different.

Correct the Default theme's direcory and URL with repair_settings.php and correct the directory of the Cerberus theme in Admin > Current Theme.

What is repair_settings.php?

[Sirius]

download repair_settings there :
http://www.simplemachines.org/download.php?converters

and upload it in your smf folder and  use it to repair the settings for your server

[Night_Hawk]

heya great tool

wish I found it sooner

GREAT THNX TO EVERY ONE FROM SMF

Yours

Jesse a.k.a [RST] Night_Hawk

www.rogeustormtroopers.com

[heplo]

•   Put your current forum installation into maintenance mode (forum settings -> Maintenance mode).

What do you mean?? I cannot go to my forum because webmaster is fixing it.