Everytime I try to search the forums using keywords I get this 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_5324c4ffef4e1a0e8a195b3e5ba2ab60 ( KEY (message_id) ) ENGINE=HEAP SELECT message_id FROM phorum_search WHERE MATCH (search_text) AGAINST ('+seyel' 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

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.

Why do all my post come up as Anonymous instead of my user name Bobbo?

I have no idea, Bobbo! Were you logged in?

I didn't even think one could post a comment without being logged in, so I was always surprised to see a post from "Anonymous User". I take it that's been you those times?

If he doesn't see this thread soon and respond, try sending a PM, via the Harptabs website, to the Webmaster, Nick (aka "djlactose" ). I bet he could answer your question (and fix whatever the problem is!).

Or, perhaps Gene, our Moderator and Guardian Against Spam, could answer your question.

Sorry, guess I'm not much help....

I have no idea. That's Nick's department.

This has been fixed the search was using a feature which was disabled for security reasons. I have enabled it now.