Rohan Posted May 24, 2006 Share Posted May 24, 2006 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 Quote Link to comment Share on other sites More sharing options...
MikeJ Posted May 24, 2006 Share Posted May 24, 2006 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. Quote Link to comment Share on other sites More sharing options...
TCH-JimE Posted May 25, 2006 Share Posted May 25, 2006 Hello, Follow the instructions that Mike has put above, that should sort you out JimE Quote Link to comment Share on other sites More sharing options...
Rohan Posted May 31, 2006 Author Share Posted May 31, 2006 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 Quote Link to comment Share on other sites More sharing options...
TCH-JimE Posted May 31, 2006 Share Posted May 31, 2006 Excellant, I am glad it works for you Remember to delete the upgrade_to_latest.php after you have completed the upgrade JimE Quote Link to comment Share on other sites More sharing options...
MikeJ Posted May 31, 2006 Share Posted May 31, 2006 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. Quote Link to comment Share on other sites More sharing options...
stevevan Posted May 31, 2006 Share Posted May 31, 2006 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. Quote Link to comment Share on other sites More sharing options...
dirtvoyles Posted June 2, 2006 Share Posted June 2, 2006 Thanks for this thread. I was just updating and couldn't figure out what I was missing. Quote Link to comment Share on other sites More sharing options...
TCH-JimE Posted June 2, 2006 Share Posted June 2, 2006 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 Quote Link to comment Share on other sites More sharing options...
Pocketman Posted June 8, 2006 Share Posted June 8, 2006 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.