Moving to 2.0 from 1.1.11

[flutter]

I have a domain which is empty and I'm testing 2.0.  If I like it, how do I port all my members details over without importing all the rubbish that's already on my site.  I don't want the mods I have to follow me.  I'd like to keep the posts we have and my member details, that's all.  I want to start fresh.

How do I do this?

[Oya]

Upgrading SMF

you generally remove mods before the upgrade and it will also replace your themes too (since none of them will work)

[flutter]

There are no mods on that domain, it's an empty site.  I can't remove the mods completely from the old one and don't want to mess it up further than it already is. 

This is a test site, with nothing on it but smf 2.0, the members are still held on the old site and it's a 1.1.11 forum.

I need to get the members over to the new site without having to actually install the whole backup which would carry over the issues we have to the new site.

[wilfred888]

As Oya stated, read
http://docs.simplemachines.org/index.php?board=3.0;sort=subject

Should answer your questions.

[flutter]

Not really, as I'm not doing an upgrade I'm installing a fresh forum.  I take it I'm supposed to upload the whole screwed up forum I have already and then install and then still have to deal with the issues I have on the old one, not a lot of help really to upgrade, it's not going to solve a thing.

Thanks anyway

[Oya]

so copy the 1.1.11 forum and upgrade it

it should fix most if not all of the issues you'll have anyway

[flutter]

The topic is solved.  More waste of time, I now have to uninstall the 2.0, install the borked 1.1.11 and then upgrade with 2.0.  Seems like a long way for a short cut

[Oya]

it's hardly a shortcut to try importing 1.1 data into 2.0 considering that there's 20 new tables and virtually every table's structure has changed...

[flutter]

I did say this was solved and marked it as solved.

Your point is that there are so many tables changed, ok so I go and upload 1.1.11 and then overwrite it with 2.0 which changes all the tables I just uploaded anyway. 

It would be so much easier to import the files required than put files up that get changed anyway, and I don't understand why people can't see that.

The long way is that I now delete the 2.0 and then install the 1.1.11 and then overwrite the 1.1.11 by installing the 2.0 upgrade.

The short way is to install 2.0 then import member details and posts

But like I said, this topic is solved so I don't need any more help, I'm looking into other options for a forum

[Oya]

because practical experience of trying to do just that tells me it just isn't the case?

the entire database layout is different between the two, and presumably you want to keep topics tied to messages properly (which means the topics+messages tables), members in membergroups (which means members+membergroups tables) plus the boards in which they're in and resultant permissions that come out of it (boards+board_permissions+permissions tables) - and attachments (another table)

it's not just a case of simply importing two or three tables; like every other system out there, it's not all stored in a few places, everything is inter linked, and you'll find exactly the same with any of the other forums

consequently the fastest way really is copy+upgrade because it's just about as automated as it gets

[flutter]

this topic is solved

It has been a long hard trek.  I now don't have any sites at all, due to deleting the site and making the mistake of deleting the wrong one while in consultation with the host about why the site wouldn't work on the new domain.

I now have to reuplod my main site before I do anything again, so you'll forgive me if I don't come back on this again.  I'm disabling the notifications.

But you are right, so right, everything you say is right and I'm just a nube seemingly

[Oya]

i'm not trying to belittle you and im sorry if you have felt that way, it was never my intent

i'm simply getting at the fact that the process is much more subtle and involved than it seems, you cannot just import only the posts or only the members, because they have information attached to them that has other uses - the actual groups a member belongs to is part of the members table itself; and just importing that on its own would break things, that is all i meant

[flutter]

and you made your point, this topic is solved.  Thanks for your help.

[flutter]

Ok so here's what really happens and I suspected this, I must be psychic.

I put the site and database up on the mirror site, which is an add on in hostgator.  I go to the log in page and guess what, it has the same database so it leads me right to the main site.  Oh no, the database in cpanel is not the same name as the main site, but the backup I had to use to get it running is. So I can't upload anything to it without affecting the main site.  Now do you see how this is a problem?

[tazgal]

Flutter, you're here asking for help and when someone reaches out to help you, you appear to be insulted.  The people on this forum are giving freely of their time.  I too wish that I could just have uploaded 2.03 and then installed my members and their posts.  Unfortunately, it doesn't work that way.  Anyway, I just wanted to point out to you that there's no reason for being negative or sarcastic.

[Kindred]

if you want to have two separate installations, you will have to use two separate databases....    So, you can take a copy of the original database, import it into a new database and then change the Settings.php of your mirror to point to the SECOND database.    Then the changes will only affect the mirrored site.

[flutter]

Kindred, yes thanks for your positive comment.  I was just writing a reply to the above but will leave it there, it's help I need not a slagging off.

I have changed the name of the database and installed it into the second site, no change at all.  I have gone into settings.php and changed the settings there to  point to the new database, no change.

This just won't work for me at all.  When I try to sign in to the .co.uk site, I get landed on the .com one and you know I can't work in there and that was the point of the second forum

This is me going to delete the whole thing again and give it another go, I just have no idea how to make that database different, apart from the name change and the settings.php leading to it.  If you have any suggestions I'd be grateful.

[Kindred]

if you change the database and the file paths in Settings.php, then your system should be using the secondary data....   unless you have an .htaccess which redirects you back to the original site?

Once you change settings.php, you may have to go into the admin tools and change the theme, avatar and attachment directories to your secondary source.... but the system itself should be already using the secondary source, if the settings.php is pointing to it.

[flutter]

