Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: caipirinha - helmikuu 28, 2009, 12:51:46 IP

Otsikko: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - helmikuu 28, 2009, 12:51:46 IP
I have a problem during the upgrade from 1.1.4 to 2.0 RC1

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

- I used the upgrade pack
- I have deleted/replaced all the files (except settings)
- There are no additional languages in the template sets (see above)
- There are no mods
- PHP/SQL is higher than reccomended

Any hints?
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - helmikuu 28, 2009, 01:03:54 IP
Additional info:
upgrade.php?step=4&substep=0&data=YTo2On [...] 6MTt9&ssi=1
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - maaliskuu 01, 2009, 06:37:51 AP
Bump ....
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: JimM - maaliskuu 08, 2009, 04:56:41 IP
A search returned this:

Lainaus käyttäjältä: Duncan85 - maaliskuu 06, 2009, 08:38:33 IP
I think,this is already a known bug in 2.0 RC1

Bug #2963: 'update', 'overwrite', and 'update_remove'  option for 'if_exists' on db_create_table function fails (http://dev.simplemachines.org/mantis/view.php?id=2963)

The problem is being worked.
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - maaliskuu 08, 2009, 05:56:07 IP
Thanks for your reply.

I have the same error on updating 1.1.8
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: JimM - maaliskuu 08, 2009, 06:12:46 IP
Of course you do as the error is in the upgrade script for 2.0RC1!
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - maaliskuu 08, 2009, 10:44:32 IP
*lol* I have read it.
I hope it will be solved soon
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: ThorstenE - maaliskuu 27, 2009, 07:06:19 AP
caipirinha, is this still an issue? I'll bet the version detection is wrong and the upgrade script detects an SMF 2.x (not 1.1).

maybe you have a copy/test-system from your forum and can try the following:
rename "upgrade_2-0_mysql.sql" to "old.sql", then rename "upgrade_1-1.sql" to "upgrade_2-0_mysql.sql".

then start the upgrade.

Don't forget to make a Backup from your forum (files and database) before.
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: caipirinha - huhtikuu 04, 2009, 07:58:26 AP
Thanks for for your reply.
I'll try it on a testaccount.

I wished SMF team would publish all the changes for the option of a manual upgrade.
Otsikko: Re: Upgrade 1.1.4 => 2.0 RC1: Unknown column 'a.attachment_type' in 'field list'
Kirjoitti: JimM - huhtikuu 04, 2009, 05:24:00 IP
Upgrading to 2.0RC1 from 1.1.4 is a file overwrite operation.  There are no manual instructions.  Way too many changes to even consider it.