Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: TeaTephi on January 20, 2011, 05:26:31 PM

Title: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 05:26:31 PM
Getting this error

Unknown column 'a.attachment_type' in 'field list'

trying to restore the database, but this was the result of attempting to do that.  Now that's all i get!  Help!


And now I got this error:

Unknown column 'add_deny' in 'field list'
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 05:35:02 PM
what were you last doing before this error came up?
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 05:36:19 PM
Quote from: Illori on January 20, 2011, 05:35:02 PM
what were you last doing before this error came up?

I was trying to get my data for profile comments back, so I decided to restore the database from 10 days ago, now I can't get anything but that error.
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 05:40:34 PM
did you do any changes to your forum in those 10 days? upgrade by chance?
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 05:43:31 PM
I recently upgraded to 2.0 on that day !  Oh my gosh I didn't think of that.
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 05:45:24 PM
ok so you need to run the upgrade script, then be sure to backup the updated database ;)
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 05:48:11 PM
ok so just start over from scratch like when I upgraded? that doesn't sound too bad. :-\
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 05:49:39 PM
sounds like the best idea.
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:04:04 PM
!!
Error!
Unknown column 'eventDate' in 'where clause'

Got this in the "Database changes" part of upgrade.   What should I do?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:07:54 PM
last time this came up the solution seemed to be

Quote from: xenovanis on August 13, 2010, 01:00:53 AM
Glad it's solved :) Turned out the database was party converted, yet the version number was still 1.1.9. That's why the convertor got stuck.
not sure if that is helpful though.
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:21:04 PM
Quote from: Illori on January 20, 2011, 06:07:54 PM
last time this came up the solution seemed to be

Quote from: xenovanis on August 13, 2010, 01:00:53 AM
Glad it's solved :) Turned out the database was party converted, yet the version number was still 1.1.9. That's why the convertor got stuck.
not sure if that is helpful though.

I'm confused, how do I change the version number?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:23:22 PM
settings table smfVersion variable
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:24:39 PM
Quote from: Illori on January 20, 2011, 06:23:22 PM
settings table smfVersion variable
Is that in a php file or in phpmyadmin?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:25:54 PM
phpmyadmin
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:26:49 PM
Quote from: Illori on January 20, 2011, 06:25:54 PM
phpmyadmin

and then I restart the upgrade.php?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:27:52 PM
cant hurt to try it again, then check to see if your forum is working.
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:34:56 PM
I don't know what to change here?  Where is the smf version listed?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:38:19 PM
click browse then try again.
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:44:19 PM
Is this what I should type in?
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 06:51:43 PM
yes
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 06:53:59 PM
Okay upgrade said it completed properly, but it still says the forum is upgrading
Title: Re: Help!!! Crashed my forum!
Post by: Illori on January 20, 2011, 07:27:27 PM
open settings.php and modify it as it says for maintenance mode.
Title: Re: Help!!! Crashed my forum!
Post by: TeaTephi on January 20, 2011, 07:44:38 PM
Thanks Illori!

I finally got it working.  Need to reinstall a few mods, and lost a little data, but it's back!  Thank you!