It isn't though, it's driving me nuts.  I'm going for a whole new install of the files again and I'll create a new databse for the backup database to go to, I'll just name it the same as the name I have.  I'll also be able to use that settings.php again too as I'll call it the same as before.  I tried deleting the custom theme I have to and it didn't help.  I can't get into admin tools as it takes me to my main site and I can't change them there without affecting my site.  If you know another way to change the avatars, ect, I'd be grateful for the advice

[Kindred]

If I had more time, I would offer to take a look directly. Unfortunately, I do not, at this time, have the time.   Let's see if one of the support folks (green badges) can take a few moments.

[flutter]

I've contacted my host.  I'm doing a clean istall again of the whole forum, I've deleted the database and added a new one with the same name as before.  After it's uploaded I've to reply to my ticket and they will have a look at it and see if they can work it out for me.  Host Gator are good hosts, if they can't get it to work, I don't think anyone can.  Maybe I'll have to look into a whole new forum software but I did want to use tiny portal.  If I can't get it to work, then I'll have to look around for something else that can import smf data.

I really appreciate the help Kindred, thanks

[Aleksi "Lex" Kilpinen]

Hi flutter, did you manage to sort this out with your host?
I'm sorry to say, but I don't share your feelings on Hostgator, so if they aren't able to make it work,
it doesn't really mean it can't be done.

[flutter]

Nope.  I did the whole upgrade thing on one site and left the main site up.  When I tried to trabsfer it all over they were reading with each other.  Right now I have no site at all.  I'm reuploading to my .com one, all the old stuff from the old site and I'll have to do the whole thing again, upgrade it fron scratch.  The problem is that there's a mod I can't uninstall as everytime I try to, it shuts my site down.  I'm hoping the upgrade will overwrite it.

This is a complete nightmare.  I even bought cbulletin and it's crap, asked for the money back and they're messing me about on it.  So many bugs it's unreal and they refuse to give back the money, even though it does say you can get a refund if you ask within 60 days.  So many times I've felt like packing it all in.

Thanks for asking, lol, I'm fine  Just need psychiatric treatment and all will be well 

[Aleksi "Lex" Kilpinen]

Ok, if you are doing this all from scratch again - do let us know if you need help with something, wouldn't want you to abandon SMF over something like this

[flutter]

It's not SMF that's the problem, it's this add on domain carry on.  I had them separate and had the add on upgraded and it looked good.  I transferred all the files to the main domain and it wouldn't read the databse for the main site, I did use the corect settings.php.  I then found out that if I used the database for the add on that it worked, but both sites were the same.  As we have some files left to sort, e.g. downloads, we need the old domain on the go at the same time.  It's hard to explain it all without writing a book but I'm now thinking that if I just get the main one reloaded as 1.1.11 and upgrade that then it will be fine, that is assuming SMF can connect to that database which appears to be the issue.  Must admit, I'm losing it with host gator as they don't seem to understand what I'm saying, the two sites are connected again.  I've been telling them about the database issue for a long time as I keep getting SMF error emails.  I also discovered that when I upload with core ftp it doesn't always go where it should.  It's a total mess but I plod on.

Thanks for the support

[Aleksi "Lex" Kilpinen]

Just realised....

I have changed the name of the database and installed it into the second site, no change at all.  I have gone into settings.php and changed the settings there to  point to the new database, no change.

This just won't work for me at all.  When I try to sign in to the .co.uk site, I get landed on the .com one and you know I can't work in there and that was the point of the second forum

This is me going to delete the whole thing again and give it another go, I just have no idea how to make that database different, apart from the name change and the settings.php leading to it.  If you have any suggestions I'd be grateful.

This is because the "copy" forum still has all old path and url settings defined, and the second you try to load any page on it, it will catch on and "fix" your wrong URL, to the one that is defined in your settings.
Please, see What is repair_settings.php?
And use repair_settings.php for the "copy" forum to make sure it uses the new location.

[flutter]

Oh dear, this was a long time ago.Lex, I did say that I had changed the settings, it was a problem on host gators end due to it being and add on domain and it was their settings that were wring.  The mere fact that I could land on the index page of the .co.uk site showed the settings.php was fine, it was after log in that it went to the .com site.  I managed to get that test all done and was happy with it, so I shut my main site down for a day while I applied it all over there, I didn't even want to mess with trying to transfer it all over from one to the other.  My biggest problem was with my donwload system when I did that as I couldn't work out where in the code the images for that were to hange their path.  It was not so bad doing the upgrade over there as I'd already done it once and made every mistake going, so was forearmed.

I keep repair_settings.php on my pc just in case

Thanks for still picking this up. 

[Aleksi "Lex" Kilpinen]

The mere fact that I could land on the index page of the .co.uk site showed the settings.php was fine, it was after log in that it went to the .com site. 

Actually, that was the thing - I didn't realise it before, but with wrong URL settings, you can reach the frontpage, but as soon as you click on any SMF link, it will redirect you to use the URL in it's settings.

But the main thing is you've got things sorted somehow

[flutter]

yes but it did have the right settings, even host gator tech checked that.  Host gator had it set to mirror the other site, so any changes I made on the test site would have been applied to the old site.  They obviously didn't understadn what I meant about a test site.  I think the big difficulty for them was that both sites had the same name, just the .co.uk and .com were different, so they thought I wanted it mirrored.  They took their time about fixing it too.

[Aleksi "Lex" Kilpinen]

OK, I see... Well - all's well that ends well