Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: Baris - kesäkuu 02, 2006, 11:14:24 AP

Otsikko: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Baris - kesäkuu 02, 2006, 11:14:24 AP
Hi,

We had a SMF 1.0.7 and upgraded this to 1.1RC2

I downloaded upgrade package at the download page.Then uploaded the files to my hosting account with overwriting the old files.Then tried www.mysite.com/upgrade.php

It took some time then said

LainaaUpgrade Complete
That wasn't so hard, was it? Now you are ready to use your installation of SMF. Hope you like it!
Delete this upgrade.php and its data files now. (doesn't work on all servers.)

If you had any problems with this upgrade, or have any problems using SMF, please don't hesitate to look to us for assistance.

Best of luck,
Simple Machines

I clicked my forum's home page and it gave this error
LainaaUnknown column 'a.attachmentType' in 'field list'

Why is that?

Also i tried to install a fresh 1.1RC2.It was installed successfully and worked.Then i changed the database information at the settings.php and replaced them with the upgraded forum's database information.And it gave the same error.
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Oldiesmann - kesäkuu 02, 2006, 11:16:53 AP
Try [[t:MySQL 5.0.12 Compatibility Patch]]. If that doesn't work, upload upgrade.php and upgrade_1-0.sql from the SMF 1.1 RC2 upgrade package and run upgrade.php again.
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Baris - kesäkuu 02, 2006, 11:26:38 AP
My MySQL version is  4.1.15-standard I tried uploading upgrade_1-0.sql and upgrade.php then running upgrade.php again.But it didnt fix the problem :'(
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: kegobeer - kesäkuu 02, 2006, 11:31:29 AP
Did you upload the 1-1.sql file as well?  You could try uploading 1-1.sql and re-running the upgrade script.  I don't suppose you are using a non-RC2 theme or mod, are you?
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Baris - kesäkuu 02, 2006, 11:34:01 AP
There are no mods installed..And the themes are default themes.I think this is a problem with the sql file.Because it didnt work even with a fresh SMF 1.1RC2 install.And gave the same error.
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: kegobeer - kesäkuu 02, 2006, 11:38:20 AP
Lainaa
Also i tried to install a fresh 1.1RC2.It was installed successfully and worked.

Lainaa
Because it didnt work even with a fresh SMF 1.1RC2 install.

Which one is correct?
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: Baris - kesäkuu 02, 2006, 11:44:26 AP
I installed a new SMF 1.1RC2 successfully..And it worked.Then i changed it's database information to the upgraded one's information and it didnt work and gave the same error.

For example..

New Install's database is database1 and the upgraded one's is database2.

The new installation worked with database1 but didnt work with database2.

I hope i could explain..Sorry for my bad English..
Otsikko: Re: Unknown column 'a.attachmentType' in 'field list'
Kirjoitti: kegobeer - kesäkuu 02, 2006, 11:49:16 AP
That means there's a database change that didn't happen during the upgrade.  Did you upload the sql 1.1 file and re-run the upgrade script?