Moving Server

[rojamaia]

i've got a problem with my newly moved website also.

i can't log in, and my users can't log in either.  i'm not sure if it's just the passwords, but i get this error on the index page of the forum

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

my site is an SMF 1.0.5 and MKPortal 1.0 at http://samar.frih.net/index.ph

the site looks okay on the portal side and the imports from the board posts are okay also, so i'm puzzled why the board index doesn't work.

[unExpected]

Have you tried repairing the table in phpmyadmin?

[rojamaia]

i did, and it still won't work.  i can't even log in to my site

[Gobo]

hi

well i did the restore settings php file thingie and everything else

all things are working just fine except 2 things

News & newsletter link produces this error:

Fatal error: Cannot redeclare template_edit_news() (previously declared in /home/.cash/akulion/path-to-peace.net/forum/Sources/Load.php(1598) : eval()'d code:351) in /home/.cash/akulion/path-to-peace.net/forum/Sources/Load.php(1598) : eval()'d code on line 5


I have the "Picture Forum View" mod installed, when I click it NONE of the images show up not even the default ones!

Can someone help me?

[DeeJay Bet]

can anyone help me at all... the repair_settings.php say that my settings.php file cannot be written to:

"Settings.php cannot be written to by your webserver. Please modify the permissions on this file to allow write access."

can anyone help???

[Gobo]

can anyone help me at all... the repair_settings.php say that my settings.php file cannot be written to:

"Settings.php cannot be written to by your webserver. Please modify the permissions on this file to allow write access."

can anyone help???

You need to access your forum directory by FTP and set the permissions on that file to 777 so that it can be written to - right click on file (while in FTP program) and select properties..it will show u its settings, change the number in the box to 777 and thats all. If your FTP program dosent allow that you may want to download Filezilla from download.com which is a completely free FTP program

[xenovanis]

can anyone help me at all... the repair_settings.php say that my settings.php file cannot be written to:

"Settings.php cannot be written to by your webserver. Please modify the permissions on this file to allow write access."

can anyone help???

How do I use chmod?

[DeeJay Bet]

You need to access your forum directory by FTP and set the permissions on that file to 777 so that it can be written to - right click on file (while in FTP program) and select properties..it will show u its settings, change the number in the box to 777 and thats all. If your FTP program dosent allow that you may want to download Filezilla from hxxp:download.com [nonactive] which is a completely free FTP program

Ok i changed the chmod to 777 but i also get this error now

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

problem fixed now lol just my stupid novice knewledge of my sql lol fixed now tho

[zaandammer]

Here is a little document I wrote to assist people who are moving their installation from one server to another. Simply follow the steps below for an easy, stress free move!

•   Put your current forum installation into maintenance mode (forum settings -> Maintenance mode).
•   Download all the files from your current forum folder onto your computer (using an FTP client).
•   Using with the dump database feature of SMF or phpMyAdmin export the contents of your forum database. (In SMF go Admin menu -> Forum Maintenance -> Dump Database -> Dump all). This should save the ENTIRE database of your forum onto a .SQL file on your computer.
•   You are now ready to upload the contents of the directory on your computer to the new server. Upload the complete contents of the directory to the new server.
•   You now need to import the database back into the new server. To do this you will need phpMyAdmin installed on the server, this is often installed for you and is part of cPanel if you have this installed. If using cPanel this can normally be found under "MySQL Databases" then scroll to the bottom and find a link to "phpMyAdmin". From phpMyAdmin select Import and then select browse and browse to the .SQL file you download earlier. Hit OK and the import will begin. Note that on large databases this process may time out. If this is the case open up the .SQL file in an editor and split it up into smaller chunks of around 2MB each. The only thing you must be aware of is that the file must be split at ends of lines (do not split at a part line). In addition if you need to split the file ensure that you import each split file in the correct order.
•   Great! Now you should have the files on the new server and the database imported. However, if you browse to your forum URL you'll notice it doesn't work! This is where the paths recorded in SMF need to be fixed. To do this we have created a nice file called repair_settings.php which can be found in the download section under "Converters and Tools". To use this just upload it to your new forum folder and run it from the browser window by going to: www.yourforum.com/repair_settings.php. After running this file ensure you delete the file off the server to stop others from running it!
•   You should now find everything is working correctly as it was before! If you need to change the web address of the forum (for example moving domain names) ensure you edit Settings.php before you re-upload the files and change $boardurl to point to the URL of the new location.

Oke, I haven't seen this topic BEFORE I moved my forum so here's mij question.

If you need to change the web address of the forum (for example moving domain names) ensure you edit Settings.php before you re-upload the files and change $boardurl to point to the URL of the new location.

Because I wasn't aware of that rule I think I now might have a problem. When I go to my forum (www.talkaway.nl) and look at the properties of a random button it says its url is the url of the old domain (www.ronaldenmaria.nl).

I did everything like it is said the quote above. Download files, backup DB, upload files, restore DB, ran repair_settings.php and deleted it after it.

The forum operates OK, i have no problems, but the buttons are still taken from the old domain. Also I noticed that it only happens in the theme I have installed and not in default theme.

When I take a look at Settings.php & Setting_bak.php I see it still has the old URL in it and when I change it and upload it to my new domain it gives an error.

What do I need to do. I am not really novice to smf but I'm also not an expert. Please help.

Ronald.

[zaandammer]

Button Prob Solved! Current Theme's Settings > Theme URLs and Configuration still had the old URL's in it.

How about Settings.php and Setting_bak.php?

Ronald.

[DeeJay Bet]

How about Settings.php and Setting_bak.php?

what about the settings.php and settings_bak.php

wer is the data for all the different boards stored... my new host has an smf quick install through fantastico... is the data of all the boards n users etc stored in the mysql file ?

[xenovanis]

Button Prob Solved! Current Theme's Settings > Theme URLs and Configuration still had the old URL's in it.

How about Settings.php and Setting_bak.php?

Ronald.

Have you tried the repair_settings file? You can correct your paths and url 's with it, also for the default theme. Any other theme you need to change manually.What is repair_settings.php?

wer is the data for all the different boards stored... my new host has an smf quick install through fantastico... is the data of all the boards n users etc stored in the mysql file ?

Yes.

[zaandammer]

Button Prob Solved! Current Theme's Settings > Theme URLs and Configuration still had the old URL's in it.

How about Settings.php and Setting_bak.php?

Ronald.

Have you tried the repair_settings file? You can correct your paths and url 's with it, also for the default theme. Any other theme you need to change manually.What is repair_settings.php?

Yes, I'd allready ran repair_settings.php as you could have seen in my earlier post. But thank you for answering.
Hmm... I just looked at settings and settings_bak.php but now it all seems fine. The URL's are correct, I don't know why but it's oke now.

Ronald.

[Ne0z]

Hi , I moving to a new server soon. Can i install a fresh copy of SMF on the new server and move just the theme and posts from my old server to the new one ?

I am new here , can anyone help me :> thanks !

[Vanilla]

I have read through around 75% of this thread - and most other threads I could find regarding this issue and have done anything that I could that was suggested.  I have also contacted my host but they are not able to help me at this time.  So I'm still having problems.

I had smf installed for domain on server1 and recently moved domain to server2.  I uploaded all of my site files for domain to server2 then did a clean installation of smf on server2 to a folder sharing the same name as the old smf folder. 

I used "create_backup.php" to create a backup of my mysql database from server1, uploaded the backup to server2, used "restore_backup.php", then double checked the settings by running "repair_settings.php".  Everything was correct.  But when I go to the directory I get this (the actual folder names have been replaced with **folder** and **smffolder** respectfully):

********************************

Notice: Only variables should be assigned by reference in /home/**folder**/public_html/**smffolder**/Sources/Subs.php on line 232

Notice: Undefined index: is_admin in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 556

Notice: Undefined index: permissions in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /home/**folder**/public_html/**smffolder**/Sources/Subs.php:232)
Notice: Only variables should be assigned by reference in /home/**folder**/public_html/**smffolder**/Sources/Subs.php on line 232

