News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Search Error

Started by plusev, July 21, 2009, 07:40:06 PM

Previous topic - Next topic

Norv

That's still as expected.
Please, can you do the same with this file? I inserted another error log entry, with the values themselves, and a notice about supporting ignore, please tell if they appear in the log.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

1024: The database doesn't support ignore
File: //Sources/Search.php
Line: 1570 

==>1570: trigger_error("The database doesn't support ignore");

and

1024: Parameters: 14 7 200 1 %game%
File: //Sources/Search.php
Line: 1567 

==>1567: trigger_error("Parameters: " . implode(' ', $main_query['parameters']));

Norv

Please, log in phpMyAdmin, and first of all make a full backup (you can use export in phpMYyAdmin).
Then, empty the table smf_log_search_results (do not drop it, just empty it).
Then, please try running "check", and "repair" on it.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

Here is a SS of my export. Not that straight forward. Is there anything I should or should not be checking off in the boxes shown? I just want to make sure the export/backup goes well before I do anything else.

Thx

Norv

I would add: check "add drop table", "add if not exists", "complete inserts".

Then, check "save as file", and choose (or not) whatever compression you wish (without it, the file might be big to download, with it, it can take more time to process).
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

#25
Emptied, ran check and repair (both showed Status OK) but still the same errors in log and on search page of forum.

Thx

Norv

This is a weird one. Please, can you look into your sources folder, and find the files with "mysql" in their name, as well as those with "Search" in their names, .zip them together and attach them here? Or even all your Sources directory, can't be big if zipped, and there are only sources files anyway (nothing confidential about that :) ).

Or, are you still on the test forum with 2 posts and 1 user as you said before? It might help if I could see it happening, along with the database, so perhaps you would consider to also make available a backup of the database. In case you agree, please let me know so I can send you an account to use.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

Here are the search/mysql files. If you need more of the backup db. let me know. Thx for your help.

Norv

I'll take a look as soon as soon as possible, though that may be only in about 12 hours.
A backup of the database might be useful, as I intend to try replicating the error.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Norv

Please confirm if my understanding is correct (and still true): you are only getting this error when you try to search for the word "test". Other searches work just fine. You have a topic named 'test' on your forum. You don't use a search index.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

I get the error on all search terms.

I do not use a search index.

Thx

Norv

#31
Please add in your Settings.php file:
Code (find) Select

$db_error_send = 1;

(the value of the variable above might be 0 as well)
Code (add after) Select

$db_show_debug = true;


It will enable a lot of debugging information for your forum (please DON'T use this setting in a production environment). Then, run a search, and in the page with the search result, you will see information at the bottom of the page. Set it to show queries as well, and please copy paste it here.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Arantor

Isn't it just $db_show_debug = true?

(=== means evaluate as identical to, not set the value?)

Norv

Sure is. D'oh.
Corrected in the post, thank you!
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

plusev

Warning: INSERT IGNORE INTO {db_prefix}log_search_results (id_search, relevance, id_topic, id_msg, num_matches) in //Sources/Search.php on line 1565

Notice: Parameters: 18 8 200 1 %pokerstars% in //Sources/Search.php on line 1567

Notice: The database doesn't support ignore in //Sources/Search.php on line 1570

This is the info that shows. Same for any search term.

Thx

Arantor

What database are you using?

plusev

I'm not sure what you mean. Using the mysql and no search index.

Thx

Arantor


plusev


Arantor

Hmm.

What type of table is the log_search_results table?

Advertisement: