Search function bug??

[Will Bailey]

Everytime I try to do a Search on my board I got the following message:

Access denied for user: 'gnrfr@localhost' to database 'gunsnroses5'
Fichier: /home/sites/site7/web/gnr/Sources/Search.php
Ligne: 362

How can I solve this issue? Thanx!

Here's lines 355-362 of my Search.php file in case it's needed:

      db_query("
         CREATE TEMPORARY TABLE {$db_prefix}matches (
            ID_TOPIC mediumint(8) unsigned NOT NULL default '0',
            ID_FIRST_MSG int(10) unsigned NOT NULL default '0',
            numReplies int(11) NOT NULL default '0',
            is_subject tinyint(3) unsigned NOT NULL default '0',
            PRIMARY KEY (ID_TOPIC)
         ) TYPE=HEAP", __FILE__, __LINE__);

[Metho]

You need to get your host to allow you to CREATE temporary tables.

- Methonis

[Will Bailey]

If they don't want to, does it mean I can't use the Search function?

[Ben_S]

It's been discussed many times, use the search function here and you will how to work around it.

[Will Bailey]

Ok, thanx.

[Alexandre P.]

The temporary suggestion made by Aquilo and Unknown is  to use the old Beta 4 ou Beta 5 Search.php and Search.template.php instead of the new ones.  The consequence of doing this will be that searches will be slower on large boards.