********************************

I am at a total loss for what to do next.  Uploading the mySQL database through phpAdmin didn't work either (that was my first 3-4 attempts before I resorted to the "create" and "restore" backup files).

Any help would be greatly appreciated.

[xenovanis]

I have read through around 75% of this thread - and most other threads I could find regarding this issue and have done anything that I could that was suggested.  I have also contacted my host but they are not able to help me at this time.  So I'm still having problems.

I had smf installed for domain on server1 and recently moved domain to server2.  I uploaded all of my site files for domain to server2 then did a clean installation of smf on server2 to a folder sharing the same name as the old smf folder. 

I used "create_backup.php" to create a backup of my mysql database from server1, uploaded the backup to server2, used "restore_backup.php", then double checked the settings by running "repair_settings.php".  Everything was correct.  But when I go to the directory I get this (the actual folder names have been replaced with **folder** and **smffolder** respectfully):

********************************

Notice: Only variables should be assigned by reference in /home/**folder**/public_html/**smffolder**/Sources/Subs.php on line 232

Notice: Undefined index: is_admin in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 556

Notice: Undefined index: permissions in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /home/**folder**/public_html/**smffolder**/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /home/**folder**/public_html/**smffolder**/Sources/Subs.php:232)
Notice: Only variables should be assigned by reference in /home/**folder**/public_html/**smffolder**/Sources/Subs.php on line 232

