Upgrade

[orionboji]

Hello,

when I open a post I get this kind of message:

Unknown column 'a.file_hash' in 'field list'
File: /home/xxxxx/public_html/Sources/Display.php
Line: 711

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.


How can I fix it?

Thank you.

Michael

[NanoSector]

Downoad the Large Upgrade pack.

Unzip, and only copy the upgrade.php file to your server.

Run it, and see.

[orionboji]

Hello,

where can I download the Large Upgrade Pack that is necessary for my case?

Michael

[NanoSector]

Hello,

where can I download the Large Upgrade Pack that is necessary for my case?

Michael

Yoiu may download it here:
http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-11_upgrade.zip

[orionboji]

Thank you for your help mate

Michael

[NanoSector]

Thank you for your help mate

Michael

No problem, don't forget to mark this topic as solved if the problem is gone

[JimM]

You are missing a field that was added to the database with version 1.1.9.  Additionally the smfVersion variable needs to be updated.  The 1.1.9 update contained a small file titled updateDatabase.php that added the field that you are missing.  I've attached the file to this post.  Upload it to the same place as ssi.php and call it with your browser.  You will get a white screen when it is finished and that is normal.

Once that is done run the following query in phpMyAdmin to fix the smfVersion variable.

Koodi [Valitse] Laajenna

UPDATE `smf_settings` SET `value` = '1.1.11' WHERE `variable` = 'smfVersion' LIMIT 1