Upgrading from 1.1.21 to...

[Sir Osis of Liver]

It's loading for me.  504 is a server error, gateway timeout.  Not the first time it's happened.  At some point you'll need to move to a better host.

I have the 1.1.21 database.  smfVersion in settings is 1.1.6.  Are you sure this is the database that was running in your forum when we ran upgrade?

[ducpainter]

It's the one I copied off the server. I didn't have any other databases on my computer.

Why do you ask?

[Illori]

I have the 1.1.21 database.  smfVersion in settings is 1.1.6.  Are you sure this is the database that was running in your forum when we ran upgrade?

you have to remember this version does not get updated when you use the package manager to upgrade your install.

[Sir Osis of Liver]

index.php displays 1.1.21.  Have it running here, css doesn't load, repair_settings doesn't fix it, tried old and new versions.  Don't remember much about 1.1, there's no /Themes/default/css directory, css files are in /Themes/default.  Path is correct.  Will work on it tonight.

[ducpainter]

There were extensive handwritten mods to css for that theme, which IIRC was modified from the forum default. There's a css stylesheet in httpdocs?

[Sir Osis of Liver]

It's a clean set of files, should be loading /default/style.css, it's called in index.template.php -

Code Select Expand


<link rel="stylesheet" type="text/css" href="', $settings['theme_url'], '/style.css?fin11" />


Path to default theme is correct, file is there.  Will get back to it tonight.

[ducpainter]

OK

[Sir Osis of Liver]

Just getting back to this.  Bad news is, attachments table in your 1.1.21 database backup has same problem as upgraded database.  All id_msg and id_thumb fields are set to 0 for 2400 attachments.  If you don't have another backup, there's no way to recover the attachments.  Do you have a 30 day backup utility running in your GoDaddy account?

[ducpainter]

No. I do daily backups and it only saves 3

[Sir Osis of Liver]

Well, then you're screwed.  There's no way to recover the attachments with what we have.  The 1.1.21 database was damaged before upgrade, no idea how.  You can ask GD support if they can recover an earlier database from server backups.  Otherwise the 1.1.21 install seems to be running normally here, no errors.  Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually.  Took a couple of hours dicking around to get it where it is now.  You can login as admin and see if everything's working.  You can post new attachments, but none of the old ones will be displayed.  The rest of your content should be intact.

[ducpainter]

That's unfortunate...support, and godaddy, should never be used together.

I don't know what to do, and I don't even know what my options are. Do I even have any?

[Doug Heffernan]

I don't know what to do, and I don't even know what my options are. Do I even have any?

Did your attachments work fine before you upgraded your forum? If they did, I find the following very strange:

All id_msg and id_thumb fields are set to 0 for 2400 attachments.

In that case your attachments shouldn't have worked at all. I know from experience that a damaged database would make the normal and error free functioning of a forum impossible, let alone let an upgrade be completed. And from what I've read in this topic your forum functioned error free before the upgrade.

Anyways, back your question if you have options, yes you do imo. This will require a revert back to your previous version and doing a proper upgrade.  That would mean that you will loose whatever new content you had acquired from the time of the upgrade till now though.

[ducpainter]

As far as I know, other than php errors regrading the e modifier being deprecated...no errors, and the forum was behaving normally. Other than not being able to install some mods the upgraded forum isn't throwing errors.

I was having 504 errors, but that shouldn't be related to a damaged db?

There isn't all that much activity on the board these days so not much would be lost.

I need to think on this.

[ducpainter]

Well, then you're screwed.  There's no way to recover the attachments with what we have.  The 1.1.21 database was damaged before upgrade, no idea how.  You can ask GD support if they can recover an earlier database from server backups.  Otherwise the 1.1.21 install seems to be running normally here, no errors.  Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually.  Took a couple of hours dicking around to get it where it is now.  You can login as admin and see if everything's working.  You can post new attachments, but none of the old ones will be displayed.  The rest of your content should be intact.

It looks like everything is OK.

I'm not sure I'm understanding what attachments you're referring to.

Are those attachments only stored in the db?

[Doug Heffernan]

I was having 504 errors, but that shouldn't be related to a damaged db?

No, that's server related. It's no indication of a damaged database.

On a side note, I unmarked your topic from being solved so it can receive more attention.

[ducpainter]

Well, then you're screwed.  There's no way to recover the attachments with what we have.  The 1.1.21 database was damaged before upgrade, no idea how.  You can ask GD support if they can recover an earlier database from server backups.  Otherwise the 1.1.21 install seems to be running normally here, no errors.  Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually.  Took a couple of hours dicking around to get it where it is now.  You can login as admin and see if everything's working.  You can post new attachments, but none of the old ones will be displayed.  The rest of your content should be intact.

After a second look the only thing I can see is smileys aren't displaying, but I think that's because we had a custom smiley set.

I have that file.

[ducpainter]

At 11;10 am I got an email about the site running on your server couldn't connect to the db.

[Sir Osis of Liver]

Those are random server errors, shouldn't happen often.

Are old attachments being displayed on your production forum?

[ducpainter]

Those are random server errors, shouldn't happen often.

Are old attachments being displayed on your production forum?

I'm not seeing anything that isn't being displayed, other than smileys, and there's some text issues with apostrophes, but I'm still not sure what you exactly mean by attachments.

Small words without too much technicality...please

[Sir Osis of Liver]

Looking at the 1.1.21 clone on my server, I'm uploading attachments and avatars that I dumped from your original install before running upgrade.  Other than the theme and mods, content on the clone should be the same as on your original forum.  Attachments are files (mostly images) that were attached to posts in reply editor, you should see a thumbnail below the post, if you click on it you see fullsize image.