********************************

I am at a total loss for what to do next.  Uploading the mySQL database through phpAdmin didn't work either (that was my first 3-4 attempts before I resorted to the "create" and "restore" backup files).

Any help would be greatly appreciated.

PHP 4.4.0 Compatibility

[Vanilla]

xenovanis: Thank you so much.  That is exactly what I needed to do.  Thank you again - you have just made my weekend so much easier and better! 

[pyrotechnic]

Damm, I've done this prob a million times without problems but now i'm getting this error when importing a sql database:

SQL-query:

INSERT INTO `smf_log_topics` (

`ID_TOPIC` ,
`ID_MEMBER` ,
`ID_MSG`
)
VALUES # --------------------------------------------------------
#
# Table structure for table `smf_membergroups`
#

DROP TABLE IF EXISTS `smf_membergroups`

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `smf_membergroups`' at line 9

Some help would be great

[Grudge]

What is in the actual file? It looks from what you posted that it's trying to insert values for log_topics, when no values exist for it? What is around those lines in the sql file you are importing?

[Cougra]

So far I've followed all the directions in the first post but am having problems with this one:

You now need to import the database back into the new server. To do this you will need phpMyAdmin installed on the server, this is often installed for you and is part of cPanel if you have this installed. If using cPanel this can normally be found under "MySQL Databases" then scroll to the bottom and find a link to "phpMyAdmin". From phpMyAdmin select Import and then select browse and browse to the .SQL file you download earlier. Hit OK and the import will begin. Note that on large databases this process may time out. If this is the case open up the .SQL file in an editor and split it up into smaller chunks of around 2MB each. The only thing you must be aware of is that the file must be split at ends of lines (do not split at a part line). In addition if you need to split the file ensure that you import each split file in the correct order.

I have the .sql file from the forum but there are two major problems that I don't know how to overcome.

1.  The .sql file is about it's 7mb long and I know I have to break it up into smaller chunks at the end of a line.   The problem is that I don't know how to recognise the end of a line.  Once I do get the file broken up do I have to name them the same or can I call them backup1.sql, backup2.sql, etc... to keep them in proper order?

2.  The dbname, username and password are all different for the database on the new site and when I try to import the file it says that it's restored to the database with the old name not the new name so none of the data appears. (I've attempted to import my test forum because the database size is smaller then the 2MB limit for this one.)