Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: orionboji - lokakuu 30, 2010, 05:53:06 IP

Otsikko: Upgrade
Kirjoitti: orionboji - lokakuu 30, 2010, 05:53:06 IP
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
Otsikko: Re: Upgrade
Kirjoitti: NanoSector - lokakuu 30, 2010, 06:23:19 IP
Downoad the Large Upgrade pack.

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

Run it, and see.
Otsikko: Re: Upgrade
Kirjoitti: orionboji - lokakuu 31, 2010, 12:16:08 AP
Hello,

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

Michael
Otsikko: Re: Upgrade
Kirjoitti: NanoSector - lokakuu 31, 2010, 05:17:04 AP
Lainaus käyttäjältä: orionboji - lokakuu 31, 2010, 12:16:08 AP
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
Otsikko: Re: Upgrade
Kirjoitti: orionboji - lokakuu 31, 2010, 06:47:47 AP
Thank you for your help mate :)

Michael
Otsikko: Re: Upgrade
Kirjoitti: NanoSector - lokakuu 31, 2010, 08:14:45 AP
Lainaus käyttäjältä: orionboji - lokakuu 31, 2010, 06:47:47 AP
Thank you for your help mate :)

Michael
No problem, don't forget to mark this topic as solved if the problem is gone ;)
Otsikko: Re: Upgrade
Kirjoitti: JimM - marraskuu 01, 2010, 10:16:23 IP
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.

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