Upgrading From 2.0 RC2 To 2.0 Gold

[Cheese Head]

My forum is now 3.5 years old and I have lots of spammers lately and lots of new members joining with no posts and some with spam signatures set up, weird! Also when I phoned my ISP they said I was using i think 3TB disk sapce which makes no sense.

I've upgraded a couple times in past (all in 2.0) and done a messy job and I only hav 3 mods installed, please advise or link me to info page with info on how to upgrade?

Preferably I'd like to delete my whole forum folder then do a clean new install of Gold and link it up to the existing database. Quick questions:
Q1: Does the SQL database contain all the relevent forum member info, post's text, and pictures and thus can I delete the whole public_html/forum folder to start fresh?
Q2: What is the public_html/forum/attachments folder and what are the file types, some as 2-5MB so I assume pictures that people have uploaded but when I download them I don't know how to open and view them.
Q3: What is the best way to upload Gold?
Q4: Will new Gold link up to my existing SQL DB automatically?

Sorry for the luddite questions, thnaks for your advice!

[wandawill]

just extract all the files into a folder and give it the same name as the one your forum is in and upload it ftp and it will overwrite everything and then run your upgrade file. don't delete anything.

http://download.simplemachines.org/

[Cheese Head]

wandawill, thanks for advice, so I assume you are saying download all the Gold files to my PC, where do I find the upgrade file?

I'd much rather delete all and do a clean new install . . .

[wandawill]

upload the folder and then add upgrade.php to the end of your forum address. just follow the directions it gives. it backs up everything. as always you should backup your forum folder and database before you start. put your forum in maintenance mode when you do anything. if you delete all I think you might lose avatars and what? I just upgraded one and it went smooth.

[wandawill]

I should have said upgrade.php goes after your forum name/upgrade.php----not at the end of index or something like that.

[Norv]

Q1: Does the SQL database contain all the relevent forum member info, post's text, and pictures and thus can I delete the whole public_html/forum folder to start fresh?

The SQL database contains members information, posts' text, but NOT pictures, no files - avatars and attachments are on the disk, not in database. So, as said by wandawill, you probably do not want to delete your attachments folder.
Please do make a backup of your database and forum files anyway: the upgrade script will preserve the information, HOWEVER keep a backup please.

Q2: What is the public_html/forum/attachments folder and what are the file types, some as 2-5MB so I assume pictures that people have uploaded but when I download them I don't know how to open and view them.

If you never changed the default settings, then both avatars and attachments to posts are in this /attachments folder.

How are you downloading the files? If you use FileZilla, you may want to try looking at your FileZilla settings, and uncheck the option that says something like 'treat files without extension as ascii'.
Can you please give an example of one of the files you can't see, simply let us know the name of the file?

Also when I phoned my ISP they said I was using i think 3TB disk sapce which makes no sense.

Do you have by any chance files called [a_long_name].core in your forum folder or public_html folder or somewhere?

------

To start quite new, but still keep all your attachments and other pictures/files:
- first please make a backup - full backup - of your database and /forum folder. Make sure they're complete... Please make the database backup using phpmyadmin or cpanel backup, to be sure, if you have the possibility from your host.
If so you wish, you can delete some folders and files from /forum, but please KEEP:
- keep /attachments folder (what size does it have overall?)
- if your forum settings for attachments and avatars point to different directories, then please keep those directories too (admin > attachments and avatars > attachments settings and avatar settings)
- if you had a gallery mod or some other mod that allows uploading and storing files, please tell what it is, it might have some directories of its own for storing gallery pictures or what files they may be, and those files I assume you wouldn't want deleted.
- keep the files Settings.php and Settings_bak.php from your /forum directory, they contain important configuration information for the forum to work.

The rest isn't really needed for SMF itself (unless you have some other files of your own there) - and upgrade package will contain all the rest of the files necessary for the forum to work cleanly and properly.

[Cheese Head]

wandawill again thanks for your support, Norv, many many thanks for taking the time to give such a detailed response. Sorry for delay, work got in way of hobbies (yep work to live not live to work).

1) The forum/attachments folder contains users uploaded avatars and users attachments to posts in the forum such as pictures and files. I will not delete this.

2) Backup forum files on-line: Done via Cpanel.

3) Backup my SQL database: Looked around my host HostGator's Control Panel and couldn't find a way to do this (did see that it was 225 MB), but last time I talked with them they said my SQL database is backed up weekly (see attached screenshot of Control Panel Backup status after backing up forum showing used 15.7 of 20 allowed GB, looks like I don't have 3TB as in my OP, sorry). I did just backup the database via the forum software (Admin > Forum Maintenance > Database > Backup, worked only with the gzip option unchecked), and downloaded a 5.3 MB file .sql to my PC, no idea why way less that the 225 MB shown on Control Panel > My SQL Databases webpage.

4) On question of what are all my Attachment files, Control Panel > File Manager shows they are all type text/x-generic (see attached screenshot), most are small, some are big, page takes ages to load. I've downloaded a couple to my PC via Hostgator's my Control Panel > File Manager and can't find a program to open them and see what they are. Ideas and recommendations appreciated.

