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

[Baris]

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

Upgrade 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

Unknown 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.

[Oldiesmann]

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.

[Baris]

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

[kegobeer]

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?

[Baris]

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.

[kegobeer]

Also i tried to install a fresh 1.1RC2.It was installed successfully and worked.

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

Which one is correct?

[Baris]

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..

[kegobeer]

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?