Search functionality is not functioing in my upgraded install

The below is the error message displayed when using the search functionality. Help please

Phorum Database Error
Sorry, a Phorum database error occurred.
Please try again later!
Error:
Access denied for user: 'classic_phorum@%' to database 'classic_phorum' (1044): CREATE TEMPORARY TABLE phorum_search_like_1e32c0e74cf4da50f9d619f8ebe62e89 ( KEY (message_id) ) ENGINE=HEAP SELECT message_id FROM phorum_search WHERE search_text LIKE ('%test%')
Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysql.php:164
----
Function phorum_db_interact called at
{path to Phorum}/include/db/mysql.php:1763
----
Function phorum_db_search called at
{path to Phorum}/search.php:236
----

[www.phorum.org]

Um so let me make sure i got this.. Previous when version 5 first came out this issue existed when users couldn't create temp tables. A fix was made by the phorum team for us folks (such as those who use godaddy). Now a few releases later, the temp table dependancy is back and no workaround exists. Yes???

And if the above is correct, will a fix be comming??



Edited 1 time(s). Last edit at 01/08/2008 05:23PM by longshot.

no fix but a module is there [www.phorum.org] .

---

Thomas Seifert

Thanx Thomas, much appreciated. Slow is better than not at all :-)



Edited 1 time(s). Last edit at 01/08/2008 05:34PM by longshot.

Quote
longshot
Um so let me make sure i got this.. Previous when version 5 first came out this issue existed when users couldn't create temp tables. A fix was made by the phorum team for us folks

For a bit of historic corectness:

The situation was different. In the implementation of search without using full text indexes, we did not use temporary tables. That was not a work around for the temp tables problem, but just the way that search feature was implemented. You could switch to search without full text support to also get rid of temporary table creation problems, but that was a side effect. Now, development has moved on and the search code was rewritten and improved. Unfortunately, it now uses temporary tables for both search types.

Because problems were anticipated, Thomas wrote the module that he just posted for the Godaddy victims =)

---

Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce

i stand corrected and thankful to the support of the phorum team :-)