SMF Support > SMF 2.0.x Support

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

(1/2) > >>

ro-lkw:
Hello everybody.

Recentky I change my hosting and move my forum. Guys from server restore my database and full backup but now appers when I want to acces the site this error :  Unknown column 'a.attachment_type' in 'field list'

Can someone to tell me what I can do ?

MrPhil:
It sounds like you have SMF 2.0.x code with an SMF 1.x database. SMF 2 databases are supposed to have an extra field 'attachment_type' in the 'attachment' table, but yours doesn't. Did you use to have an SMF 1.x installation? Could its database have been restored instead of the SMF 2.x database? Maybe the backup was of the wrong database, or is an old one (from when you were still running SMF 1.x), or was damaged at some point.

What version of SMF, so this can be moved to the right place?

ro-lkw:
Yes I upgrade to SMF 2.0.2 RC5 , and probably is the old database. But I don't have a new data base.
What can I do ?

MrPhil:
As part of the upgrade, there should be a script upgrade.php to run, which migrates your database from 1.1.x to 2.0.x.

By the way, there is no SMF 2.0.2 RC5. SMF 2.0 RC5 was the last stop before Gold (2.0), and 2.0.2 is two updates beyond that. You should not be at 2.0 RC5.

ro-lkw:
Where I find this script upgrade.php ?

Navigation

[0] Message Index

[#] Next page