Bug#423798: phpbb2: Search facility fails with SQL error

2007-06-01 Thread Thijs Kinkhorst
On Friday 1 June 2007 09:15, Calvin wrote: > Hello again, > > I finally was able to correct the problem, thanks to this page : > http://www.phpbb.com/community/viewtopic.php?t=386531 > > Looks like the update didn't alter the search table to add the > "search_time" column. > > I created the fix.php

Bug#423798: phpbb2: Search facility fails with SQL error

2007-06-01 Thread Calvin
Hello again, I finally was able to correct the problem, thanks to this page : http://www.phpbb.com/community/viewtopic.php?t=386531 Looks like the update didn't alter the search table to add the "search_time" column. I created the fix.php file and ran it, and it now works perfectly. Thanks,

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Calvin
Yes, sorry, that's the one I tried, and not "dpkg-reconfigure phpbb2". Calvin Thijs Kinkhorst wrote: > On Thursday 31 May 2007 22:13, Calvin wrote: >> The only thing that happened during the upgrade was that the MySQL >> server was shut down, so the upgrade process couldn't update the >>

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Thijs Kinkhorst
On Thursday 31 May 2007 22:13, Calvin wrote: > The only thing that happened during the upgrade was that the MySQL > server was shut down, so the upgrade process couldn't update the > database. I then ran "dpkg-reconfigure phpbb2" to complete the upgrade, > which worked perfectly, except that I had

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Calvin
Hello, I was using Sarge with the default phpbb2 package version, and I recently upgraded to the default Etch package version (2.0.12-6). The only thing that happened during the upgrade was that the MySQL server was shut down, so the upgrade process couldn't update the database. I then ran "dpkg-

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Thijs Kinkhorst
On Thursday 31 May 2007 18:28, Thijs Kinkhorst wrote: > Is this really a new problem since you installed 2.0.22-1? Never mind, I've found the problem and will release the fix soon. Thanks for reporting. Thijs -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trou

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Thijs Kinkhorst
On Tuesday 29 May 2007 00:07, Calvin wrote: > ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED > DEFAULT '0' NOT NULL; > ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT > '0' NOT NULL; > INSERT INTO phpbb_config (config_name, config_value) VALUES > ('m

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-31 Thread Thijs Kinkhorst
tags 423798 moreinfo thanks On Monday 14 May 2007 11:22, Nigel Horne wrote: > SQL Error : 1054 Unknown column 'search_time' in 'where clause' I cannot reproduce that. The database in the etch version, 2.0.21-6 already contains that field. You're running 2.0.22-1, which also has that field. Is t

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-28 Thread Calvin
Read from here : http://forums.phpbb-fr.com/viewtopic_122326.html (French page) I've added these SQL queries and it now works again: ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL; ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAUL

Bug#423798: phpbb2: Search facility fails with SQL error

2007-05-14 Thread Nigel Horne
Package: phpbb2 Version: 2.0.22-1 Severity: normal When searching on anything the following appears after pressing the 'search' button: 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 sear