Hello,
I'm having trouble to migrate the DB from an existing forum to a new install.
My client has a forum that has been customized a lot over the years (Not by me and without documentation), now he wants to make a fresh install, but when I import the DB into the new SMF v2.0.10 it stops working, white screen, no error logs.
I tried adding $db_show_debug = true; to Settings.php but nothing.
Is there a tool to export only valid data for a fresh install (No mods/themes data)?
Thanks!
What system / software is the current forum working on?
The current forum is SMF v1.1.18
Did you follow the instructions here: http://wiki.simplemachines.org/smf/Upgrading
No way to upgrade, I followed the instructions and got 'Unknown errors', besides, I'd like to have a 'standard' db and software, so the fresh install would be better.
but a fresh install like you want would not have the members/topics/messages in it. do you really want to start over from the beginning?
Upgrading is like a fresh install because it essentially overwrites your existing files but keeps the posts and members.
Quote from: Looking on September 10, 2015, 10:55:31 AM
Upgrading is like a fresh install because it essentially overwrites your existing files but keeps the posts and members.
but an upgrade keeps your current members/topics/messages where a real clean install does not.
Yes, that's what I said? I'm trying to show the poster that it is not necessary to get rid of members / posts in order to clean all files / mods otherwise they could just do a fresh install on a different DB / directory and delete the old one.
Quote from: Aramil on September 10, 2015, 10:46:56 AM
No way to upgrade, I followed the instructions and got 'Unknown errors'
Do you still have the 1.1.x files in place? Does the forum still work with that version?
You can't connect a 1.1.x database to 2.0.x files. The database schema isn't compatible so it needs to be upgraded...
You should really perform a full backup and run the upgrade. Remove every file/folder except "attachments", "avatars", "Smileys", "Settings.php" and "Settings_bak.php", load the large upgrade package and fire it! ;)
We've seen some strange issues with the upgrade tool for 2.0.x and they all relate to odd themes configurations in the 1.1.x version. Usually the default theme folder doesn't exist or the theme with ID = 1 is missing (which is something not supposed to happen...).
Check this post and let us know if it helps: http://www.simplemachines.org/community/index.php?topic=538721.msg3828374#msg3828374
OK, I thought you could just migrate those tables, I see there are lots of differences between 2.x.x and 1.x.x DB's
I'll be trying this and come back with the news ASAP.
Thanks to everyone for your time and effort!
The forum is working on v1.1.18 without problems, the issue is on my local development environment.
The folders structure has also been changed, there is no Sources folder, I think they moved it outside of the root of the forum for some reason and changed its name.
On the Settings.php file, the $sourcedir refers to a folder that doesn't exist ( 'path_to_root/includes' ), that folder exists on a lower level than the root of the forum. (The forum is working anyways)
Also, there is no 'Attachments' folder, on the production environment its a file with 0kb and no extension
well, that will likely not work very well... those folder MUST be present (and moving them for some supposed security reason is a complete waste of time -- either the syetem is secure or its not)
if the Settings.php is set the way you say, I don't see how 1.1.x can be working...
I'm guessing that these are symlinks to other places on the server. It's a strange setup...
You can "reassemble" everything, eg in your development environment, with a copy of the files (and the database too) by putting the correct folders in place, assuming you can find them :P
So create an "attachments" folder and copy the attachments there, create a Sources file and put the files there. Then run repair_settings (from that duplicate folder) and point to your duplicate database first, save, then fix the paths to your duplicate folder too.
What is repair_settings.php? (http://wiki.simplemachines.org/smf/Repair_settings.php)
Then you can upgrade this copy and not touch the original, running forum as I described. If everything goes smoothly, you can then move the files to the root of your forum, replacing the "old" files.