• Welcome to Simple Machines Community Forum. Please login or sign up.
October 19, 2021, 04:36:54 PM

News:

SMF 2.0.18 has been released! Please update. Read more.


How do I make my SMF2.0 RC3 Upgrade 100% mod & edit free - database & files?

Started by ElectricSquid, October 04, 2010, 11:49:18 AM

Previous topic - Next topic

ElectricSquid

Does the upgrade package clear the all the old data from modsettings?

Kindred

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

ElectricSquid

Do you know if modsettings is connected in some way to other data (in a way were I couldn't simply replace it with the install version)?
The mods are gone, so the data should go too.

Hj Ahmad Rasyid Hj Ismail

Hmmm... reading all these posts I just want to note one thing. Why don't you upgraded to 1.1.11 first instead of directly trying it from 1.1.9. I would not recommend this form of upgrade even if it works (partially). Any version of SMF 1.1.x other then 1.1.11 should be upgraded to 1.1.11 first. When that is done, check whether the forum works (with or without mods - mod is not important since you gonna upgrade it to 2.0 then). Only if all is working fine, then upgrade it to 2.0 RC3. This is how I will do it. Long way but for me it's the safest.

ElectricSquid

Why not 1.1.11?
Because the forum errors out if I try to upgrade past 1.1.9, probably due to some old edits I did years ago before I had a clue what I was doing.
Removing mods doesn't work, there are too many custom edits that interfere, again, from years ago before I had a clue what I was doing

This is what I'm trying to get away from by starting fresh, but I don't want to loose all the members and posts.

Hj Ahmad Rasyid Hj Ismail

If I were you, this is what I'll do. I may not be able to remove all mods or any of them. So I will create a dummy test site with the same (copied) files and database. I will overwrite my current forum with the 1.1.9 upgrade package first. I will see whether that is working first before I upgrade it to 1.1.11. Care to test this method?

ElectricSquid

Let me get this correct, on the devbox* you suggest I overwrite the existing (copied from the live site) 1.1.9 with a 1.1.9 upgrade package, then upgrade to 1.1.11, then 2.0 RC3?

Will the 1.1.9 upgrade package wipe out the moded Source and Theme files?






*devbox = development box - this is the test server.

ElectricSquid

... and don't forget this question about 2.0 RC3...

Quote from: ElectricSquid on October 05, 2010, 11:01:39 AM
Do you know if modsettings is connected in some way to other data (in a way were I couldn't simply replace it with the install version)?
The mods are gone, so the data should go too.

Hj Ahmad Rasyid Hj Ismail

Yes. And I know that this is SMF 2.0 support board. I am just sharing my idea on how the upgrade to SMF 2.0 can be worked around. Feel free to use any other methods.

ElectricSquid

I welcome your 1.1.9 suggestion, and find it to be relevant to the subject at hand.
Thanks.

I'll try your idea later on tonight.

Oya

theres really no need to go 1.1.9 to 1.1.11 to 2.0

there are no db changes after 1.1.9

and the modsettings are all in the database in smf_settings and will in almost all cases just be reused

Kindred

thank you oya.... exactly.   My instructions stand as the best upgrade route. :)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

ElectricSquid

Quote from: Oya on October 05, 2010, 03:29:18 PM
theres really no need to go 1.1.9 to 1.1.11 to 2.0
there are no db changes after 1.1.9

Cool, I didn't want to go through all that again anyway.



Quote
and the modsettings are all in the database in smf_settings and will in almost all cases just be reused

On my upgraded version of SMF2.0 RC3, can I swap smf_settings with a fresh install version of this database info?
Or is the default vale something like null? or nothing?
(I haven't seen the default value in so long, I don't know what it looks like anymore :P)



Quote from: Kindred on October 05, 2010, 04:02:38 PM
thank you oya.... exactly.   My instructions stand as the best upgrade route. :)

As long as I can clean up the files and database to a fresh install value, I agree with you.
Here's where I'm at with this...

Files - Solved
Assuring the SMF files are new has already been taken care of by the Upgrade Package. Just to be 100% sure the files were new, I was able to manually copy fresh new files from the smf upgrade archive to a fresh new webroot folder, so I KNOW there are no leftover mods & edits there anywhere.
This might have been overkill, but I had to be sure. 100% sure

