Re: Searching forums - error message
Posted by:
EarthDogHarpin
(76.251.187.---)
Date: December 09, 2011 03:11PM
I'm getting the same message, almost.
First I get a message that says "Your search is running, please be patient."
Then it goes to a new screen with the Error Message:
Phorum Database Error
Sorry, a Phorum database error occurred.
Please try again later!
Error:
Access denied for user 'harptabs_harptab'@'localhost' to database 'harptabs_com' (1044): CREATE TEMPORARY TABLE phorum_search_ft_e4a15deddcdfc79b46ffb4b9e2558358 ( KEY (message_id) ) ENGINE=HEAP SELECT message_id FROM phorum_search WHERE MATCH (search_text) AGAINST ('+(the single word search term I used)' IN BOOLEAN MODE)
Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysqli.php:212
----
Function phorum_db_interact called at
{path to Phorum}/include/db/mysql.php:1765
----
Function phorum_db_search called at
{path to Phorum}/search.php:236
Doesn't matter what I choose in the drop down boxes, or which forum to search, or all forums to search, or dates....
I get pretty-much the same Error Message save for the string of numbers that's displayed in the " CREATE TEMPORARY TABLE phorum_search_...".
If I try a different search word I get pretty much the same end message, just with a different number...:
Phorum Database Error
Sorry, a Phorum database error occurred.
Please try again later!
Error:
Access denied for user 'harptabs_harptab'@'localhost' to database 'harptabs_com' (1044): CREATE TEMPORARY TABLE phorum_search_ft_764a24956711217eb2056035fea9a979 ( KEY (message_id) ) ENGINE=HEAP SELECT message_id FROM phorum_search WHERE MATCH (search_text) AGAINST ('+(another single word search term)' IN BOOLEAN MODE)
Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysqli.php:212
----
Function phorum_db_interact called at
{path to Phorum}/include/db/mysql.php:1765
----
Function phorum_db_search called at
{path to Phorum}/search.php:236
Hope between Anonymous User's post, and this one, that you can find the problem, Nick.
Edited 1 time(s). Last edit at 12/09/2011 03:23PM by EarthDogHarpin.