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 |
Registered: 16 years ago Posts: 25 |
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
----
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
----
Re: Search functionality is not functioing in my upgraded install January 08, 2008 10:13PM |
Registered: 17 years ago Posts: 683 |
Re: Search functionality is not functioing in my upgraded install January 08, 2008 11:21PM |
Registered: 16 years ago Posts: 25 |
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.
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 |
Admin Registered: 18 years ago Posts: 9,239 |
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
Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de


Re: Search functionality is not functioing in my upgraded install January 08, 2008 11:32PM |
Registered: 16 years ago Posts: 25 |
January 08, 2008 11:37PM |
Admin Registered: 16 years ago Posts: 8,532 |
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



Re: Search functionality is not functioing in my upgraded install January 09, 2008 12:11AM |
Registered: 16 years ago Posts: 25 |
Sorry, only registered users may post in this forum.