Please Help! - Phpbb

[Rohan]

As advised by the helpdesk I tried to update the PHPBB version 2.0.19 to 2.0.20 (Server 109)

 

I downloaded the files and uploaded them to the corresponding directories. After the update now I have 2 problems:

 

1) My administrator panel says still I am running the old version

 

2) Search function is not working anymore:

 

I get the following error message:

Could not delete old search id sessions

 

DEBUG MODE

 

SQL Error : 1054 Unknown column 'search_time' in 'where clause'

DELETE FROM phpbb_search_results WHERE search_time < 1148501405

Line : 657

File : search.php

What have I done wrong? How can I correct this?

 

Thank you in advance, Rohan

[MikeJ]

It sounds like you didn't run the install/update_to_latest.php script which creates that new column.

 

Make sure to run that. For example, if your phpbb is installed as yourtchsite.com/forum/, use your browser to hit yourtchsite.com/forum/install/update_to_latest.php, and then when you are done and it works, remove that install directory.

[TCH-JimE]

Hello,

 

Follow the instructions that Mike has put above, that should sort you out

 

JimE

[Rohan]

Hello,

 

Follow the instructions that Mike has put above, that should sort you out

 

JimE

 

Thank you. I did this and now it works!

Thanks again, Rohan

[TCH-JimE]

Excellant, I am glad it works for you

 

Remember to delete the upgrade_to_latest.php after you have completed the upgrade

 

JimE

[MikeJ]

Remember to delete the upgrade_to_latest.php after you have completed the upgrade

 

Actually, you should remove the entire install directory to be safe. There are other scripts in there as well you don't want people accessing.

[stevevan]

While I haven't played with Phpbb in a while, I remember seeing that statement written in the instructions for both initial installation and upgrade.

[dirtvoyles]

Thanks for this thread. I was just updating and couldn't figure out what I was missing.

[TCH-JimE]

Hello,

 

Good Point Mike, I forgot about that. Infact I think phpBB handily now tells you to remove the install folder before you can access your forums. I wish other software did this, it would be so much safer

 

JimE

[Pocketman]

Just updated from 2.0.18 to 2.0.21

Thanks for the info posted here. Task was PAINLESS

Edited June 8, 2006 by Pocketman