5) core files: Good question, yes I used to have tonnes of files called "core.11650" etc in my forum folder, last time I talked to Hostgator the rep figured they were forum crash dumps and he deleted them for me, I now again have about 100 of these averaging 29.6 MB each = ~3GB. As I've just backed up the forum folder that means that 3x2=6GB of my used 15.7 GB is these files. I've read this thread which says they are server crash dump files and recommend talking with host company. After deleting them from both forum and my backup my used 15.7GB dropped to 9.6GB.

6) Attachments folder size: Sorry I can't tell via File Manger, but often the page fails to load as takes to long, I suspect 1000's of files in there

7) Only significant forum mod is I have Aeva installed, do I need to do anything about that?

Lastly to do a clean install of Gold: After backing up, my understanding is I delete my whole forum directory except the attachments folder and settings.php and Settings_bak.php files, download and unzip Gold to my PC then FTP it (except the attachments folder and two settings files) up to the forum directory, then configure via forumname/upgrade.php?

Many many thanks (sorry about all the questions)!

[Cheese Head]

OK, updated my forum as per above and ran install.php (& deleted) from new SMF 2 Gold, works OK, one bug, see item 3 below.

Had a couple warning messages that should uninstall old version before installing new, presumably as left the Attachments folder and the two forum root folder files settings.php and Settings_bak.php but proceeded and it installed and is running fine. Alsl re-installed AEVA without problem.

Appreciate any help on:

1) Why Hostgator shows the SQL database as being 225 MB whereas when I download via forum software it is 5.3 MB on my PC.

2) Why I have 100's of text/x-generic files in Attachments folder?

3) One problem is that when making posts, the post text edit window scrolls off window to right in my MS Internet Explorer 9 (see attached screen shot), appreciate advice?

Again thanks in advance, John.

[Cheese Head]

Uploaded two non-installed files settings.php and Settings_bak.php and re-installed forum via install.php file and no change still have post edit window scrolled off screen to right as per attachment in post above.

Any advice to this problem appreciated, thanks.

[Illori]

also you dont upgrade by using the install file, you need to use the large upgrade file and run upgrade.php


take a look at

Hello there.

Try with this, in index.css change:

Code Select Expand

#quickReplyOptions form textarea
{
    height: 100px;
    margin: 0.25em 0 1em 0;
}


to this:

Code Select Expand

#quickReplyOptions form textarea
{
    height: 100px;
    width: 635px;
    max-width: 100%;
    min-width: 100%;
    margin: 0.25em 0 1em 0;
}

Also, if your theme isnt built for 2.0 (but it is for RC5) please read this topic with tip to update theme from RC5 to 2.0 version:
http://www.simplemachines.org/community/index.php?topic=437428.0

Regards.

and be sure to clear your browser and server cache.

[Cheese Head]

Illori, many thanks for reply.

My thread title is misleading as I wanted to start with a new fresh install rather than upgrade. I actually have done two things:
1) Deleted all the forum folder except attachments subfolder and two files settings.php and Settings_bak.php and FTP'd the Gold forum files except those two from my PC and ran Install.php which left me with the edit box problem.
2) Today I uploaded the new versions of settings.php and Settings_bak.php after which forum failed and so I uploaded Install.php and re-ran it after which forum now working but still same problem.

I am using Default theme, just checked my themes/default/index.css file and it has the code as per your second quote (width 635px etc).

Again appreciate your advice, John.

[Illori]

clear your browsers cache, and if you are using your old database which it sounds like you are you need to run upgrade.php

[NanoSector]

And zoom out, you have zoomed in at 155%

[Norv]

A little note here:

1) Why Hostgator shows the SQL database as being 225 MB whereas when I download via forum software it is 5.3 MB on my PC.

The forum's backup procedure is reported to timeout or otherwise be unable to get all the data, for large databases. It's fine as long as the database is small, but for your database you definitely cannot rely on it. Please use instead a backup procedure from your host's panel, or from phpmyadmin. (some phpmyadmin backing up operations used to timeout too in the past, it may depend what version of phpmyadmin and what settings your host's server has).

[Cheese Head]

@Illori, thanks, I downloaded the Upgrade file, unzipped on my PC and FTP'd just the upgrade.php file and ran it but got message below, presumably as I did a "Full Install" of Gold, not an upgrade (except for Attachments directory and initially for the two files settings.php and Settings_bak.php). Should I install upgrade over my Full Install?

The upgrader was unable to find some crucial files.

Please make sure you uploaded all of the files included in the package, including the Themes, Sources, and other directories.

@Yoshi2889, good idea but I have the same problem at 60%, 100% or 200% zoom.

@Norv, thanks I have 50k posts, currently using Cpanel's Backup Wizard which seems to be working (will take a while).

[Illori]

as the error says make sure all files are uploaded, sounds like some were not uploaded or not uploaded fully.

you also need the sql files for the upgrade to run.

[Cheese Head]

Thanks, all files are uploaded (at least my FTP gave no error message) except the index.php in Attachments as I didn't want to delete that folder.

Just uploaded the Upgrade and ran Upgrade.php which worked without problem.

Restarted forum and same problem of text box scrolling off right, deleted internet files (Temp, Cache, History) and still problem, had another look at IE9 Delete options and at top is option to "Preserve Favorites website data" which I ticked off and re-deleted and presto NO MORE SCROLLING off right side!

A thousand cheesemakers and I thank everyone here for their patience and support, will Mark Topic Solved!