Database - Almost Solved
The 1.1.9 database has been updated correctly by the Upgrade Package.
The mod & edit leftovers still reside in modsettings, in anything prefixed 'tp_' (tinyportal), and possibly elsewhere.

I need to:

  • change the modsettings data to a default value
  • delete anything prefixed 'tp_'
  • find any other leftovers and delete them

Please give me suggestions on how to do task 1 and 3.
Thanks :)

Oya

except you actually can't use totally fresh modsettings values

some of the values relate to the current state of the forum, like the current number of posts total, the last registered member, and so on

you're better off just leaving it

ElectricSquid

Quote from: Oya on October 05, 2010, 07:26:45 PM
except you actually can't use totally fresh modsettings values

some of the values relate to the current state of the forum, like the current number of posts total, the last registered member, and so on

you're better off just leaving it

Thank you, it's good to know ahead of time that there are, in fact, a whole slue of values in there that need to be set correctly. Not something a delete or swap would cure.

I must disagree with "just leaving it". This is what I've done for years now, and that causes problems years later when something clashes and crashes and no-one knows why. It's this kind of thing that prevents me from upgrading past 1.1.9 to 1.1.10 or 11.
Right now, during this upgrade to 2.0, I have a once in a decade chance to get rid of ALL the old problems all at once and be 100% sure I did. I can't just get lazy and let this opportunity pass. I know that in a year, I'll kick myself right in the @$$ for just leaving it. So I can sleep well at night, I need a 100% fresh clean slate to work from, and I can't stop at 98% because it's too hard to do the rest.

So help me out here, there has to be some way to do this last 2% without having to kill ourselves at it.
Take a day, think about it.

Kindred

see... I just do not get it. leaving the db will have NO effect.... and there are so many settings for individial users in that table that it would be a nightmare to find the mod type stuff ... and why... I have been running a forum on upgrades for 8 years now with no problems... since 1.0
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

vbgamer45

The only real way which I don't advise is to convert to another forum software then convert that software back.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

ElectricSquid

Quote from: Kindred on October 05, 2010, 08:32:04 PM
see... I just do not get it. leaving the db will have NO effect.... and there are so many settings for individial users in that table that it would be a nightmare to find the mod type stuff ... and why... I have been running a forum on upgrades for 8 years now with no problems... since 1.0

... because I've been running this forum for about 4-5 years now, and some of the edits and mods done were from back in a day where I had no clue what I was doing. I want to be sure I'm working with a clean slate. Maybe you haven't had problems because you're a good coder, that's great for you. But I have had problems because at one time, I was a terrible coder. I would like to rid myself of ALL those edits from those days.




Quote from: vbgamer45 on October 05, 2010, 08:41:19 PM
The only real way which I don't advise is to convert to another forum software then convert that software back.

LOL, that's an interesting idea.
A bit "outside the box" thinking, I like that :)
Why is it that you don't advise it?

Kindred

because, you almost always "lose" stuff in any conversion.... and a double conversion probably will have more problems than just leaving the fields in there.

and Electric...  it has very little to do with coding.
See, this is where I think we are having a disconnect.
Having extra database tables or database rows will have little, if ANY effect on your site, unless you have something installed which ACCESSES those tables/rows.

So, leaving a database row in place, for a mod which is no longer installed will have NO effect (ok, it might have a effect on the database performance if you had an extra 20 million rows... but you're talking only a few dozen, maybe a few hundred extra)

Clean coding isn't an issue...   coding is done on the FILE side of things. The database just contains DATA
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

ElectricSquid

I'm in total agreement on the file side of things.

On the database side, I realize that the performance hit is probably minimal.
As far as errors, that would/could only happen if on a one in a billion chance that smf decides to use the same name as what is already in the database (as a leftover), or errors could happen after I install a mod (though that will be limited at this point since smf integrated all the mods I would like to add).

I'm just trying to get a 100% clean new install with my old posts intact.
I know it's hard, but I am willing to see it through (correctly).

Advertisement: