Print Page - [SOLVED] Unknown column 'a.attachment

Title: [SOLVED] Unknown column 'a.attachment_type' in 'field list'
Post by: D4RKKNIGH7 on April 26, 2011, 04:04:50 AM

Hey,

Upgrading to 2.x and i get this msg now :/

i done a phpmyadmingl query

ALTER TABLE `smf_attachments` ADD `attachmentType` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';

and it says this

#1060 - Duplicate column name 'attachmentType'

Any help would be great

Cheers

Title: Re: [SOLVED] Unknown column 'a.attachment_type' in 'field list'
Post by: Arantor on April 26, 2011, 09:35:13 AM

Why did you re-add a 1.1.x column to 2.0's database (when it's not even called that any more)?

Title: Re: [SOLVED] Unknown column 'a.attachment_type' in 'field list'
Post by: Illori on April 26, 2011, 09:36:35 AM

did the op not run upgrade.php when doing the upgrade? is this issue resolved or not?

Simple Machines Community Forum