[Forum] Error during the database search in the Forum

[shiraz sat]

Hello
I think when I search the forum I am faced with a database error. Please help

Database error in vBulletin 4.1.12:

Invalid SQL:

            SELECT searchlog.*
            FROM searchlog AS searchlog
            WHERE searchhash = '4d0cdeebd22bc5e6152610cc9f44cff2' AND
                sortby =  'defaultdateline' AND
                sortorder =  'desc' AND
                dateline > 1336053333 AND
                userid = 2 AND
                completed = 1
            ORDER BY dateline DESC
            LIMIT 1;

MySQL Error   : Table 'dvbshare_db4fyou.searchlog' doesn't exist
Error Number  : 1146
Request Date  : Thursday, May 3rd 2012 @ 04:55:33 PM
Error Date    : Thursday, May 3rd 2012 @ 04:55:39 PM
Script        : http://*******/search.php?do=process
Referrer      : http://******/index.php
IP Address    : 188.245.148.113
Username      : *******
Classname     : vB_Database
MySQL Version : 5.1.62-cll

[Lynne]

If you look at your database, do you see the table searchlog?

[shiraz sat]

If you look at your database, do you see the table searchlog?

No - there is no

[borbole]

No - there is no

Try to readd it. That should fix the error.

[Lynne]

The schema for the table is in the /install/mysql-schema.php file.

CREATE TABLE searchlog (
    searchlogid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    ipaddress VARCHAR(15) NOT NULL DEFAULT '',
    searchhash VARCHAR(32) NOT NULL,
    sortby VARCHAR(15) NOT NULL DEFAULT '',
    sortorder ENUM('asc','desc') NOT NULL DEFAULT 'asc',
    searchtime FLOAT UNSIGNED NOT NULL DEFAULT '0',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    completed SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    criteria MEDIUMTEXT NOT NULL,
    results MEDIUMBLOB,
    PRIMARY KEY (searchlogid),
    KEY search (userid, searchhash, sortby, sortorder),
    KEY userfloodcheck (userid, dateline),
    KEY ipfloodcheck (ipaddress, dateline)
)

[shiraz sat]

Please show the photo. I am a beginner

[borbole]

Please show the photo. I am a beginner

What photo do you mean?

The query posted above should be run either at the SQL Box at your forum 's database phpmyadmin. Or you can also run it from your Admin Panel->Maintenance->Execute SQL Query. But for this you must enter your user id at the below area at the config.php file:

$config['SpecialUsers']['canrunqueries'] = 'x'; 

Where x equals your user id.

[shiraz sat]

What photo do you mean?

The query posted above should be run either at the SQL Box at your forum 's database phpmyadmin. Or you can also run it from your Admin Panel->Maintenance->Execute SQL Query. But for this you must enter your user id at the below area at the config.php file:

$config['SpecialUsers']['canrunqueries'] = 'x'; 

Where x equals your user id.

Please notice that your picture will

[Lynne]

You need to run that query I posted. If you have phpMyAdmin, you may run it using that.

[borbole]

Please notice that your picture will

I am sorry, you lost me here. Don''t have a clue what you mean.