Print Page - Error when upgrading

Title: Error when upgrading
Post by: Sefket on February 06, 2012, 12:40:36 PM

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

I got that after upgrading from 1.1.16 to 2.0.1

Site: Venom-rs.net

Title: Re: Error when upgrading
Post by: Oldiesmann on February 06, 2012, 12:53:51 PM

Did you run upgrade.php after uploading the new files?

If so, try running this query in phpMyAdmin:

ALTER TABLE smf_attachments
ALTER COLUMN attachmentType attachment_type tinyint(3) unsigned NOT NULL DEFAULT 0;

Title: Re: Error when upgrading
Post by: Illori on February 06, 2012, 01:10:03 PM

i would say they have not run the upgrade.php script as it is still on their server

http://venom-rs.net/upgrade.php

Title: Re: Error when upgrading
Post by: Sefket on February 06, 2012, 01:56:26 PM

Thank you! I didn't see a documentation which is why I didn't go to upgrade.php

Title: Re: Error when upgrading
Post by: Illori on February 06, 2012, 01:57:24 PM

Upgrading SMF (http://wiki.simplemachines.org/smf/Upgrading)

Simple Machines Community Forum