Firefox PHP

Search functionality is not functioing in my upgraded install

Posted by longshot 
Search functionality is not functioing in my upgraded install
January 08, 2008 10:04PM
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
----
pat
Re: Search functionality is not functioing in my upgraded install
January 08, 2008 10:13PM
Re: Search functionality is not functioing in my upgraded install
January 08, 2008 11:21PM
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 11:23PM by longshot.
Re: Search functionality is not functioing in my upgraded install
January 08, 2008 11:27PM
no fix but a module is there [www.phorum.org] .


Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de
Custom Phorum and general software development
worry-free Phorum Hosting
Re: Search functionality is not functioing in my upgraded install
January 08, 2008 11:32PM
Thanx Thomas, much appreciated. Slow is better than not at all :-)



Edited 1 time(s). Last edit at 01/08/2008 11:34PM by longshot.
Re: Search functionality is not functioing in my upgraded install
January 08, 2008 11:37PM
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
Re: Search functionality is not functioing in my upgraded install
January 09, 2008 12:11AM
i stand corrected and thankful to the support of the phorum team :-)
Sorry, only registered users may post in this forum.

Click here to login