Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: randallsadler - huhtikuu 10, 2006, 06:39:16 IP

Otsikko: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: randallsadler - huhtikuu 10, 2006, 06:39:16 IP
SMF Version: SMF 1.1 RC2
Hello all,

I had a double whammy today.  I had some major trouble with the files on my server and lost the files for my forum.  I had backed up my attachments file and also my database, but had to reinstall the smf program.  I did so in the same folder on my server space and was able to go through set up again with no problem--and got a blank forum.  It appears that I also managed to somehow delete that database from my ISP, so I had to create a new database to put the backup into (this resulted in a new number for that database, but I linked the new forum to that correct database.

The problem is that when I reloaded my backed up database and then checked my forum, all I got was a white screen that said:  Unknown column 'a.attachmentType' in 'field list'

Looking at the database, I can see that everything is there--I have the member list, etc., but obviously I can't get the forum to show anything.  Any ideas?

The url is: http://www.eslweb.org/resources

My sincere thanks for any help you can give this dunderhead!
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Deaks - huhtikuu 10, 2006, 06:42:10 IP
it seems to be fine for me

Index page is working for me but im gettin adif error im getting
Unknown column 'b.permission_mode' in 'field list'
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: randallsadler - huhtikuu 10, 2006, 08:42:24 IP
Hello all,

Actually, I've just noticed that everything is showing up when I look at the forum as a guest, but it only gives me that "Unknown column 'a.attachmentType' in 'field list'" message when I attempt to log in or if I try to go anywhere beyond the main page.  Any ideas?
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: JayBachatero - huhtikuu 10, 2006, 08:52:45 IP
Reupload the upgrade package and make sure you overwrite all of the files.  After that run upgrade.php.
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: randallsadler - huhtikuu 11, 2006, 11:53:34 AP
Jay and sloopz,

You guys are awesome--the fix worked!

My eternal appreciation.

Randall Sadler
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: JayBachatero - huhtikuu 11, 2006, 11:57:36 AP
Glad to hear you got it working. :)
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: artekkk - kesäkuu 05, 2006, 03:22:49 IP
yes.. I have problem like this too
but I had version 1.0.7 , and I decided to move my forum to 1.1rc2 because for that version is avaliable affilate mod :)
and when I upload database from 1.0.7 to 1.1rc2 I see "Unknown column 'a.attachmentType' in 'field list'"
what I have to do?

www.dewiant.jor.pl/forum
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: JayBachatero - kesäkuu 05, 2006, 03:54:47 IP
You need to run upgrade.php
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: artekkk - kesäkuu 05, 2006, 04:08:41 IP
I've upgraded, but it doesn't work at all!
www.dewiant.jor.pl/forum - please look
Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is using an ILLEGAL copy of SMF!

I really don't understand it! I haven't changed manually anything..
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: JayBachatero - kesäkuu 05, 2006, 04:18:05 IP
Download the whole upgrade package and overwrite your forum files.  Then run upgrade.php
Upgrade Guide (http://www.simplemachines.org/community/index.php?topic=6832.0)
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: artekkk - kesäkuu 05, 2006, 04:29:21 IP
yes, but I decided to change directory..
earliest version is avaliable on .../smf/ (1.0.7)  and I want to move it to .../forum/ (and I installed 1.1rc2)
Have I to install in ../forum/ 1.0.7 version ,upload database and than upgrade with pack from "download" (http://www.simplemachines.org/download/)?
Or have I to upgrade 1.1rc2 through 1.1rc2 upgrade pack forum "download" ? It seems to be stupid for me, but I have some problems with foreign languages :)
sorry for it :)
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: JayBachatero - kesäkuu 05, 2006, 04:36:48 IP
Ok get the upgrade pack and overwrite the files on smf.  Run the upgrade after that rename smf to forum.  Once you rename use repait_settings.php to fix your path.
What is repair_settings.php? (http://www.simplemachines.org/community/index.php?topic=18096.0)
Otsikko: Re: major problem on a reinstall--Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: artekkk - kesäkuu 05, 2006, 04:51:17 IP
ok.. I'll do it :)
thanks for help :)
If something doesn't work , I'll write here :)