Your message dated Thu, 21 Dec 2006 19:07:42 +0000
with message-id <[EMAIL PROTECTED]>
and subject line forcing reinstallation fixes problem
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: phpbb2
Version: 2.0.21-5
Upgrading from a previous version (sorry, the record of what the
previous version was has gone - it may have been 2.0.21-4) breaks the
search function.
Now a search for an existing word gives a screen saying
General Error
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 < 1166712081
Line : 657
File : search.php
I first encountered this error when I tried to Backup Database from
the previous version and Restore Database on a different machine where
I was trying to migrate the forum's hosting to, but assumed the change
would be applied in a same-system upgrade. Now, having upgraded the
original server, the error occurs there too.
I think the fix is simply to add the missing column to the
phpbb_search_results table if it does not exist - either in the debian
configure script or in the php code, since it in simply a cache for
search results. That would also retroactively repair all the
installations round the world whose search function has been broken by
the upgrade.
M
--- End Message ---
--- Begin Message ---
Oh. I just forced a reinstallation because the entire forum had died
since the mysql extension in /etc/php4/apache/php.ini had also been
disabled by the upgrade.
After dpkg -i /var/cache/apt/archives/php* the entire forum works fine
M
--- End Message ---
