For an updated version of this guide look on the doc site (http://docs.simplemachines.org/index.php?board=83.0;sort=subject)
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.
i found your article very helpful and clear to follow about how to transfer data form one old MySQL to a new MySQL, however i need to aks you where in the world i can get the phpMyAdmin?
thank you man!
richard
over 72,000 hits in only 4 months, WOW!
I LOVE SMF!!!!!
http://www.phpmyadmin.net
Most hosts include this software with your hosting account in one form or another (usually built-in to CPanel or Exim depending on which one your host uses).
i am going to ask my webhost, that is 1and1.com maybe someone has an opinion about 1and1.com, i heard some but not related to this subject.
will let you know about my findings.
thank you man!
-richard
I just did the repair_paths, and when trying to access the forum, I get:
Notice: Undefined index: theme_template_error in /srv/www/vhosts/cardlock.de/smf/Sources/Load.php on line 835
My old forum is: http://robo-store.de/flugsim/smf
My new forum is: http://cardlock.de/smf (second attempt) or https://etadar.de/flugsim.de/smf (first attempt).
I thought maybe https was a problem (etadar.de is not accessable by http) so I tried a different one.
Quote from: mrichard on August 19, 2004, 10:37:30 AM
i am going to ask my webhost, that is 1and1.com maybe someone has an opinion about 1and1.com, i heard some but not related to this subject.
will let you know about my findings.
thank you man!
-richard
i got it fixed while ago, sorry for not being able to post the results here. all i did, i used PUTTY to upload my database. REALLY EASY!
first backed up my old database, then saved it in my computer, renamed the file. uploaded in ROOT from server, ran the PUTTY program to unzip the database file and MAGIC! all my topics and everything were in the new server, just as if nothing happened.
than, i had to run the repair tool, then i had to log on to my admin page and corrected the paths for the avatars and themes, that's it!
thank you so much guys!
-richard
Okay I realized the I had to carefully check the paths in the bottom half of the screen (repair_paths.php). The first few had aparently been autodetected correctly, so I didnt read on, but some others were not correct, so look carefully!
After making sure all the new paths were correct, I ran repair_paths.php again, and now at least the forum title page shows up, but always at the top is displayed:
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs.php on line 1598
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs.php on line 1599
Also logging in does not work:
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs-Auth.php on line 60
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs.php on line 1168
(the page ends here)
I'm pretty sure I followed Grudge's migration procedure to the book.
Any more ideas, anyone?
Okay, I finally fixed it, it was the "enable output compression".
Damn :-)
Sorry! Must have switched that without noticing.
Too bad though, that it doesnt work!
Quote from: arnolde on September 07, 2004, 12:36:42 PM
Too bad though, that it doesnt work!
It being?
Remember that repair_settings.php does not change anything when you run it. If you use it and take the "recommended" values for everything, your forum should work - assuming you save the changes with repair_settings.php.
Just going to repair_settings.php does nothing at all.
-[Unknown]
Of course I also clicked on the apply-button at the end of the page, after checking all the parameters :-)
But thanks!
The problem was, I had enabled the compression. My shop system (oscommerce) on the same server successfully uses compression, so I didnt think it would cause a problem.
Maybe thats not really the problem after all, but when I turned it off, the above problems disappeared... so I guess that suits me. Although I would sorta like to have compression, I love to save bandwidth every way I can.
Try turning it back on; do the problems come back?
-[Unknown]
yes, as soon as I "enable compressed output" and apply, the following appears at the top of the screen, followed by the normal display:
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs.php on line 1598
Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/cardlock.de/smf/Sources/Load.php:812) in /srv/www/vhosts/cardlock.de/smf/Sources/Subs.php on line 1599
Please also note I am using German language, if that makes any difference.
Ethan
Your language shouldn't make any difference. Are you certain you are using an SMF 1.0 RC1 Load.php? I have the one in the distribution open right in front of me, and Load.php on line 812 - or anywhere near, for that matter - should not be outputting anything.
-[Unknown]
No, it is the SMF1Beta5 Load.php.
Sorry I didnt mention that before.
Well... please upgrade then ;). This shouldn't be an issue in RC1.
-[Unknown]
Click on the "SQL" link at the top, not the "Query window" thingy.
If you still have problems, post more details
Another problem from me I'm afraid. I followe Grudge's guide as to how to move server. I have run "repair_settings" and accepted the recommended values. But when I go to the forum, it brings up a completely blank page.
Any ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Since my origonal post, I have found and used the "repair_paths" file and used it I now get the following error:
Notice: Undefined index: theme_template_error in /home/.sites/132/site21/web/smf/Sources/Load.php on line 900
Now I'm even more stumped.
Any help/ideas welcome
G
that .sites in the path looks like it might be it, try using repair_settings.php again it but remove the .
Thanks Ben,
I have tried as you suggested, but no joy. I downloaded the "Sources" folder from the old server again and tried uploading that again as well but the page is still blank. Run "repair_paths again, and still the same error message. The old forum is still on it's server so I know that one works if taken out of Maint. Mode.
Can you pm me the link to repair_settings.php?
-[Unknown]
I'm afraid some of your files were not uploaded completely (they were just 0 bytes.) I have taken the liberty of uploading fresh copies...
-[Unknown]
Ahh, now I see what the problem was.
You are an absolute superstar.
Thanks to the whole team. Great software.
G.
I am not so much moving to another server, but would like to move one forum catagory on my personal site to a new site which covers (amongst other things) the topic of the specific catagory.
I guess I could move the complete forum and then edit it, but maybe there is a better way..
What did you have in mind? Moving the entire category complete with boards and posts and all the member info? If so, just install a fresh copy of SMF someplace, import your current SMF database (make sure you install this new copy of SMF on a different database) and then just edit the copied version down to what you want. Otherwise it gets really tricky.
I had a problem with importing my database, i think i done it via phpMyAdmin the old paths and addresses appeared in my new copy i had to go and change them back to the new settings. Its fine now just giving a heads up for you to check.
Quote from: Trekkie101 on December 03, 2004, 10:39:45 AM
I had a problem with importing my database, i think i done it via phpMyAdmin the old paths and addresses appeared in my new copy i had to go and change them back to the new settings.
Thats because you never used repair_settings.php
It didnt exist when i moved host :)
I have a wee moving server question. I've installed a fresh board on the new server, and this weekend I hope to backup the database and restore it into the new board. Is that sufficient? Is it okay to use the new files from a new download? Not sure how the forums are stored.. if they are in the db, then should work.
Of course I won't rebuild the tables in the sql backup, I'll just populate them.
So long as the old forum shares the same database structure (which it's bound to do if it's an unmodded installation with the same version number), you should be fine. But you'll still have to deal with your settings and paths.
okay.. what settings and paths are in the DB? I thought they were in the Settings.php file. Which should, in theory, remain the same. It's an identical install, same release, no mods.
The smileys, attachments, and avatars path are in the DB, the rest are in settings.php ;) If you change server most the time unless you move from one cpanel server to another with the same username, the paths will change.
hmm id did al of that, and it works exept for one thing, i see no theme, its all white background with black text, blue links and some images, like the stars and menus, ext...
Check all your theme URLs and paths.
-[Unknown]
Quote from: [Unknown] on December 22, 2004, 04:49:11 AM
Check all your theme URLs and paths.
-[Unknown]
i did, it seems a few theme files didn't get copied over some how, lol.
Quote from: Grudge on March 11, 2004, 09:20:52 AM
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!
Or... if you have an access to the shell, then connect to it for example with putty.
Go to html-root and write simple:
tar -gcvf forum.tar.gz forum (if forum is a foldername of installation)
Connect to the new server move to html-root and write:
ftp ftp.oldserver.com and log in
after that just type in:
cd html-directory (what ever that was)
get forum.tar.gz
wait for download and then
bye
Now you are back in the shell of the new server. Type in
tar -gxvf forum.tar.gz
There is all the files
Get an easy to use mysql-client called front
Connect to old server
go to the file menu and connect to new server. Now they are both open, so activate the old server window from windo-menu
Choose from im-/export menu the export
You can copy everything, or choose just the smf-data and copy that directly to the new server.
That's it.
Cheers meitzi, you still need to do the repair_settings step though as otherwise SMF won't work when you've restored it :)
Quote from: Grudge on December 26, 2004, 04:08:42 PM
Cheers meitzi, you still need to do the repair_settings step though as otherwise SMF won't work when you've restored it :)
Right. I had a funny feeling that I forgat something :)
This is first board that has such thing, and I realized it after I allready used pico.
Hello
I have just moved servers and all has gone well except 1 issue.
When I sign in and click on any link I am logged straight back out.
Does anyone have any advice?
Thanks Guy's ;)
Quote from: remstrus on January 01, 2005, 11:24:48 AM
When I sign in and click on any link I am logged straight back out.
Is your board URL consistent (ie always with or without 'www')?
Thanks for your reply, I have resolved the issue :D
I was logged out due to the fact I was running the new configuration in site preview via Plesk, I guess until the domain resolves to the new server there may be a few issues.
I have now updated the DNS records and the domain resolves to the new server and all works fine ;D :D ;) :D ;D
Thanks for a great program
Phil
Need this reference to! As am going to change servers/hosts soon to.
quote :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. .....
nice but there are NO import option on my new lame server in PHPMY admin. Only export.
now I have tried to upload the SQL database on the new server , I get this error :
MySQL said:
#1153 - Got a packet bigger than 'max_allowed_packet'
as said in the fist post, I would have to CUT this file in parts, which is not easy to do for a newbie... so I guess I am screwed. ::)
does this also mean that I will never be able to recuperate from a crash on my forum because my sql database is too large and there is no other way to restore than doing it by mySQL, since there is no restore option in the admin panel?
wow, very dangerous.
You'll probably find my "restore_backup.php" and "create_backup.php" utilities interesting.
-[Unknown]
Quote from: [Unknown] on January 20, 2005, 05:41:52 PM
You'll probably find my "restore_backup.php" and "create_backup.php" utilities interesting.
-[Unknown]
where can i find these?
Anyone willing to test some things for me? (http://www.simplemachines.org/community/index.php?topic=18350.msg168327#msg168327) :)
Quote from: Jerry on January 21, 2005, 08:19:01 PM
Anyone willing to test some things for me? (http://www.simplemachines.org/community/index.php?topic=18350.msg168327#msg168327) :)
cheers mate :)
just incase anyone has the same problems that i have.
i created a backup using the admin panel but kept getting errors when trying to import it into phpmyadmin.
all i did was use unknown's create_backup.php to create my database backup and then used his restore_backup.php to restore my database.
it worked like a gem.
Unfortunately I have the same problems gerrymore mentioned earlier in this thread: my beta5 won't come up on the new server with anything but a blank page :'(
Here is what I did:
- copied the whole dir to my local PC
- exported the DB
- adjusted the settings.php (DB settings, paths)
- FTPed the whole stuff to the new server
- imported the DB dump
- searched SMF for help, found repair_settings and repair_paths, run them both (incl. "save settings" and cross-checked the settings.php)
- still no result :(
Does anybody have an idea what could have gone wrong? Re-uploading didn't help either.
I would like to see the beta5 running on the new location before upgrading to the current release.......
It could be Zend, could you show us a phpinfo() page from your new server?
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0)
After you get your forum back up, you might want to upgrade it also :-X
Quote from: Jerry on January 25, 2005, 06:49:42 AM
After you get your forum back up, you might want to upgrade it also :-X
This for sure.....
But I want to finish the move first.
Some extracts from my phpinfo (to keep the post short):
| value | new server | old server |
| php version | 5.0.3 | 4.3.10 |
| Zend extension | 220040412 | 20021010 |
| magic_quotes_gpc | off on | on |
| magic_quotes_runtime | off | off |
| register_globals | off on | on |
| register_long_arrays | on | n/a |
| safe_mode | off | off |
| zend.ze1_compatibility_mode | on | n/a |
| mySQL Client API version | 4.1.8a | 4.0.22 |
Looking at this table I think I'll switch on magic_quotes and register_globals just for a treat.......
[edit]
Didn't help either - still nothing but a blank page :'(
Updated the table above with the current values.
[/edit]
Had a look at the server's error log:
[client ***] PHP Warning: main() [[a href='function.include']function.include[/a]]: Failed opening '/***/forum/Sources/QueryString.php' for inclusion (include_path='./:/usr/share/pear/php5/') in /***/forum/index.php on line 46
[client ***] PHP Fatal error: Call to undefined function: cleanrequest() in /***/forum/index.php on line 69
Apparently something is going wrong with the QueryString.php, seems I will have to upload it again......
Or are there some known issues with SMF 1.0 beta 5 and php 5?
Check all the files are uploaded, also are you sure those paths are correct?
Quote from: Ben_S on January 25, 2005, 10:35:40 AM
Check all the files are uploaded,
I will as soon as I get back to my own PC with the files and add the missing ones (NB: Oooops, just saw that the QueryString is missing indeed :o)
Quotealso are you sure those paths are correct?
Which ones? The include path './:/usr/share/pear/php5/' is beyond my control, but the file paths (abbreviated with ***) are correct, triple-checked with the provider and the repair_settings.php
Path is probably correct then, it would have been the missing file that was causing it.
:)
After uploading the source files it finally seems to work properly.
Thanks for your help, this problem is solved.
I have moved to the new server successfully. But I have a little problem, when I login in, I get this error:
QuoteInternal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
When I go back to the forum I'm loged in. Can U help me?
Does the apache error log show anything?
This is the ";id" problem. There's a mod on the mod site to fix this.
-[Unknown]
Quote from: [Unknown] on January 25, 2005, 09:42:10 PM
This is the ";id" problem. There's a mod on the mod site to fix this.
-[Unknown]
OK, did that everything looks good. I installed the package and no error. BUT,
when i go to the Attachment Manager and click od some attached file, it shows the same error as above.
Is the same id problem that is overlooked ?
Perhaps. 1.1 should include a full fix for this issue. I think it's caused by an update to mod_security.
-[Unknown]
Quote from: [Unknown] on January 27, 2005, 09:10:40 PM
Perhaps. 1.1 should include a full fix for this issue. I think it's caused by an update to mod_security.
-[Unknown]
I see, so if I search in all .php files for ";id" and replace with "&id" will it correct the problem ?
More or less, yes. Although that alone would cause validation problems, I guess it's not as bad as the forum not working :P.
-[Unknown]
I've just move my Yabbse/supermod database back up on to a new server.
Do I need to reinstall the supermod files and then the smf upgrade or can I just upload the smf upgrade?
Quote from: Pure80s on February 03, 2005, 06:23:43 PM
I've just move my Yabbse/supermod database back up on to a new server.
Do I need to reinstall the supermod files and then the smf upgrade or can I just upload the smf upgrade?
Just doing the SMF upgrade should be fine. You may need to use repair_settings.php afterward, however.
-[Unknown]
Thanks for the speedy reply :)
I used repair_settings.php but in the javascript bit it still uses the old URL. It seems $settings['theme_url'] and $settings['images_url'] weren't changed.
It only changes the default theme's URL and path. You'll need to update any other themes manually.
-[Unknown]
Hello,
I have a question which i didn't find anywhere else.
Which database table contains the latest message info besides yabbse_messages?
I just moved my forum and all went succesfully, actually is completely up and running but I have not set the domain.dns yet cause im preparing.
But because I used the sql files of yesterday it also shows the last message from yesterday. So how quickly put over the last info from the old domain when the moment is there.
Tnx in advance
Ed
Just use "recount all forum totals and statistics".
-[Unknown]
I am setting up a new test site on the same server as the main forum, smf 1.0.1. I have tried a range of things but I'm stumped. :(
I have a completely new account and domain. I uploaded phpMyAdmin 2.6.1 and edited the config.inc.php file.
I have ftp'd all forum files to my PC and reloaded them to my new space. I used the Admin/maintenance to make an uncompressed copy with table structure (5.7mb) and loaded it with phpMyAdmin and then ran repair_settings.php.
In the admin I can see the complete list of members. In forum view I can see post numbers in the forums, but I cannot see the posts. All the icons and graphics are missing.
What have I missed? It must be something obvious or a cockup with editing phpMyAdmin config.inc.php, I think ....... :-[
Check your theme settings and verify the paths are correct...
-[Unknown]
I have checked the theme settings, paths for default are correct but only default SMF and Classic themes show, all my customised themes are missing. I have downloaded and checked settings.php all paths in there appear correct and I have re-ftp'd my themes folder.
I see /htdocs/ in the paths, as I'd expect to see, but is htdocs something I should have set up or modified?
I have included a section of code from settings.php, are these correct?
########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/homepages/[account]/htdocs/our-local'; # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/homepages/[account]/htdocs/our-local/Sources'; # Path to the Sources directory.
Well, remember that each theme has its own URLs and paths. The repair_settings.php tool does not change these, either.
Where is the forum? Can you give me an example of a theme that isn't showing?
-[Unknown]
I can fix my custom theme url's no problem, even if they pointed to the old url they should still show if the url still points to that theme at the original url. The problems of no images is with the default theme.
I have IM'd you the url and admin account login details.
Update
I have replaced my version of phpMyAdmin, changed the folder and re-downloaded all the files from the board to my PC and back up again to the new folder. I have also dropped a new database backup and tried to reload it with the updated phpMyAdmin. I'm getting a 500 internal server error and I cannot log into the board, which appears to be missing the same bits.
I have now loaded an earlier backup sql file and have something working.
There are still no images, buttons, avatars, smilies. I have tried to create a new theme and uploaded a complete set of graphics, still no show. I have checked settings.php all OK, theme url's and images url's, OK
Is my main board saving corrupted backups?
Is phpMyAdmin corrupting them?
Has my ftp, WS FTP Pro, dropped or corrupted some files?
New url is http://nokonium.co.uk/Cat-and-Fiddler/
I have set up the same account for you to have a look.
Hmm.. looks like a referrer/hotlinking protection type thing is to blame.
http://nokonium.co.uk/Cat-and-Fiddler/Themes/default/images/english/home.gif
Works fine, but won't load if I come from
http://nokonium.co.uk/Cat-and-Fiddler/index.php
-[Unknown]
Thanks [UNKNOWN] I'll look into that.
We think we have it sorted now.
You were right about the images, I have now deleted the .htaccess file and all the images have appeared, it had been copied over with the files from the main site.
It does also appear that the phpMyAdmin was corrupting the sql files, using the restore database utility appears to solve that problem.
Thanks
Quote from: nokonium on February 19, 2005, 11:59:54 AM
loaded it with phpMyAdmin and then ran repair_settings.php.
I would suggest not running the 'repair' thing, better upload that table again. I had the same thing. It puts something on another line.
Quote from: mrichard on August 19, 2004, 10:37:30 AM
i am going to ask my webhost, that is 1and1.com maybe someone has an opinion about 1and1.com, i heard some but not related to this subject.
will let you know about my findings.
thank you man!
-richard
www.melpowerforum.com
regarding www.1and1.com their hosting seems to be very expensive!
For good prices and quality services I recommend www.achohosting.com .
Good topic, however I am just switching DOMAINS, not servers.....both of my 2 domains are hosted under the same exact account, with the same phpMyAdmin database. All I am doing is moving the forums from the blahblah.com folder in my account to the blahblah2.com folder. What steps would I need to take to do this, since the database for the new domain is linked to the same database as the old domain. Thanks for any help!!
If you're only switching domains, you only have to use repair_settings.php. What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
-[Unknown]
Thanks, gotta say I appreciate the fast replies I've gotten to my 2 posts so far...you guys by far have the best community support + developer support I have ever seen :) *thumbs up*
Hello All, I have taken over admin of a site that has Yabb 1 gold SP 1.3.1, so I am new to all this. My new clients want to move to a new server and update the BB. So I am thinking that I should intall the latest version of SMF to the new server, back up the database on the old server, upload it to the new server, run restore_backup.php to import it because the host did not back import db available in phpmyadmin. Next repair_settings.php and or repair_paths.php. Now if that all worked and I didn't turn into a pretzel meanwhile. I should be a happy camper. Feed back is appreciated
Sounds like a good idea. If you haven't converted from YaBB yet, it may be simpler.
You could copy all of YaBB's data files from the old server to the new, and then edit the paths in Settings.pl/Settings.cgi. From there, you'd be able to install and convert on the new server, without having to use phpMyAdmin or the database at all.
-[Unknown]
Ok thanks for the reply [unknown]. But, please excuse my ignorance, which ones are the data files? Also for the install. Having read the tutorial, it is still unclear to me, Am I supposed to create the database first?
Thanks
Quote from: christiansees on March 22, 2005, 04:20:05 PM
Ok thanks for the reply [unknown]. But, please excuse my ignorance, which ones are the data files? Also for the install. Having read the tutorial, it is still unclear to me, Am I supposed to create the database first?
Well, YaBB's data files... may be a few places. They're probably under cgi-bin. It's been a long time since I worked with the Perl YaBB.
Unless you're installing as a user that has the privilege of creating databases (unlikely) you'll need to create the database first.
-[Unknown]
I seem to be having a similar problem as Bigforo. Mine is on the install page
QuoteInternal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
--------------------------------------------------------------------------------
Apache/1.3.33 Server at www.Mydomain.com Port 80
this is while attempting http://www.Mydomain.com/forum/install.php Also the error log says
Quote
[2005-03-22 17:00:41]: error: file is writable by others: (/home/user/public_html/forum/install.php)
[2005-03-22 16:16:32]: error: file is writable by others: (/home/user/public_html/forum/install.php)
[Tue Mar 22 17:00:41 2005] [error] [client XX.XX.XX.XX] File does not exist: /home/user/public_html/500.shtml
[Tue Mar 22 17:00:41 2005] [error] [client XX.XX.XX.XX] Premature end of script headers: /home/user/public_html/forum/install.php
I don't really feel that I have the savvy at this yet to hack all the php files. Suggestions?
Have you tried making the file 755 instead of 777?
-[Unknown]
whoa that was too easy. now it works.
thanks
...after changing server and updating Settings.php , chmodded new dirs etc. the new installation works fine but...the older attachments (and personal avatars) not. All the attachments are in right place, the path is correct, the sql file is the same older one...what could i do now? :-\ Thanks! ;)
Make sure to try a hard refresh.... it may cache the bad stuff in your browser.
-[Unknown]
...done...but nothing new. Another not working thing: the number of posts of any user is sticked (no more increases in the number of posts even posting more and more...) :'(
http://www.xt600.cc/forum/index.php?action=dlattach;id=4623;type=avatar
Works for me.
Probably your mail settings are wrong.
-[Unknown]
Quote from: [Unknown] on April 01, 2005, 06:28:38 PM
http://www.xt600.cc/forum/index.php?action=dlattach;id=4623;type=avatar
Works for me.
Probably your mail settings are wrong.
-[Unknown]
...the biggest problem is with (old) attachments, see:
http://www.xt600.cc/forum/index.php?topic=11172.0 (actual one on .CC server)
and
http://www.xt600.it/forum/index.php?topic=11172.0 (on previous .IT server)
as you can see attachments on .CC server are no more displayed (but present in they own folder...)
.... ???
And you're 100% certain you copied over the contents of the attachments directory? Are you sure the files were stored there?
I can't see the other, no, because it's in maitenance mode...
-[Unknown]
...i send you a PVT...
Hi,
Even after 5 hours of trying online and re-reading this thread over and over i can not transfer my forum to new webspace.
Here is the existing forum www.cr0.co.uk/curry
I took a download of the .sql database
the I want to transfer it to the new webspace, so i used phpmyadmin to try to upload the SQl, cant find the upload button anywhere in phpmyadmin, i finally find something to upload and i get an error back.
Is there a simpler way to do this for someone who knows nothing.
S
Im having problems with importing the database, I get this error at the end of the sql restore
QuoteThere seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 5
STR: />
SQL: <br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /www.vehiclecommunication.com/ifitstuff/Sources/DumpDatabase.php:122) in <b>/www.vehiclecommunication.com/ifitstuff/Sources/Subs.php</b> on line <b>1754</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /www.vehiclecommunication.com/ifitstuff/Sources/DumpDatabase.php:122) in <b>/www.vehiclecommunication.com/ifitstuff/Sources/Subs.php</b> on line <b>1755</b><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="description" content="An Error Has Occurred!" />
<meta name="keywords" content="PHP, MySQL, bulletin, board, free, open, source, smf, simple, machines, forum" />
<script language="JavaScript" type="text/javascript" src="http://www.vehiclecommunication.com/ifitstuff/Themes/default/script.js"></script>
<script language="JavaScript" type="text/javascript"><!--
var smf_theme_url = "http://www.vehiclecommunication.com/ifitstuff/Themes/default"
What did I do wrong?
[EDIT] : I get the error "Table 'ifitstuf_newforum.smf_settings' doesn't exist" when I try to log into the forum now >:(
Looks like the database dump didn't work properly and you just got a bunch of garbage instead...
Ok. i need some help please.
I followed the first post on moving the DB and forums from one server to the next and runing the repair .php file. everything worked great! However, the new forum has the follows problems which I can seem to fix:
1. Smileys wont attach to the messages
2. bold, ubderline, etc functions on posting dont work
3. uploading avatars through he users profile manger doesnt work
Somethings did not come over on the first try like all my attachments and avatars ansd I had to re-do them, so mayble this is the same type problem, but I really don;t know where to go to fix.
If anyone can help me out it would be much apprciated.
Forum URL -
www.thegamedomain.org/tgdmain/
thanks!
Quote from: mrichard on August 19, 2004, 10:37:30 AM
i am going to ask my webhost, that is 1and1.com maybe someone has an opinion about 1and1.com, i heard some but not related to this subject.
will let you know about my findings.
thank you man!
-richard
www.melpowerforum.com
Quote from first page!!!!
Um, if anyone wants to know a really really good hosting plan, then check out hostingplex.com, im with them and they are so good. 5000mb webspace, 110GB bandwidth, support for all script (bot sure about Coldfusion) and you can have 5 add-on domains and 20 sub-domains. Also, you can have 100MySQL databases. I looked aroudn for ever and this was the cheapest and best by far. Or, if you dont want all the fancy stuff and just want raw download bandwidth and space, then check out canaca.com, i havent been with them but there packages look alright (they dont include to many extras though, but have alot of bandwidth and space)
Anyway, i hope ive helped someone...
Quote from: [ASH]TGD on April 10, 2005, 01:32:28 PM
1. Smileys wont attach to the messages
2. bold, ubderline, etc functions on posting dont work
3. uploading avatars through he users profile manger doesnt work
Sounds like path/javascript errors. I checkedc and your forum looks fine; still having issues?
-[Unknown]
hi when i try to do this technique when i upload the sql file to the new server i get this error. anyone know
[email protected]Error
SQL-query:
CREATE TABLE `smf_shop_items` (
id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
DESC varchar( 100 ) NOT NULL default '',
price decimal( 7, 2 ) unsigned NOT NULL default 0.00,
module tinytext NOT NULL default '',
stock smallint( 6 ) NOT NULL default 0,
PRIMARY KEY ( id )
) TYPE = MYISAM
MySQL said:
#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 'desc varchar(100) NOT NULL default '',
price decimal(7,2) un
I moved my forum and am having issues.
- I moved from running thr forum from a directory on another domain to its own domain.
- the forum is still on the same server
- I've been told that I should not need to move the database because it is still on the same server with the same name and password
- I uploaded the files and had some issues, ran repair_settings.php but still have problems.
I do have a different plesk user and login than before.
Right now if I go to the forum all I see is "index" see www.politicitis.com/forum/index.php for an example. I have no idea what to do from here.
An update. Well it seems part of the problem was the file transfer, the files were all screwed up :( Nothing like uploading garbage to screw things up.
The forum is there at least. There is no theme at all. www.politicitis.com/forum2 (http://www.politicitis.com/forum2) to see what I mean, it is all text.
I also get the following error when I log in:
Quote
2: file_exists(): open_basedir restriction in effect. File(/home/httpd/vhosts/bunktekforums.com/httpdocs/members/politicitis/forum/Themes/theme1/index.template.php) is not within the allowed path(s): (/home/httpd/vhosts/politicitis.com/httpdocs:/tmp)
/home/httpd/vhosts/politicitis.com/httpdocs/forum2/Sources/Load.php
822
I guess I need to run the repair_settings.php to fix the error. I'm just checking since my host/friend got it working to where it is and I don't want to screw up whatever he did.
Well, managed to get everything working.
Ended up that the files did not transfer to my pc and back up to the server properly and then being one line in the theme database pointing to the old location on the other domain.
Quote from: wizboy on April 25, 2005, 02:44:51 PM
hi when i try to do this technique when i upload the sql file to the new server i get this error. anyone know [email protected]
I'm afraid this is caused by the shop mod. Edit the backup file and find:
desc var
Replace with:
`desc` var
-[Unknown]
I cannot find an "import" button in PhpMyAdmin ???
Can anyone help me on this?
Thanks
The SQL tab... under the database you want to import it into.
-[Unknown]
I also managed to get everythign working my pc was just acting up.
Quote from: [Unknown] on May 03, 2005, 12:56:51 AM
The SQL tab... under the database you want to import it into.
-[Unknown]
lol.. That was stupid of me not to find it :P
But thanks HEAPS :D
Sys_ZERO
Quote from: Sloth_Boy on April 13, 2005, 08:11:18 AM
Or, if you dont want all the fancy stuff and just want raw download bandwidth and space, then check out canaca.com, i havent been with them but there packages look alright (they dont include to many extras though, but have alot of bandwidth and space)
This post is a couple of weeks old but my conscience compels me to alert anyone who's intrigued by Canaca to read my review of their "services" (http://www.simplemachines.org/community/index.php?topic=35057.0) on the Hosts and Hosting forum.
Hi there
I moved my forum to another server all seems ok but I have a big problem with attachment.
some of old attachement available, while the rest of it availble at the attachmewnt forder but not linked with topics.
can any one advise what to do?
Did you upload them all to the new server?
Yes but my mistake was finalising setup before finishing upload all attachments
Now all Ok
i wish i saw this thread before i changed my server...doh!
but i did the server change yesterday....everything went well but i too
have missing attachments.
they are uploaded to the same location, full path is correct in features and options and the dir is 777
old posts show 0 KB - downloaded X times
when i look at the source of the post i see
filename.jpg
and when i try to post a new attachment i get " Cannot access attachments upload path!"
any ideas for a remedy? thanks
Use repair_settings.php to double check your attachments path.
-[Unknown]
100% right...it was the path...didn't need to run repair_settings
just needed to check the path for the 10th time....silly how you can miss something this simple even when it stares you right in the face. thanks for the pointer
I just uploaded my test site to my new server (http://www.blackswanonline.org/smf) and get this error:
Template Parse Error!
It seems something has gone sour on the forum with the template system. This problem should only be temporary, so please come back later and try again. If you continue to see this message, please contact the administrator.
You can also try refreshing this page
I have run both repair_paths and repair_settings. I have also gone into the db manually and checked each path in each table, including the tportal_tp ones and all should be correct. However, still have the same error. Anyone encounter this particular error moving servers?
Cheers!
Ci
Are you sure all of your files were uploaded properly and completely?
-[Unknown]
Thanks for the response, Unknown.
I've checked about everything I can think of (i.e. diretories, files, file sizes, permissions, etc.) and all looks okay to me. As I said in my last post, settings.php and the tables in the db all reflect the corect addresses. Repair_settings reports all okay, and repair_paths runs with no errors. All the tportal_tables reflect correct addressing (the tportal tables are in my smf db). Frankly, I'm stumped as to where to look or what to check next at this point.
There is a small silver-lining here though: this is my test site, so if I have to I can start from scratch. I hate to because I've already done some customization work. However, as a last resort I will dump that installation and begin again. I primarily wished to solve this issue so that in case it ever happened again in the future I would know what to do to correct it. I'll muck about in the files a little more and see if I can find a solution.
As an aside, my main site is at least installed and ready for customization at Azeroth Irregulars (http://www.blackswanonline.org/forum). This is the site the public will interact with. There was nothing really in it that couldn't be recreated so I started it completely from scratch... ;)
Cheers, and thanks again for the help and support!
Ci
Great It works.
Ciinien, to get a different parse error message, try this:
INSERT INTO smf_settings
(variable, value)
VALUES ('disableTemplateEval', '1');
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
-[Unknown]
Hi I accidently changed my URL address in the forum admin zone and now I cant restore it back to my original. How can I go about restoring it back to the original URL?
Regards
Andy
You'll want to read this:
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
-[Unknown]
many thanks, sorted now :D
I don't get what cpanel even is. I downloaded phpmyadmin and I have no idea what to do with it. I upload the file onto my server? Like www.server.com/phpmyadminfolder.blah or www.server.com/smf/phpmyadminfolder.blah?
Then how do I access phpmyadmin? Through my smf forum?
I need an angel, I think.
i got problems doing that can somebody help me ?
Please enumerate your problems. We can't help you if you don't tell us what they are.
-[Unknown]
unknown can you go to aim ill explain better Please
How do I use an FTP client to download the forum to my computer? Also, can I just transfer my forum to a new server without transferring my website to a new server (the forum is taking up too much RAM on my account).
Quote from: girls4christ on August 03, 2005, 01:54:05 PM
How do I use an FTP client to download the forum to my computer?
Typically, after you have the client installed (for example, one can be found at www.smartftp.com, with documentation on how to install it) you connect to your website (with the information provided by your host) and select all of the files and folders in the "forum" directory (or where ever you put SMF) and drag them to a folder on your hard drive.
But, generally, it depends on the FTP client.
QuoteAlso, can I just transfer my forum to a new server without transferring my website to a new server (the forum is taking up too much RAM on my account).
You can. Still, I would suggest it's probably the server's configuration that's at fault here - but, assuming that ship has sailed, all you have to do is transfer the files and database information, and use repair_settings.php - as described in the first post.
-[Unknown]
Right, I know this may now be the most simplest of tasks as there seems to be a fair bit of guidance already posted, but believe or not, Im really struggling with it :(
I have a forum at www.britains-tractors.co.uk/forum (hosted by lycos) but want to transfer it along with all contents etc to a new domain I have just obtained, www.farmtoysforum.com. (also hosted by lycos)
I have downloaded smartftp, connected to the first site and downloaded all the forum contents to my hard drive. I have also saved the forum database as a sql file. (as directed at the start of the post).
The trouble starts when I attempt to upload the forum contents to the new domain of farmtoysforum.com and try to load up the database using phpmyadmin.
Im not sure whether im gettin all the files uploaded as it times out sometimes but all the files appear to be there, and when uploading the database, it comes back with something like you cant kill a process?!?!
If someone could help me out here I would be really grateful as this has been hassling me all week!!!
Best Regards!!
Please try uploading this file to the destination server, and accessing it - for example:
http://www.farmtoysforum.com/restore_backup.php
Then, upload the backup file via FTP to the same directory. You might, as another example, upload it with the name "backup.sql"
Once you have it uploaded, type that in for the path in the restore_backup thing and enter your passwords.
-[Unknown]
Im now at the stage of gettint the database into the server
Because it is quite large I have split it into 4 chunks. The first 2 chunks load fine, but then when I try to load the 3rd I get an error.
MySQL said:
#1062 - Duplicate entry '1-1' for key 1
What have I done wrong?
It sounds like you didn't split it into chunks exactly. Don't worry - this is recoverable, you don't even have to delete everything.... just make sure the chunks are cleanly separated.
-[Unknown]
Sorry guys,
I keep working on this as it time goes on and seem to have got a bit further!
I can now get the main forum body, at www.farmtoysforum.com
But now there are no posts or member lists?
How do I get these returned?
Thanks
I figured out that the last post was due to a faulty database download as all of the entries were empty hence no members.posts etc showing up.
I now am using xtdump to get a copy of my forum database on to my hard drive as the smf backup_database keeps timing out.
All together my total data base in .sql format is around 26mb and in sq.gz its just over 4mb.
Attempting to upload the whole databse at once results in time out so I am now copying each forum table one by one and uploading.
However....
The larger tables with many entries are still timing out, for instance, I can upload smf_attatchments, smf_banned and smf_boards with not problem but when I try to upload smf_permissions, it just keeps timing out.
The file is only around 40kb as a .sql.gz and 900kb as a .sql.
I tried to get around the problem by editing the file as a .sql into smaller chunks so 450kb sections.
But as this is one table, when I got round to uploading the second half it came up with an error.
I then added the commands
drop table etcc to the top of the second half of the file and it worked, but Im assuming this would now overwrite the first half???
This problem of timing out is affecting me on all the large smf tables so is there a general solution to this or is there a way to split the files/tables into chunks so they dont overwrite?
Really need help on this guys!
Many thanks
Andy
First, I want to apologize if this have been already answered ... Second, I have an issue :) I want to move my forums from one domain to another. However, I want to keep the database. In other words, I have the database on a particular server with the forum data. Im able to keep that database and everything, but only need to move the forum .. how would I go about doing that, and have the forum point to the already existing database and data?
Attachments and Avatars.
Just read through the thread but can't spot an answer for my problem. I've moved the contents of the attachments directory into the new one, check the paths so that it's pointing to the right dir. Now when I check the Avatars and Attachments in the admin area the correct names show up but when I click the link all I get is a 404 not found error.
Any thoughts?
(http://zeldarealm.com/here.PNG)
I cant find the link to where it says import ::)
That looks like you haven't selected the database on the left handside of the window you've screen grabbed. From quickly looking at it that looks like the screen for setting up a new database and until you either set up a new DB or select the one you want to import into you won't have the option.
Ok i got everything to import and forums are working at last but.. since i moved servers and now imported the database i found that the passwords for everyone had been deleted or something. so now everyone has to click forgoten pass to reset theirs :\. Any idea why this has happened or how to fix it?
Juggler, are you still having your problems? Anything in your error log?
Dreamcloud, what version of SMF are you using? A server move should not affect passwords in any way, unless you converted from another software previously - did you?
-[Unknown]
No actual solution as yet. I've decided that as there are not that many attachments (about 100) I'll edit the files and re-upload them as I come across the attachments.
I have posted in another thread about the next issue but I may as well drop it here but all my PM's got screwed in the move. What I found is that the SMF 1.0.5 DB stores them in smf_instant_messages where as 1.1.3 stores them in smf_personal_messages. A simple rename doesn't work (tried that) and the table structure isn't exactly identical. I also noticed that the same thing applies to smf_im_recipients and smf_pm_recipients. So I need to figure out how I transfer the info from the 1.0.5 DB structure into the 1.1.3 structure.
A couple of days ago I moved my forum to another server.
Basically it all works just fine, though I haven't been able to move a part, which is called: 'INSERT INTO `smf_sessions`
I'm not quite sure if this is a serious problem. The forum seems to work just fine and I'm not having any errors either.
It would be appreciated if someone can actually tell me if it is important that I keep on trying to move that part or that I can just leave it as is and carry one with my forum on my new server.
Cheers,
Stu (Holland)
hello after the server move, it seems that the smileys aren't showing up anymore, the path to it is correct, I checked the folder and saw that the weight of it was 0Ko so I deleted it and uploaded a new folder with the smileys and still got the problem can someone please help me?
I was trying to move my forum to another server, but after I restored the whole database on my new server nothing was working right. So I have done a new install and now I want to restore just parts of the database, like the members and boards. I only want those parts of the database restored. How do I go about doing that? Any help on this matter would be great. Thanks for your time
thanks for this tutorial! this sure would make things easier
however, i have another question. if i would use the upgrade.php, would it not disturb the mods that i have installed into my forums?
Quote from: malinaobenny on August 29, 2005, 03:23:11 AM
thanks for this tutorial! this sure would make things easier
however, i have another question. if i would use the upgrade.php, would it not disturb the mods that i have installed into my forums?
There is no need to run upgrade.php if you move servers.
It being?
I notice further back "meitzi" gave instructions for using the SHELL to move file/folders from server to server...
Being a total newbie to shell I followed the instruction on a server I knew I had shell access to..
they didn't quite work how "meitzi" said for me
he said use tar -gcvf forum.tar.gz forum where forum is the folder you want to tar
I found this didn't work but tar -cf forum.tar.gz forum did
I found this site which explains ssh pretty well
http://www.webmasterstop.com/61.html
I'm sure "meitzi" way is right but I'm totally new to shell so I guess its me... but the way at the site Ive linked did work form me and I managed to move a folder very quickly
Hit a snag, seems my existing host is Windows and I've been told tar wont work...the admin of my exisiting host tells me I can ftp through my linux shell on my new host from the windows server to the linux server..
I've managed to use the "putty" ssh client to let me connect via ftp to my existing host (windows) and can look in folders and even transfer via get & mget commands from that server to my new linux server...
Now the question is there a way of moving whole folders including sub folders..??
mget will move the contents but still a fairly long winded way, having to go into each folder including sub folder to move the contents ??
I'm very new to using straight commands but if its possible with examples I seem to be managing
Unfortunatly I have to move to a new server and new domain name... I'm not worried about moving, I can (hopefully) handle that.
What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.
When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...
Do I have to do that again or can you think of a better way!?
Any input appreciated...!
Quote from: Cypher7 on August 31, 2005, 09:12:28 AM
Unfortunatly I have to move to a new server and new domain name... I'm not worried about moving, I can (hopefully) handle that.
What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.
When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...
Do I have to do that again or can you think of a better way!?
Any input appreciated...!
repair_settings will handle that.
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
Quote from: Cypher7 on August 31, 2005, 09:12:28 AM
Unfortunatly I have to move to a new server and new domain name... I'm not worried about moving, I can (hopefully) handle that.
What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.
When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...
Do I have to do that again or can you think of a better way!?
Any input appreciated...!
I moved a board once to a different domain and to preserve all links I used phpMyAdmin to replace the old domain name by the new one in the body of all the messages.
UPDATE smf_messages
SET body = REPLACE(body, 'www.olddomain.com', 'www.newdomain.com');
Be sure to test this first though! (and backups of course). And remember that it will change things you might not want it to change (like the topic announcing moving domain :P).
Still, putting a dummy index.php at the old location that does a nice HTTP-redirect with the proper response codes (permanently moved?) to the new site is still something you want. Think of search engines and other sites that link to you.
header("Location: http://www.newdomain.com$_SERVER[REQUEST_URI]"); might do the trick
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...
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)
Quote from: Elissen on September 02, 2005, 07:19:37 AM
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!?!? ;)
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
QuoteREPLACE(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.
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
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? (http://www.simplemachines.org/community/index.php?topic=18096.0) If that doesn't help, upload the files in Themes/default/langauges again.
-[Unknown]
edit: Ok I have uploaded all the forum stuff and the sql database backup. Now to figure out where to go from there.
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!
Quote from: KG4ONJ on September 18, 2005, 05:38:08 PM
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.
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.
(http://img382.imageshack.us/img382/6520/picture3ms.png) (http://imageshack.us)
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!
Quote from: thetzfreak on September 20, 2005, 08:20:11 PM
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.
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?
Quote from: thetzfreak on September 20, 2005, 08:44:25 PM
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 DatabasesFrom there, create a database, add a user, add the user to the database, etc.
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 =\
Quote from: thetzfreak on September 20, 2005, 08:53:06 PM
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? (http://www.simplemachines.org/community/index.php?topic=21919.0)
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
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:
(http://img389.imageshack.us/img389/9094/capture6nq.th.jpg) (http://img389.imageshack.us/my.php?image=capture6nq.jpg)
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.
Quote from: thetzfreak on September 20, 2005, 09:14:00 PM
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:
(http://img389.imageshack.us/img389/9094/capture6nq.th.jpg) (http://img389.imageshack.us/my.php?image=capture6nq.jpg)
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? (http://www.simplemachines.org/community/index.php?topic=18096.0)
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
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
Quote from: Grudge on March 11, 2004, 09:20:52 AM
• 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.
Quote from: dtm.exe on September 18, 2005, 05:41:35 PM
Quote from: KG4ONJ on September 18, 2005, 05:38:08 PM
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.
OK.. I have re-checked my username/password but I am using the setting that "repair_settings" suggests. Is there something that I'm missing? Where would I find my correct username and password info?
Thanks in advance for any help!
Where can i get repairsettings.php?? I did not find it in downloadpage...
Plz help me fast.
Quote from: heplo on October 14, 2005, 09:06:58 AM
Where can i get repairsettings.php?? I did not find it in downloadpage...
Plz help me fast.
http://www.simplemachines.org/download.php/repair_settings.php
http://nipanet.worldfreeweb.com:2082/frontend/x/files/showfile.html?dir=/home/nipanet/public_html/heplo&file=repair_settings.php
When i go to repairsettings.php i got these text. Can anyonne help me??
Edit: Should I run the repairpaths.php?? But I get this error message http://nipanet.worldfreeweb.com:2082/frontend/x/files/showfile.html?dir=/home/nipanet/public_html/heplo&file=repair_paths.php
I have tried to chmod both files.
What text? How are you trying to run repair_settings? All you need to do is upload it to your forumlocation and run it from there: http://www.yourdomain.com/repair_settings.php.
Please be careful with posting links to this file in a public forum, as it reveals your accountdetails!
Quote from: xenovanis on October 14, 2005, 09:44:49 AM
What text? How are you trying to run repair_settings? All you need to do is upload it to your forumlocation and run it from there: http://www.yourdomain.com/repair_settings.php.
It does not work... :'( :'(
When I try it, I get an internal server error message. Make sure that file is chmodded to 755 or higher.
Quote from: Oldiesmann on October 14, 2005, 09:51:11 AM
When I try it, I get an internal server error message. Make sure that file is chmodded to 755 or higher.
I have chmodded it to 777...
It's working for me now, but at the top of the page it says "Some settings are not being shown because the MySQL connection information is incorrect", so you will need to fix that.
I have a question... not really about moving servers, but moving the forums from one folder to another on the same server... if I simply copy the files over to teh new folder and the run the repair_settings.php file... would that be all that's needed??
Yes, that's all you'd need to do.
great...now to make the time to do the move... lol...
I downloaded the backup database via phpmyadmin and transferred it to the new server via bigdump.php. I am getting this error:-
QuoteError at the line 531: ) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=1 ;
Query: CREATE TABLE `smf_banned` ( `ID_BAN` mediumint(8) unsigned NOT NULL auto_increment, `ban_type` varchar(30) NOT NULL default '', `ip_low1` tinyint(3) unsigned NOT NULL default '0', `ip_high1` tinyint(3) unsigned NOT NULL default '0', `ip_low2` tinyint(3) unsigned NOT NULL default '0', `ip_high2` tinyint(3) unsigned NOT NULL default '0', `ip_low3` tinyint(3) unsigned NOT NULL default '0', `ip_high3` tinyint(3) unsigned NOT NULL default '0', `ip_low4` tinyint(3) unsigned NOT NULL default '0', `ip_high4` tinyint(3) unsigned NOT NULL default '0', `hostname` tinytext NOT NULL, `email_address` tinytext NOT NULL, `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0', `ban_time` int(10) unsigned NOT NULL default '0', `expire_time` int(10) unsigned default NULL, `restriction_type` varchar(30) NOT NULL default '', `reason` tinytext NOT NULL, `notes` text NOT NULL, PRIMARY KEY (`ID_BAN`) ) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=1 ;
MySQL: 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 'DEFAULT AUTO_INCREMENT=1' at line 21
I don't know what that DEFAULT is doing in there, but I think that's what it's complaining about. Try editing the .sql file directly on your computer (extract it to your computer then open it in notepad) and removing that DEFAULT, then re-uploading the .sql file...
So far I've been able to move all of my smf directory to a new server and I can make it run, however I have been unsuccessful migrating the database. Every time that I've tried it comes out corrupted. It's about 10 megs in size. I've had problems running the export and can only make it work if the yabbse_messages table is not included. In the past I was able to make good SQL dumps with create_backup.php, however the hosting company has enabled php safe mode and create_backup will no longer run for me. (no surprise that I'm moving, huh?) Any help would be appreciated.
I tried using the backup "create_backup.php" & "restore_backup.php", but I get this message:-
Line #1: Query was empty >:(
BTW I should have mentioned that the original Server had MySQL 4.1.13 installed whereas the server I am shifting to has MySQL 4.0.23 installed.
Don't know why the create_backup.php and restore_backup.php files wouldn't work, but I'm thinking that the error message you posted earlier could be due to the difference in MySQL versions. MySQL 4.1.13 is newer than 4.0.23, so queries exported from that version might not work properly in MySQL 4.0.23.
When i go to the repair_settings.php I got top of the screen this message: Some settings are not being shown because the MySQL connection information is incorrect.
The rest of the page is normal, but when i trying to save settings smf do not do that. I did not got any error messeages after that, only the message top of screen: Some settings are not being shown because the MySQL connection information is incorrect.
Any ideas??
Either your
database server
database name
database username
database password
are incorrect.
Quote from: xenovanis on October 22, 2005, 11:19:46 AM
Either your
database server
database name
database username
database password
are incorrect.
Ok no error anymore and i got more paths to repair, but i cannot save setings, when i click it it oly appears the same settings
Check if the files Settings.php and Settings_bak.php are writable.
How do I use chmod? (http://www.simplemachines.org/community/index.php?topic=23690.0)
Quote from: xenovanis on October 22, 2005, 11:46:59 AM
Check if the files Settings.php and Settings_bak.php are writable.
How do I use chmod? (http://www.simplemachines.org/community/index.php?topic=23690.0)
Chmodded but nothing happened...
When I try to run create_backup.php I get this error message:
QuoteWarning: fopen(/home/virtual/site146/fst/var/www/html/yabbse/Sources/database_2005-10-22.sql): failed to open stream: Permission denied in /home/virtual/site146/fst/var/www/html/yabbse/Sources/create_backup.php on line 172
Before the hosting company enabled php safe mode I never got this problem and backup and restore worked flawlessly. It seems that it can't open/create the destination file now.
Quote from: Oldiesmann on October 21, 2005, 12:10:07 PM
Don't know why the create_backup.php and restore_backup.php files wouldn't work, but I'm thinking that the error message you posted earlier could be due to the difference in MySQL versions. MySQL 4.1.13 is newer than 4.0.23, so queries exported from that version might not work properly in MySQL 4.0.23.
In phpmyadmin, I've used the "mysql40" selection under "SQL export compatibility" in it's export menu to go from a mysql 4.1 to a mysql 4.0 database using both SMF and IPB databases. Worked perfect for me each time.
Quote from: Miyuki-chan on October 22, 2005, 10:40:21 PM
When I try to run create_backup.php I get this error message:
QuoteWarning: fopen(/home/virtual/site146/fst/var/www/html/yabbse/Sources/database_2005-10-22.sql): failed to open stream: Permission denied in /home/virtual/site146/fst/var/www/html/yabbse/Sources/create_backup.php on line 172
Before the hosting company enabled php safe mode I never got this problem and backup and restore worked flawlessly. It seems that it can't open/create the destination file now.
Having problems with mod_security? (http://www.simplemachines.org/community/index.php?topic=34270.0)
Sorry, no luck there. However I did find that the php safe mode is enabled at the master level and changing my php.ini file doesn't affect it.
EDITED...
For example if you have a backup of mysql databse 4.1.13-standard To be able to restore it you need The same mysql server (4.1.13-standard )[not one older..]
Tested by me An Work With NO ERORRS !
Hi 2 all.
Since I changed my server ( thenx for the guide in the first post ) everything went perfect expet a litle problem with this two characters:
ë and Ç
So the problem is that in my country we use those 2 characters and for some reason they do not apera and instad of them i see ⌂ squares.
Is not very big problem cause we don't use them a lot but if anyone has any idea what's the problem please let me know.
Have a nice day/night
Bye
gud day... can anyone please help on moving server, i have problem with customise avatars and file attachments? i've already copied the folders to the new location but it doesn't show... the files in avatar folder had extended the filenames, like picture1.jpg transform it to picture1_jpg_<additionalname>.jpg, does the smf application intend to rename the file? how could i restore this database
Try repair_settings.php
http://www.simplemachines.org/community/index.php?topic=18096.0
~redone
Great tute! Thank you Grudge and everyone who has posted in this topic! It went slickety slick. I transfered from one domain to another in about 20 min. Thanx again and Arriba SMF!!!
Don Diego :D
Hay guys,
Have just moved host!
But when i am uploading my theme.spl file into phpadmin it comes up with the error
SQL query:
PK9|}3߃smf_1themes.sql?W]sڸ}ϯ?o 3|ӊ?>?ĭ????y?-???䕤R?IӌɡЈ:犷^?+?ZP?ʉf??ü?1\WEyҪ?HE?n??k;WZ??N籱?m`ņ[X?m(=&2̖?i??N$֖+????{фnD?5?A??;yN?1|0>?~;l?=;r{s ߞ?{lt;?ƚ?XꅭE?\l'؟?秤`"?#???2]IK!Ao??튞͢aC2? ǿ?Ù ?t?&-? 9????~M`z7 CN??bN?Ӧ ?܄?x?o@ŕ}ि,?]㎦ɏ?
MySQL said:
#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 'PK' at line 1
Can anyone help me or talk alook?
Thanks
I cant get anything to work right, someone please help me!
www.DIPstickMagazine.com/smf
after running restore_backup.php i get these error codes on my forums
Notice: Only variables should be assigned by reference in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Subs.php on line 232
Notice: Undefined index: is_admin in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 556
Notice: Undefined index: permissions in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 563
Warning: in_array(): Wrong datatype for second argument in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 563
session_start(): Cannot send session cookie - headers already sent by (output started at /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Subs.php:232)
Quote from: thapres on December 08, 2005, 11:35:47 AM
after running restore_backup.php i get these error codes on my forums
Notice: Only variables should be assigned by reference in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Subs.php on line 232
Notice: Undefined index: is_admin in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 556
Notice: Undefined index: permissions in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 563
Warning: in_array(): Wrong datatype for second argument in /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Security.php on line 563
session_start(): Cannot send session cookie - headers already sent by (output started at /home/dipstick/domains/dipstickmagazine.com/public_html/smf/Sources/Subs.php:232)
PHP 4.4.0 Compatibility (http://www.simplemachines.org/community/index.php?topic=41955.0)
how do i use it if i cannot get into my admin center or the forums at all?
Ftp?
Yes, use ftp to upload the file attached in the first post of that topic to your /Sources directory.
Thank You Sooooooo much.
I just moved my forum to a new server, I'm a bit of a php hacker so I found the paths in settings.php and had changed everything there. Now I know there is a nice tool for next time though.
My problem is that I'm no longer treated as an administrator. I've tried my personal account (an account that normally has admin rights) and the administrator accountthe system was set up with. Neither are treated as administrators.
I scanned this thread and didn't see this problem reported by anyone else.
I care more about getting it fixed then finding out why it happened. SO if anyone could point me to the correct table to play with that would be nice.
If this is more of it's own thread splitting it off would be great too.
-update.
To clarify, it still lists my member group as administrator, and in the forummembers table my groupID is still 1.
I don't have the admin button and I can't look at users profiles though.
More of an update, I did
echo '<pre>';
print_r($user_info);
die(); in index.php after call_user_func(smf_main());
and it reported that is_admin is set to an empty array, from my reading of the code it should be true or false.
Well I'm not sure if the whole thing was selfe inflicted or caused by my ftp client but I reuploaded security.php and it started working correctly, the one odd thing was it reported that the path to the default theme was wrong (though it had been working). I'm leaving this post only because some one may find it useful.
ok i aint a programmer or have knowledge on php.. i just make basic html websites with javascript.. so im a novice at this..
just moved server today and decided to move the forum to the new server first... didnt know to come here and seek help... just got stuck straight into downloadin forum files and mysql database... now ive messed the forum up completely and i came here to seek help.. finding this forum i then realised about the converter.. uploaded the file and now its tellin me
"Settings.php cannot be written to by your webserver. Please modify the permissions on this file to allow write access"
what can i do.. my forum is located here (http://www.philipworld.1n1-webhosting.com/forum)
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
QuoteDatabase 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.
Have you tried repairing the table in phpmyadmin?
i did, and it still won't work. i can't even log in to my site
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?
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???
Quote from: deejaybet on December 18, 2005, 03:04:47 PM
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
Quote from: deejaybet on December 18, 2005, 03:04:47 PM
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? (http://www.simplemachines.org/community/index.php?topic=23690.0)
Quote from: akulion on December 18, 2005, 04:30:54 PM
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
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 :D
Quote from: Grudge on March 11, 2004, 09:20:52 AM
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.
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.
Quote from: zaandammer on December 19, 2005, 01:29:06 PM
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 ?
Quote from: zaandammer on December 19, 2005, 01:29:06 PM
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? (http://www.simplemachines.org/community/index.php?topic=18096.0)
Quote from: deejaybet on December 19, 2005, 05:36:01 PM
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.
Quote from: xenovanis on December 20, 2005, 09:20:40 AM
Quote from: zaandammer on December 19, 2005, 01:29:06 PM
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? (http://www.simplemachines.org/community/index.php?topic=18096.0)
Yes, I'd allready ran repair_settings.php as you could have seen in my earlier post. :P 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.
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 !
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.
Quote from: Vanilla on December 30, 2005, 01:32:53 AM
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 (http://www.simplemachines.org/community/index.php?topic=41955.0)
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! :D
Damm, I've done this prob a million times without problems but now i'm getting this error when importing a sql database:
QuoteSQL-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`
Quote#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
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?
So far I've followed all the directions in the first post but am having problems with this one:
QuoteYou 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.)
I just did upgrade to RC2 and move server. This instruction is still working well. Thanks for the clear instructions!
I upgraded to RC2, then backuped my files and database. Uploaded files and database to new server, used the repair_settings and everything seems fine :)
I cannot seem to find help elsewhere so I will ask here.
I recently changed hosts but kept domain.
- I downloaded my SMF mysql database backup and uploaded it to CPANEL on my new host.
- I upload all my current SMF files to the new host, including a post backup (makde with create_backup.php) and restore_settings.php
- I went to my forum, where I get this message: Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
I also tried making a new database, installing a new forum, and uploading the posts but nothing happened.
hey people... alredy posted here about moving my forum but ive moved it so many times da past few weeks and this should be the last time now if somebody could tell me which files n folders need to be writable.. many are set to 755 but the code i have to use now is 777.. please can someone list me files and folders to be writable?
@Outsider:
Did you upload your Database too? Into a Database of the same Name and Password? check your SMF settings... It should work too if you make a new installation, then upload your old database backup via phpMyAdmin tool
Quote from: DeeJay Bet on January 14, 2006, 02:41:35 PM
many are set to 755 but the code i have to use now is 777.. please can someone list me files and folders to be writable?
Installation guide clarification (http://www.simplemachines.org/community/index.php?topic=32991.0)
Urpg, I uploaded my databse yes, but with the CPANEL databse backup, as in PHPMYADMIN I cannot find an import tool, only export
I've been trying to actually move my forum to another server. As I couldn't figure out how to get the restore_backup.php working properly I tried to move parts. Everything has been moved but I cannot get the messages uploaded as this is about 12 MB. If I try to make chunks of about 2 MB each I get loads of errors. I guess I'm not correctly breaking it into parts, but how do I know I do this in the right way ?
Cheers,
Stuart
Please can somebody help me, I really need this :(
@Outsider
Sorry, i am not an expert and i check in here at most once a day. The Control Panel does only *export* your Database. Click SQL button in phpmyadmin (the one to the left between Exit and ?) then click import files. Select your Database. Click Go.
Thanks for showing me where, but I tried this and nothing seems to have happened :(
Quote from: Grudge on March 11, 2004, 09:20:52 AM
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.
How do I actually split the file correctly ? I just don't get it :'(
Each "INSERT INTO" represents an instruction.
1. Open two editor windows, for example 2x Notepad.
2. Open your file with the large amount of queries.
3. Select all text until line X
4. Cut this text
5. Paste it in the other editor, save that to a new SQL file. Then open a blank document.
6. Go back to the large file (which is now a bit smaller, of course), and repeat from step 3 until you're done.
Hope this helps,
Aaron.
Forum version: SMF 1.0.5
mysql 4.1
just changed servers but not domain
mirred everything
board worked fine under mysql 4.0
now forum loads fine but cant post or reply
i get "The board you specified doesn't exist" error message
also if i click on an individual "last post" headline
i get
"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 'new' at line 11"
some dective work reveals that when i watch the url at the botom of the browser
the board topic is ...1.0
but the new topic link is ...1.0.0
what went wrong and how to fix?
repair_settings didn't fix it
thank you
wouldn't be just easy to backup database and upload it to new location, then... make a new installation of SMF RC2? can i just copy and past the settings files, attachments?
let me know what you think.
I dont see a dump db feature in smf?
this help file looks great. how to I restore a database if my server dont my myphpadmin?
Quote from: Aäron on January 15, 2006, 01:13:29 PM
Each "INSERT INTO" represents an instruction.
1. Open two editor windows, for example 2x Notepad.
2. Open your file with the large amount of queries.
3. Select all text until line X
4. Cut this text
5. Paste it in the other editor, save that to a new SQL file. Then open a blank document.
6. Go back to the large file (which is now a bit smaller, of course), and repeat from step 3 until you're done.
Hope this helps,
Aaron.
Thanks Aaron, your instructions were very helpfull. At first I thought it didn't work, as I forgot to change the , into an ; at the end of each line (post). I also forgot to put:
QuoteINSERT INTO `smf_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, `posterTime`, `ID_MEMBER`, `subject`, `posterName`, `posterEmail`, `posterIP`, `smileysEnabled`, `modifiedTime`, `modifiedName`, `body`, `icon`) VALUES
before the (first) postnumber of the 2nd, 3rd and so on part.
Again, many thanks, as I was able to actually backup and move my forum completely :D
My host recently migrated my account to a new server. I was unprepared and now can't even get in. Whenever I try to access SMF, I get an email that reads:
There has been a problem with the database!
MySQL reported:
That's all it says. There's nothing after the :
Anyway, what can I do to fix it? If you can help, please tell me in baby steps and regular English as I'm no genius with this stuff - obviously.
Thanks.
Thanks for the tips. I've also found that backing up and restoring the database on the command line goes off much easier. The commands look like this:
To backup a database: mysqldump -u(db user) -p(password) (forum database name) > filename
To restore a database: mysqldump -u(db user) -p(password) (forum database name) < filename
I just switched from one server to another and did the following:
- backed up the database from the forum admin page.
- backed up all the files on my desktop via ftpx.
- used phpMyAdmin on the new host and imported the .sql file with no errors.
- uploaded all files to the new server via ftpx.
- downloaded the repair_settings.php file and uploaded it to my server.
- typed in the path to repair_settings.php and put in all my info
When I click Save Settings it pops up and says "Hacking Attempt".
I had no idea I could hack my own server. lol
All the database info is correct and I am pretty stumped. If someone could give me some advice that would be awesome.
I just moved from my linux box at home to a permanent location on a foreign server off my lan. My attachments directory is correctly set, but whenever I go into the admin panel and look at it, it shows it in bold red, as though there's an error. (The error log appears to be devoid of anything relating to this).
Naturally, no attachments show up, nor avatars.
Edit: SMF1.1 RC1
I'm not so much moving server as shifting the folder the forum is in. Currently it is www.brodiescastle.com/forums I want it to just be in root ie www.brodiescastle.com
is there a simple way to do this, I know it may be in here somewhere, I've been reading through but all seemed to be about server change and not just folder change.
I'm running SMF 1.1RC2 if it makes any difference. CanI just copy all files from one folder to another or is it more complex?
Cheers
Grab
Put your board in maintenance mode, move the files to the root (if you ask your host, they should do this for you), and then download and run repair_settings.php. It's available in the download section.
Of course, I don't mean move all of the files to the root, just move everything up one directory level.
cheers kegobeer!!!
will try that this arvo!!
with a nick like that you might like my board, it's beer related!!
As always, if your host provides a backup utility, perform a full backup in case disaster strikes. But I'm sure I didn't have to remind you. ;)
don't know what's going on but the repair_settings.php file won't download for me, is it available anywhere else?
cheers
Grabman
don't worry got it, bloody dimwit that I am sometimes~~~
just gave it a whirl on my test server, piece of cake, ,many thanks Kegobeer, you're a legend!!
I had a free host that must have left town with the server running. I just did a back-up of structure and data of my forum through SMF 1.1 RC1 admin panel. However, I cannot get into cpanel or ftp to the server. (password screwed up and no one to help)
Can I just ftp my forum back-up to a new host (godaddy), or do I have to first load SMF to the new host, or am I totally dead?
In case it is not obvious, I need basic detailed information. I am an SMF, MySQL, php dummy.
Thanks so much!
Quote from: Epimetheus on February 05, 2006, 03:28:50 PM
I just moved from my linux box at home to a permanent location on a foreign server off my lan. My attachments directory is correctly set, but whenever I go into the admin panel and look at it, it shows it in bold red, as though there's an error. (The error log appears to be devoid of anything relating to this).
Naturally, no attachments show up, nor avatars.
Edit: SMF1.1 RC1
Just to let you guys know, I ran the repair_settings.php file before I posted the above -- so no, that didn't help (except with smilies)
*edits because I found my answer* Thanks for the tut..I hope I can get it to work!
Ok, I followed everything to a T...backed up the db through the admin section and uploaded it though the myphpadmin...uploaded the backup to the new server...made sure the paths were changed on the settings.php and ran the repair_settings.php....and now when I go to my board this is the error I am getting...
QuoteTable 'chateauw_cork.smf_settings' doesn't exist
any idea's how I can fix this?
Hello there.
I relay need help so please someone help me...
I recently wanted to move to a Yahoo server and I don't know how to upload my database.
phpMyAdmin is installed on the system but I cant find anywhere a place to upload the database. Does anyone have any idea what should I do...
Thanks
Quote from: CrayZ on February 16, 2006, 10:20:45 AM
Hello there.
I relay need help so please someone help me...
I recently wanted to move to a Yahoo server and I don't know how to upload my database.
phpMyAdmin is installed on the system but I cant find anywhere a place to upload the database. Does anyone have any idea what should I do...
Thanks
Same question here, i cant find it on my phpMyadmin??
Quote from: CrayZ on February 16, 2006, 10:20:45 AM
Hello there.
I relay need help so please someone help me...
I recently wanted to move to a Yahoo server and I don't know how to upload my database.
phpMyAdmin is installed on the system but I cant find anywhere a place to upload the database. Does anyone have any idea what should I do...
Thanks
the easiest way to move your forum to a new server not using phpMyAdmin
and the converting from phpBB2 to smf:
1. create a new database on new server, name it DB_1
2. install SMF on DB_1 ( when installing, use table prefix smf_ ) ***Admin name needs to be same as phpBB forum
3. install same version of phpBB2 on new server on DB_1 ( when installing, use table prefix phpBB_ ) ***Admin name needs to be same as SMF forum
3. then go into old phpBB forum admin CP, and do backup database option (full)
4. log into new phpBB installed forum control panel, and do restore backup
5. verify phpBB forum has been restored correctly on new DB server by checking posts
6. then go into phpMyAdmin and check your tables..on left hand side you should see tables with both
smf_xxxx and phpbb_xxx
7. upload SMF converter via ftp to smf folders
8. run converter and your all set
I never had phpBB2 ::)
Quote from: tekgik on February 23, 2006, 03:40:33 AM
Quote from: CrayZ on February 16, 2006, 10:20:45 AM
Hello there.
I relay need help so please someone help me...
I recently wanted to move to a Yahoo server and I don't know how to upload my database.
phpMyAdmin is installed on the system but I cant find anywhere a place to upload the database. Does anyone have any idea what should I do...
Thanks
Same question here, i cant find it on my phpMyadmin??
Anyway I restore my database in this way.
1) First upload all the files to the new server.
2) Download restore_backup.php (http://www.simplemachines.org/community/index.php?action=dlattach;topic=37792.0;attach=7466) and upload to your root directory of your new server EX: http://www.yoursite.com/restore_backup.php
3) Upload your database in your root directory ( is just temporary there ) EX: http:///www.yoursite.com/complete_2006-02-14[1].sql
Note: I did it unzippedAfter you do those things go the address: http://www.yoursite.com/restore_backup.php and follow the instructions.
Note: On Yahoo servers the name
localhost mus be replaced with the word
mysqlIn the end of the page you have to put the path of your database: EX. /public_html/mysqldata.2006-02-22-05-32.sql
It will be fine in few minutes I believe.
The next step is to use the repair_settings.php (http://www.simplemachines.org/download/index.php?thanks;filename=repair_settings.php) and try to fix the new paths. Just take your time and I believe everything will work just fine.
Quote from: Epimetheus on February 11, 2006, 10:42:34 PM
I just moved from my linux box at home to a permanent location on a foreign server off my lan. My attachments directory is correctly set, but whenever I go into the admin panel and look at it, it shows it in bold red, as though there's an error. (The error log appears to be devoid of anything relating to this).
Naturally, no attachments show up, nor avatars.
Edit: SMF1.1 RC1
Just to let you guys know, I ran the repair_settings.php file before I posted the above -- so no, that didn't help (except with smilies)
Just letting you know that I havn't resolved the issue yet, so I'm still looking for help.
hello here is my problem
my host switched servers
i have mambo and smf integrated in him
they copy all my files to a new server
and mambo working but smf forum not
here you can see errors on www.bosanskibrod.net
my database is on new server and i tried to run repair_settings.htm but it did not work
my smf is smf 1.1 beta 3
please can someone tell what to do
thanks
---
i fix this. its ok now
i dont know how when or how :) when i changed to my old pass everthing was ok
Quote from: Epimetheus on February 11, 2006, 10:42:34 PM
I just moved from my linux box at home to a permanent location on a foreign server off my lan. My attachments directory is correctly set, but whenever I go into the admin panel and look at it, it shows it in bold red, as though there's an error. (The error log appears to be devoid of anything relating to this).
Naturally, no attachments show up, nor avatars.
Edit: SMF1.1 RC1
Just to let you guys know, I ran the repair_settings.php file before I posted the above -- so no, that didn't help (except with smilies)
So after some time, I decided to figure out what the problem was by doing a search for "404 - Attachment not found" strings in the sources files, this then implied my $filename for the attachments was non-existant when I called them from the forums... so I modified them so that they should still exist... frustrated, I still couldn't get it to work, so I tried to figure out why the directory field in the admin panel was red -- this didn't get me too far, but I looked at the error logs, and by miracle, a user tried to upload an avatar to no avail -- the directory was write protected. So, I made it writeable. And it's worked since.
I figured I'd share only because I'd hate for someone else to go through the same trouble, let alone someone who doesn't have any PHP experience.
Hello!
I need help
How do I move the forum to a new domain on the same server?
I have multiple domains, each has it's own root directory under the main root
I can simply rename the root directory were the forum's .php files are, but I believe it is not sufficient
Just thought Id outline how I moved my forum to a new server, with little or no stress at all!!
1) Backup / Download forum database
Now as my forum was huge I had loads of trouble using various tools, but found one
XT-Dump to be extremely useful, its scripted to pause upon server overloading (like SMF install) so there is little or no chance of page time outs.
Its also best to save as a gzip
2) Using an FTP client, download all forum files to hard drive, i.e mysite.co.uk/forum
3) Upload all these files to new domain directory i.e mynewsite.co.uk/forum
4) Create a new database on the new server
5) Upload forum database
Firstly you will need to install XT-Dump on the new server so you can use it to restore the database you downloaded from the old one.
There is a "dumps" directory that you will need to upload the original database too, using ftp client.
Once installed simply log on to your new database, click "restore database" and select the item you want to restore from the drop down menu.
It will then reverse the procedure seen in step 1 and hopefully with no problems, the database will be restored and your new server will work fine :)
Remember to use repair_settings tool to point forum to new database, and you will need to tweek a few directories in forum admin to make the site function properly.
Hope this helps anyone, and sorry if its been posted before!
GZIP IS WEAK.
i'm using 1.0.6 and i made the mistake of backing up my forum tables with gzip. now i get this error when i try backing up the database using phpadmin and the restore_backup.php file:
QuoteSome of the queries were not executed properly. Technical information about the queries:
Line #159: 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 '<table width="100%" cellspacing="0" cellpadding="0">
<tr bgcolo
Line #185: 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 'w'3gÜUÚÈ}ª\Œ •"vÇ|¡Lž,,ˆï3R'‰#¢, ²fÓôr™º¸¹?' at line
Line #621: 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 '´ ¥Ù3Š-WÁsË/AÕή#½' at line 1
Line #803: 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 '6¸"'ž9/ô:†^| O5]ô0B£¾[Ù#S˜þÃ<}˯Éy`ð9j¨ÀOZC...^ÌËÄ'F4|ú¾_Qòö|3K
Line #1449: 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 '^ìKˆèB]EÞ*2ó4MÒ<òàl K-Ÿð}1Iö4L,W˜/ëËVú MQRtï:4§ öKÆÙ>|,,ò
Line #1485: 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 'çòMß9b ýTÑç £¢C>»å€‡ÈJK_&' at line 1
I've moved server and I've tried using repair_settings and editing settings.php directly, both ways seem to make the changes on the new servers database.
However I go to www.example.com/forum/index.php and get "Connection Problems".
I go to www.example.com/forum/ and get a few mysql errors such as:
Warning: mysql_connect(): Access denied for user: 'olduser@localhost' (Using password: YES) in /home/olduser/public_html/socks/cms/index.php on line 18
Where olduser@localhost and /home/olduser/ are clearly my old old settings.
Why is SMF reading the old settings and from where?!!!!
Either you're seeing a cached version of the page, or there's an issue with the DNS someplace. If the error message is showing an old path, then it wouldn't be a problem with SMF.
Hi!
i just moved my smf to a subdomain
i run repair_settings and i did everything according to what it said but i cant make the theme to work,
i mean that the page loads with the specified colours but the images dont,
if i open the link directly for an image it works but when its called from the theme it doesnt work.
the url is www.kitespot.gr/forum
couls it be anything with permisions?
i found it,
i didnt change the paths at .htaccess
I have upload my SQL and folders from old to new server
http://203.117.178.43/~rc-ms.com/forums/index.php
but i have an error msg
Warning: main(/home/rcvmsb0/public_html/forums/Sources/QueryString.php): failed to open stream: No such file or directory in /var/www/html/forums/index.php on line 51
Fatal error: main(): Failed opening required '/home/rcvmsb0/public_html/forums/Sources/QueryString.php' (include_path='.:/php/includes:/usr/share/php') in /var/www/html/forums/index.php on line 51
It looks like the path specified in your files is for the old server. Download repair_settings.php from the downloads section and run it. It will change all the paths from the ones used on your old server to the ones used on the new server.
We went from /home/httpd/vhosts/account_name/httpdocs to /home/account name/public_html/ and it was all fixed by using repair_settings.php.
Another thing to check is the database name and user, some hosts user dbname and dbuser and others use accountname_dbname and accountname_dbuser.
Ic .but what is did is download a fresh new SMF..and install it back again to the server...and also using the old My sql files...its now able to view the page...on the test server and new host but the attachment is all missing.....
What can i do
8: Undefined index: lang_character_set
/var/www/html/forums/Sources/Load.php
808
I have this error msg...why should i do? please help
I'm not sure what is causing the problem, but maybe this will help.
When you downloaded the new SMF install was it the same version as your old site? I know owith some newer versions there is some database changes that are done while upgrading from the older version to the newer version. If you used a newer version you could try installing the same version you were using and restoring the database again. If that works then you can upgrade to the current version.
That's about the only thing I can think of. I hope you get it working soon.
i use easyphp to restore my forum backup from my site that is now offline
but i followed all the steps but the forum isn't changed,no messages or others things...nothings happenend
doesn't it work for easyphp?
Quote from: sirius on January 20, 2005, 01:18:59 PM
quote :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. .....
nice but there are NO import option on my new lame server in PHPMY admin. Only export.
Even I cant find Import option, current options are
Show processes
Storage Engines
Databases
Export
Log out
Hi Grudge
I am trying to export my database as well but I do not see
Dump Database -> Dump all
under forum maintenance
thanks
dave
drdave use restore_backup.php (http://www.simplemachines.org/community/index.php?topic=18350.msg168327#msg168327)
Thanks Jay but I already switched DNS [still propagating]
Can't I just restore the database back up I created under Maintenance once i reinstall the forum?
If so, can you provide steps or docs on how to accomplish this?
Thanks
Dave
No the only way would be wiht restore_backup.php or using phpMyAdmin. There is no built in feature in SMF to restore a backup.
where can i find ''repair_settings.php'' ???
i checked my forum but theres no repair_settings.php ???
where is it??
I did a search in google because I couldn't find it either.
The search of course brought me right back to the download automatically.
Try this or search in google for "download repair_settings.php".
http://www.simplemachines.org/download/index.php?thanks;filename=repair_settings.php
I found that much easier to get to it.
dave
everything worked but
forums/index.php?action=manageattachments << does not work
Cannot access attachments upload path! < this always comes out
and all my attached files cant be downloaded anymore....help anyone?
'drdave'?? :D
Sounds like maybe the script did not find the paths to the ManageAttachments.php script
Not sure why repair settings missed it. At least that seems like what happened.
It might be a matter of a manual fix but which script the path is under might be a matter of checking them and changing the pointer from there.
Also double check your paths. It might still have the old server info.
I just switched host too and that was my problem.
Dave
Hi all! Here is my problem. I have downloaded all of my files, dumped the database, and re-uploaded the files to the new server. All of that went fine. The problem is that with the host that I use(godaddy) doesn't have things set up like the examples here. I have to create a database then login to phpmyadmin. I did some digging in there and finally found something that said import. Found the file on my computer and hit"go". Then I get a this " Error Message #1044 - access denied for user "my database to database 'my other database" . I no idea what to do now. I am still very new to all of this and feel completely lost. Any ideas? Thanks!
*** UPDATE***
Okay I have since gotten the database to import. Now the problem is that my site still doesn't show up. Now for the silly question, do i need to run install_php on the new server? If so should I have done before importing the database? I no very little about this and trying to learn as I go. Thanks!
It's looking fine from here :)
OK half the problem is that my host is taking it's sweet time. So I have to wait until it's finished setting up to see how bad I've messed things up.
Everything is swapped over to the new server. No errors but things don't look right. Anybody care to take a look for me and give ideas. http://www.thelockerroomforum.com Ran repair_ settings and it still looks like this. It's to wide and the top part is really messed up. Newbie here so please explain in a simple manner. Thanks! :)
i have no errors as well, but the users online is all messed up? How do I fix this?
Just moved my board to another server.. seems to be working ok except for 1 thing:
(http://rated-r.newnoize.nl/error.JPG)
Notice the time/date, and everybody who's actually online shows up offline.... :-\
Using phpMyAdmin delete the log_online table and create it again.
Quote from: JayBachatero on May 10, 2006, 03:22:50 PM
Using phpMyAdmin delete the log_online table and create it again.
just create an empty table?
i found this in another topic:
Quote from: JayBachatero on April 29, 2006, 02:28:57 PM
Drop the lod_online table and insert it again.
CREATE TABLE {$db_prefix}log_online ( session char(32) NOT NULL default ' ', logTime timestamp(14), ID_MEMBER mediumint(8) unsigned NOT NULL default '0', ip int(11) unsigned NOT NULL default '0', url text NOT NULL default '', PRIMARY KEY (session), KEY online (logTime, ID_MEMBER), KEY ID_MEMBER (ID_MEMBER) ) TYPE=MyISAM;
Thnx, i'm gonna try it right now
Yes it <censored> works!
Thank you thank you!
It seems only my post count isn't working now after I transfer my boards to a new domain. Everything else works fine.
Just had to fix 200 errors and not a single one of them fix the post count.
Any help here would be appreciated.
http://www.shadowfleet.info/
I moved my forum to an another host. Everything works fine except the attachments. On the last host, the root was www-host/l/f... here (the new place) i changed it to //attachments. I thoght its ok because all of the attachments were shown, but if i wanna a new one, i write the reply i set the attachment, and i post it.
Its thinking, and when my reply will shown in the topic, there is no attachment.
What can i do against it. plz answer.
thx blez
first check ur CHMOD settings
this is the 777 thing?
yes that thing, and yes i think it should be 777
its 777. i dont know what is the problem with it. im so annoyed :-[
and it doesn't give any error AT ALL?
Otherwise check your "Forum Error Log" in the Admin section..
some servers are set up so that 777 won't work, this is a security issue
try 775 and make sure your paths are correct.
Quote from: RatedRoberto on May 19, 2006, 06:29:10 AM
and it doesn't give any error AT ALL?
Otherwise check your "Forum Error Log" in the Admin section..
http://users.atw.hu/pmax/index.php
8: Undefined index: sbox_ModTitle
File: /Themes/default/sbox.template.php (eval?)
Line: 13
this is the only one what i get, but it comes all the time :D
775 isnt my friend :S
i dont where to find the problem.
sorry for my poor english i hope every1 understands me, and my problems
i'm sorry, typo---0755
my bad
still bad. any idea? re upgrade will help my problem? It wont ****** up my installed mods ,and database?
Look and see if all the file paths are correct also. Those can get messed up in a server move.
use repair_settings.php and make sure that all of the paths are correct.
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
whoaaaaaaaaa. still nothing!!!! aaaaaaaaaaaaaa im so angry.
can i find something in sql tables about attachments, or where should i see.
Can you please PM me a test admin account for the forum and FTP access?
Quote from: JayBachatero on May 21, 2006, 04:07:22 PM
Can you please PM me a test admin account for the forum and FTP access?
sent
Fixed.
Quote from: JayBachatero on May 22, 2006, 09:18:35 AM
Fixed.
Are u sure? :D I still cant attach anything. Sorry for the bothering.
try to attach a picture or something where you want.
That seems to be a theme issue. You overwrote your default theme with the theme you have now. I suggest that you copy what you have now and reupload the default theme.
I reuploaded, and re upgraded the whol forum, but its still dont work. I give up.
PLZ an expert plz help. I choose this forum engine because of the attachment, and now it wont work.
I installed on a different host a complete 1.1 rc2 forum. There ive got the same problem. There are no mods, no old databases, nothin just the raw forum. And the file attributes of the attachment dir is 777
It works fine for me. Make sure that you are using the default theme.
http://users.atw.hu/pmax/index.php?topic=2.0;theme=1. Those attachments work for me.
:D yepp. But the main problem is with the new attachments. I can use the old ones, but if i wanna attach a new a file it wont work. No error messages, it doin it the normal way, but no attachment in my post.
Quote from: JayBachatero on May 24, 2006, 09:32:17 AM
It works fine for me. Make sure that you are using the default theme.
http://users.atw.hu/pmax/index.php?topic=2.0;theme=1. Those attachments work for me.
I don't know why my post from yesterday disappeared. Let me try again. I was going to try and move my forum from /forum to the root, but after reading this thread I think I'll leave well enough along.
Your help to people is quite wonderful. I don't know where to ask this question, so hope I'll be forgiven if it's in the wrong place...
In Epsilon I need to put an Information Box
between the Logo and Menu Box which you can see in this example from Bloc's site, i.e., shift the Menu Box
down so I can put the new box in the resultant space.
(http://twm.cc/forum/images-extras/tp-002.jpg)
This is the code I've put in style.css for this new box:
#abovemenu
{
background-color: #F8F9FC; /* abovemenu bg. rgb(248,249,252). palest gray */
margin-left: 4px;
margin-bottom: 4px;
/* color - hmm... unclear how to do text color here??? */
padding: 8px 0px 8px 0px;
}
In index.template.php I can insert
text by writing:
echo 'This is a test';
above this part of the code there:
// the menu
template_menu();but that doesn't help me with my box, of course.
I can't figure out where to put, or how to write code to
bring in the Information Box (which I've called 'abovemenu') from the style.css. Everything I've tried either gives an error or is ignored. ::)
I don't understand the interaction between the half dozen of so .php files as to which 'leads on to the other', if you see what I mean, so likely I'm even in the wrong file... This is all very new to me.
If you can help I'll be most grateful. Thank you!
Quote from: blez on May 25, 2006, 02:58:02 AM
:D yepp. But the main problem is with the new attachments. I can use the old ones, but if i wanna attach a new a file it wont work. No error messages, it doin it the normal way, but no attachment in my post.
Let me try adding attachments again and see.
oneway I moved your topic and replied to it.
Blez your problem might be related to the image shack mod. Uninstall it and see if it works.
Quote from: JayBachatero on May 25, 2006, 09:13:00 AM
Blez your problem might be related to the image shack mod. Uninstall it and see if it works.
I installed it after the attachment problem.
Can you please remove it to test if that is the issue?
Removed!! And thx again for your patience.
Did that fix the issue?
nope :(
Can you post a link to your phpinfo.php? It might be host related.
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0).
Can you please make a fresh install of SMF in another dir and check if you can upload files.
It shoulb be the host. I tried another forum aon a different adress but the same thing you know blabla.atw.hu and the attachment wont work there too.
Is it possible too save the attachemnts to the old host?
You mean host the attachments on another server? It can be done most likely but not sure how. My suggestion us that you look for a better host. That frame they put is very annoying.
Quote from: Grudge on March 11, 2004, 09:20:52 AM
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.
Thank you for this post, it helped me move my SMF installation from my local machine (with XAMPP running) to my web host's server. I exported the database using the local phpMyAdmin, and when I imported it, it gave me all sots of parser errors. After I read the bullet on exporting it using the Forum Maitainence screen, I immediately did that, and low and behold it worked. Thanks again.
ok ive spent waaay to long trying to fugure this out :(
Followed grudges instructions but got stuck on the db import.
installed new forum on new server...and tried to import backed up db...still no luck.
new server is with 1&1 ( think they great company before we start the convo again lol) and using uploaded phpmyadmin does not work...i get error msgs.
if i use phpmyadmin throught the control panel...then click query sql..then import...it appears to do nothing. If i click on the import table section it again appears to do nothing.
i finally found restore_backup.php and thought this was my answer...all went well until i recieved this error msg:-
Some of the queries were not executed properly. Technical information about the queries:
Line #4946: Invalid default value for 'logTime'
Line #4963: Table 'db165546601.smfdiggirl3_log_online' doesn't exist
Restoration process complete!
Congratulations! Your database backup has been restored successfully.
Attempt to fix the database's paths for this server.
Upon going back into my forum there is stil no change :(
Could someone pls explain to me in obviosuly what i need to be laymans terms :-\ how i get the important stuff from my hard drive upto the new installed forum?
I am using 1.0.7 on both forums.
Any help be appreciated...
Thx in advance.
so i guess no one can or wants to help then?
Try using bigdump.php.
http://www.hotscripts.com/Detailed/20922.html
Thx..before i try that though..maybe this wil help you also.
I started again...uploaded the old forum files to the new server...created new db...managed to get the old db imported :) , ran repair_setings.php...ammended the paths etc...and then tried the forum url...i then got this error :(
Table 'db166154744.smfdiggirl3_settings' doesn't exist
Any thoughts?
Seems like your backup wasn't complete. Export the settings table and import it to the new database.
problem solved :)
was the prefix on the db causing me the problems with 1&1, they obviously dodnt like it.
soon as was removed the foum sorta came back..more fiddling around changing settings etc and ive got her back up and ship shape.
Thx all for help :)
Ive been trying everything I have read here and I still get nothing. :(
im moving my current forum to godaddy, has anyone figured out how to install this on godaddy?
i had it to work for 20 minutes then it blipped out from a fresh upload, then deleted everything and gave up.
Now I uploaded a fresh install of SMF and cant get the install.php to work.
just going to have to start over since i cant get the old forum moved over being untrained and unsuccessful at the move.
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
In GoDaddy the host has to be the IP that they give you not localhost.
i did that too. still get errors.
I get a syntax error also when uploading the old forum database file through MySQL also.
what error do you get?
some syntax type error, I will try uploading the forum .sql file again and get back to you with the error when i go into the MySQL.
i have done both pages of these directions on moving my forum step by step.
both using ftp through internet exploder and using coffee free ftp.
i uploaded the complete_smf_Sql file
Ran the repair_settings.php
did everything step by step and all i get is this
http://washingtonfishingfools.com/forums/
the database name is smf7 not phishisgroovin also.
Found out the FTP program only uploaded the folders, not the files within them.
so I just uploaded everything folder by folder and ran the repair setings & now i get smf cannot connect to the server.
i have my forum installed on mysql***.secureserver.net and hit all the suggested links in repair settings and still nothing.
EDIT: ok, now when i hit my forums addy. all I get is an error and an email saying:
There has been a problem with the database!
MySQL reported:
Table 'smf7.smf_settings' doesn't exist
This is a notice email to let you know that SMF could not connect to the database, contact your
host if this continues.
Why does this stuff have to be such a pain in the rear.
Heres the directory paths godaddy's crappy support gave me. I have a year already paid to these guys and I need to use it instead of the crashing all the time evolutionhostinguk.com (JTM Computers.com). I just want to get this running and dump JTM.
----------
MySQL Server Database Connection Settings
Description:
This example describes using PHP to connect to a MySQL Database on a Linux hosting account.
<?php
//Connect To Database
$hostname="mysql127.secureserver.net";
$username="smf7";
$password="your_password";
$dbname="smf7";
$usertable="your_tablename";
$yourfield = "your_field";
mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$name = $row["$yourfield"];
echo "Name: ".$name;
}
}
?>
i give up.
DId you try bigdump to import the database information into godaddy?
I have been sitting here at the computer since around 8:30 this morning, its now 9:27 pm and I have gotten noplace.
I dont know how to run nor edit these files to work on godaddy's fikked up hosting. But I have a year prepaid already to figure it out.
I am busting my butt trying to learn all this as fast as i can, but I give up. im a plumber not a programming person & in a real hurry to drop the secondary hosting i have that always crashes just about daily. im at witts end.
I am moving my site to dreamhost to a third-level domain forum.boo.uz (before changing DNS on old one), i put the old one to maintenance, uploaded the new one. I am running SMF 1.1 RC2... so I changed all the paths accordingly. However, attachements & some avatars are not shown. I tried repair_settings.php, did optimise/repair from forum maintenance - no help. Than tried "File maintenance"... but it removed all attachements from the board! Had to reset the sql to the backup and reupload all the files again.
attachment dir's permissions are set to 777 (i also set the files to it as well, just in case).
I've spent a lot of time with this. Anyone, faced this sort of problem? Please help.
You all were really helpful but may be someone knows any other solution?
Umm check your attachments dir and see if the attachments are there.
Heh, thanks... Found the problem.
My FTP clients (SmrtFTP, FlashFXP) were showing as if there were 2,000 attachements. In reality there were a looot more... I noticed it by checking the dates the files were modified. My attachements dir grew to 17 000 files totaling 1 Gig. For some reason FTP clients woulnd't show more than 2000 files (on Hostgator) so I was not actually moving all the files. Had to do Full Backup through Cpanel. Regards for your help anyways!
I hope it would be useful for someone else.
Quote from: Jay The Code Monkey on June 18, 2006, 09:49:55 PM
DId you try bigdump to import the database information into godaddy?
that bigdump is pretty cool, it moved a 304mb database into my phpmyadmin, real slick.
I have moved my website to another server and i have done every thing it was said in the topic.
When i go to my forum I get this error message:
Unknown column 'art.ID_THEME' in 'field list'
any body can help?
thx
CuTe_MaN
pls help in finding the solution for cute problem. we need the forum to return back to life,
this is the massege:
http://uaeu.org/smf/index.php
and this is the site before the problem.
http://uaeu.org/smf/index.php?action=forum
:)-
I L F
Seems like some tables were not imported properly. Download a backup and reimport it on the new site.
I am following this advice, but am having issues. I am transfering from a linux machine on gate.com to a windows machine at 1and1.com ... i really don't know what the built in Dump feature does in the gate.com's SQL manager.. but whatever it does, it seems to stick in random text into the dump file which causes myPhpAdmin to not read it properly. I keep on getting bad syntax errors when trying to upload... and yes, I am seperating the file at the end of the lines and only uploading a small section at a time.
I am currently going to try to install myPhpAdmin on the gate.com host to see if i can maybe use that instead of the built in Dumping process.
anyone else ever run into this?
I am moving my forum from Xsorbit to SMF and using Bigdump to upload more than 200MB SQL to Godaddy.
After running bigdump.php, I got the following error.
-------------------------------------
Error at the line 26: ) TYPE=;
Query: <br />
<b>Notice</b>: Undefined index: Type in <b>/home/xsorbit/public_html/users5/brokebackmountain/Sources/DumpDatabase.php</b> on line <b>303</b>CREATE TABLE `brokebackmountain_attachments` (
ID_ATTACH int(11) unsigned NOT NULL auto_increment,
ID_MSG int(10) unsigned NOT NULL default 0,
ID_MEMBER int(10) unsigned NOT NULL default 0,
filename tinytext NOT NULL default '',
size mediumint(8) unsigned NOT NULL default 0,
downloads mediumint(8) unsigned NOT NULL default 0,
PRIMARY KEY (ID_ATTACH),
KEY ID_MSG (ID_MSG),
KEY ID_MEMBER (ID_MEMBER)
) TYPE=;
MySQL: 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 '
Notice: Undefined index: Type in /home/xsorbi
-------------------
Can anyone help please?
Any Body Can help me in my problem????
I have changed my domain now
it is www.uaeuclub.com/smf/index.php
please help
my website is off now for few weeks
Quote from: CuTe_MaN on October 18, 2006, 05:31:23 AM
I have moved my website to another server and i have done every thing it was said in the topic.
When i go to my forum I get this error message:
Unknown column 'art.ID_THEME' in 'field list'
any body can help?
thx
CuTe_MaN
Seems like some tables are missing. Try restoring the backup again.
I have restored it more than one time and always the same problem
I have fixed the problem by uploading new files and running the upgrade.php file
then i reinstalled the Tiny portal again and at that point i got the error message
so any body can help?????
thx
CuTe_MaN
Sorry for butting in on this post, but I can't find the "repair_settings.php" file anywhere. Is there somewhere I can get it directly. I'm running 1.1 Final.
Many thanks
http://docs.simplemachines.org/index.php?topic=663
Thank you. You're a star
I Moved my websites server to new server. I used repair_setting.php and made some changes. Everything works fine but, in Arcade Section games are opening but score is not submitting. Can any one Solve this Problem.
Just Curious, but to save time with FTP, would it work to just install a brand new forum, Use the SQL from the old forum, and replace the settings.php and settings_bak.php Files on the new install with the old ones?
Nvm, tried it myself. No need to swap out the Settings.php Files, just make sure you Dont Overwrite the Settings Tables in the SQL in the target install. I just took the Non Settings files from old Forum, Downloaded them, Overwrote them onto the New One leaving the Settings Tables Untouched. Just Another Roundabout way for those who prefer not to play with downloading and uploading your entire forum with FTP, Just WebInstall a new forum, Backup old forums Relevant Non Settings Tables, Overwrite new Forums Tables.
Hi there!
I got a problem exporting my database (SQL) because my forum is in slovak/hungarian language.. where can i set the encoding or something at exporting?
Thanks!
I've just moved my SMF 1.1.2 with TP from one host to another and one domain to another and on the whole it has been a rather painfree affair.
However I have now run into a problem. I am trying to install a new mod and I get a message saying that the file is not writeable. I've gone through the install doc and c'mod all files/folders listed to 777 but it still does not work.
What's the best way to solve this? Upload a fresh copy of SMF over the old one and try to run upgrade.php?
Quote from: warhonowicz on March 26, 2007, 07:00:25 AM
However I have now run into a problem. I am trying to install a new mod and I get a message saying that the file is not writeable. I've gone through the install doc and c'mod all files/folders listed to 777 but it still does not work.
i believe with packages you chmod the Packages folder and a file in that folder called installed.list to 777
They both are set to 777 ... :(
Quote from: warhonowicz on March 26, 2007, 08:15:43 AM
They both are set to 777 ... :(
i'm just troubleshooting here, but have a look at this thread (http://www.simplemachines.org/community/index.php?topic=28393.msg354086#msg354086) and see if it helps.
I am moving from one host to another. I uploaded all the files, finally got my large database imported, then ran repair_settings.php. Everything seems to be correct, not getting any "connection problems" error messages from repair_settings. $boardurl is correct.
I have not yet transferred my dns, so am using the IP numbers for my path.
When I go to the index page I get:
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
Do I need to do something else?
did your database information change with the new hosting by chance?
Quote from: metallica48423 on March 27, 2007, 08:36:48 PM
did your database information change with the new hosting by chance?
$db_server changed (is not localhost), others are correct. When I make wrong changes with repair_settings.php, I get the error "Some settings are not being shown because the MySQL connection information is incorrect."
I get the no connection problem on the index when repair_settings is not showing that error.
Aside from the MySQL Database Info, everything is recommended value.
I have an install problem and am still reading through this post...
I have installed a fresh install of SMF (and MKPortal) on my site, they both installed fine.
I have been given a backup.sql file from a previous installation of the same software on a different server.
To restore the backup.sql file I used phpmyadmin. I dropped all the existing tables in the database created from the fresh install, then imported the backup.sql file, which worked ok and made all the tables etc.
Now I get this error message when trying to access my site:
"Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."
Any ideas what to do next?
EDIT: Sorry, I just realised my problem is the exact same as jstark's above, looking forward to any help you can give
Quote from: Lostintranslation on April 17, 2007, 06:15:00 PM
I have an install problem and am still reading through this post...
LIT, I can't remember exactly what was wrong, but I did have a setting off. Run repair_settings.php and doublecheck all paths and passwords. If you don't have a whole list of paths, something isn't set right.
Then once you do get it connected, go through all the admin tabs and make sure all of those are correct. I'm still finding smaller items that didn't transfer correctly.
Please help, i am importing my database to a new server, and its giving me an option to chose for "Character set of the file", like ASCII, BINARY, utf8, bog5, etc... which one should i choose?
okay this is the error i am getting,
Error
SQL query:
# ==========================================================
#
# Database dump of tables in `smf_forum1`
# August 02, 2007, 11:49:32 AM
#
# ==========================================================
#
# Dumping data in `smf_ads`
#
INSERT INTO `smf_ads` (
`ADS_ID` ,
`NAME` ,
`CONTENT` ,
`BOARDS` ,
`POSTS` ,
`CATEGORY` ,
`HITS` ,
`TYPE` ,
`show_index` ,
`show_board` ,
`show_threadindex` ,
`show_lastpost` ,
`show_thread` ,
`show_bottom` ,
`show_welcome` ,
`show_topofpage` ,
`show_towerright` ,
`show_towerleft` ,
`show_betweencategories` ,
`show_underchildren`
)
MySQL said:
#1046 - No database selected
here is another error i am getting, this time when i backed up my database i selected the table structure as well, and now i am getting this error,
Error
SQL query:
# ==========================================================
#
# Database dump of tables in `smf_forum1`
# August 02, 2007, 12:44:45 PM
#
# ==========================================================
#
# Table structure for table `smf_ads`
#
DROP TABLE IF EXISTS `smf_ads` ;
MySQL said:
#1046 - No database selected
now i am importing directly from the backup.sql file not the zipped backup. i am not sure if this makes any difference.
Thanks in advance.
I am sorry for posting to many times, but i need to note that i have MODS installed, do i need to uninstall the mods before i export the data?
did you actually select a database in the left pane to import INTO before you attempted to import? :P
this link doesn't work
www.yourforum.com/repair_settings.php
well, no, it wouldn't. You need to replace yourforum.com with a link to your forum.
metallica48423 , i think i did, i used the backup from the Admin> Forum Maintenece then dowmload the backup! am i doing this right?
repair_settings won't restore your database. you'll need to import it in phpmyadmin. (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0))
1.) Login to phpmyadmin
2.) in the left pane, select your database (if its not there, create it, if your server uses cPanel you'll have to create it with cPanel and create a user for it)
3.) click 'import'
4.) select the file to import from
If your database file is too big for the server to handle you may have to use a script such as bigdump (search google)
QuoteIf your database file is too big for the server to handle you may have to use a script such as bigdump (search google)
.....or the restore_backup.php tool. Here bassbass will find where to download those files and a description of how to use them
Restore_backup.php tool created by Unknown, which can be found attached this post (http://www.simplemachines.org/community/index.php?topic=18350.20)
Upload the restore_backup.php tool to the same directory where your smf files are,point your browser to it and follow the instructions.
i.e. www.yoursite.com/forum/restore_backup.php
Note that ''forum'' stands for the directory where your smf files are located. If your smf files are located to same other directory, then replace ''forum'' while pointing your browser with the name of that directory.
Or if your smf files are in the root directory, then point your browser to:
www.yoursite.com/restore_backup.php
BigDump: Staggered MySQL Dump Importer (http://www.ozerov.de/bigdump.php)
Quote from: Grudge on March 11, 2004, 09:20:52 AM
• 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.
There should be an automatic file splitter. (My database is 130 MB.)
this is very helpful... thank u
Thank you!!! This article saved me a LOT of trouble and cleared up a lot of headaches!
Thank you for writing this up!
Hi, just been pointed over to this thread to help me move my SMF forum.
Im stuck on step 2 " Download all the files from your current forum folder onto your computer (using an FTP client)."
Where is my current forum folder? I originally took advantage of the chartered member offer where SMF was installed for me to share my joomla site database if I remember correctly.
I don't need the Joomla site anymore and now want to copy this site to an SMF only (no joomla) forum site.
Hope this info helps me get the answer I need as I really haven't a clue what Im doing here.
Quote from: KolaKube on November 17, 2007, 02:22:04 PM
Hi, just been pointed over to this thread to help me move my SMF forum.
Im stuck on step 2 " Download all the files from your current forum folder onto your computer (using an FTP client)."
Where is my current forum folder?
Your current forum folder is whatever folder your smf files are uploaded. i.e. if your forum urs is www.yoursite.com/forum-path/ then the name of the ''forum-path'' is the folder you need. Does it make any sense to you?
Hi babjusi, yes it makes sense mate.
My forum is http://www.1stkontact-lanevents.co.uk/smf-forum/
So, your saying anything related to SMF in the smf-forums folder.
I used cuteFTP to access this folder and it says its only 4k in size? Is this correct? We have over 8000 posts?
Yes, all your smf files are in that folder, ''smf-forums''. Now, are you switching hosts or you want to have your forum at the root directory, i.e. http://www.1stkontact-lanevents.co.uk instead of the current url: http://www.1stkontact-lanevents.co.uk/smf-forum/
Sorry for late reply babjusi. Working last night and just got up after it.
I want to copy my forum from here http://www.1stkontact-lanevents.co.uk/smf-forum/
and make an exact copy here
www.1stkreative.com
I have allready installed SMF with fantastico on 1stKreative. Should I delete this install?
You will need to backup your database (http://www.simplemachines.org/community/index.php?topic=184356.0) and then import it to the new server.
Migrate the SMF files over to the new server via CuteFTP (copy everything from the SMF folder on your old server and copy it to the new one).
Then use repair_settings.php (http://docs.simplemachines.org/index.php?topic=663) and make sure that the database information is correct. Then click on the Recommended values. Save the changes. That should restore your forum back to working order. Delete the repair_settings.php file once you are done.
Hello greyknite
Do I need to import the database over to the new site first or after I have cute FTP'd the stuff there?
Also, does this need to be done to a clean directory or one with SMF allready set up?
Quote from: KolaKube on November 18, 2007, 07:42:04 PM
Hello greyknite
Do I need to import the database over to the new site first or after I have cute FTP'd the stuff there?
Also, does this need to be done to a clean directory or one with SMF allready set up?
Have a look at the very first post on this topic, and you will find the answers to your questions there
doh! Never thought of that.
Can I just clarify my SMF folder is only 4k in size?? This seems very small for an 8000 post forum?
Yes, that seems kinda odd
4k isn't even a word doc.
Im wondering I think my SMF forum shares its database with my Joomla website (or at least I think this is how it was set up via the SMF customer support team) Would this mean my posts are else where?
Quote from: KolaKube on November 18, 2007, 08:06:26 PM
4k isn't even a word doc.
Would this mean my posts are else where?
No, they should be at the same database that you used while installing smf. Anyway go to the phpmyadmin and make a backup of your database and see if everything appears as it should there. And how mb is your backup file btw?
5.5mb
OK, on trying to upload the file 'kolahost' with PHPadmin I saved via following the SQL dump tutorial.
I get this error
Error
SQL query:
--
-- Database: `le_joom1`
--
CREATE DATABASE `le_joom1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1044 - Access denied for user 'kreative'@'localhost' to database 'le_joom1'
I understand I need to grant something permission but can you explain what or who and how I go about doing it?
Id be most greatful.
after following the steps above to importing the database, I get a message #1046 - No database selected . Do I need to create a database before doing the import? or what?
if the dump doesn't have a create database line in it, then yes, you will need to create it first :P