Upgraded to 2.0.12 | Wrong database version?

[s3cc0]

I see this error when trying to use the search form with a long string:

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
File: /home/fetishba/domains/bitcoingarden.tk/public_html/forum/Sources/Search.php
Line: 1338

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.12, while your database is at version 2.0.7. The above error might possibly go away if you execute the latest version of upgrade.php.

But there's more. It only happen at the first search. If I repeat the search after getting the error it won't happen anymore for that particular string. It will show up again trying a new search with another query (4 or 5 words).

Searching with a short string always work. Any hint?

[s3cc0]

Still looking for a workaround...

[Kindred]

the database version message is a red herring and can be ignored.

As for the actual error....   what mods do you have installed?

[s3cc0]

Running 2.0.12 with the following mods:

1.   SMF 2.0.11 Update   1.0     
2.   Remove "Last edit" mod   0.2.5     
3.   Copy Topics   1.6     
4.   Country Flags   2.1     
5.   Add Social Media Icons To Profiles   1.1.0     
6.   Move Topic Notification   1.2     
7.   SMFPacks Shoutbox   1.0.5     
8.   Additional Profile Permissions   1.0.0     
9.   Tapatalk SMF 2.0 Plugin   4.4.1     
10.   Ad Seller Pro   2.5.2     
11.   Global Headers Footers   2.0.1     
12.   Alternate User Posting   1.0.1     
13.   RSS Feed Icon   1.1     
14.   Apache Error Handler   1.2     
15.   RSS Feed Poster   4.2.1     
16.   SMF 1.1.21 / 2.0.10 Update   1.0     
17.   SMF 1.1.20 / 2.0.9 Update   1.0     
18.   SMF 2.0.12 Update   1.0     
19.   SMF 2.0.8 Update   1.0 
20.   More Spiders   1.2     
21.   Simple Audio Video Embedder   2.7     

[Kindred]

I would lay bets on Tapatalk, but not guaranteed....

[s3cc0]

No, it is not that one. I tried to uninstall and tested without it but the error still show up.

Also uninstalled 2.0.12 and still getting the error in 2.0.11

Next candidate? The error is at the last line of this function , if this can help...

Code Select Expand


// Nothing to search for?
if (empty($subject_query['where']))
continue;

$ignoreRequest = $smcFunc['db_search_query']('insert_log_search_topics', ($smcFunc['db_support_ignore'] ? ( '
INSERT IGNORE INTO {db_prefix}' . ($createTemporary ? 'tmp_' : '') . 'log_search_topics
(' . ($createTemporary ? '' : 'id_search, ') . 'id_topic)') : '') . '
SELECT ' . ($createTemporary ? '' : $_SESSION['search_cache']['id_search'] . ', ') . 't.id_topic
FROM ' . $subject_query['from'] . (empty($subject_query['inner_join']) ? '' : '
INNER JOIN ' . implode('
INNER JOIN ', $subject_query['inner_join'])) . (empty($subject_query['left_join']) ? '' : '
LEFT JOIN ' . implode('
LEFT JOIN ', $subject_query['left_join'])) . '
WHERE ' . implode('
AND ', $subject_query['where']) . (empty($modSettings['search_max_results']) ? '' : '
LIMIT ' . ($modSettings['search_max_results'] - $numSubjectResults)),
$subject_query['params']
);


[d3vcho]

Hello!

I'd suggest using the latest upgrade.php file. An user in the Spanish board had an error that was also related with the database version (he had 2.0.7, the same as you), so you can try because the code seems to be ok. He used the file and the issue disappeared.

Regards

[Illori]

Hello!

I'd suggest using the latest upgrade.php file. An user in the Spanish board had an error that was also related with the database version (he had 2.0.7, the same as you), so you can try because the code seems to be ok. He used the file and the issue disappeared.

Regards

the database version does not effect anything. if the files are the correct version the database has not had any updates/changes since SMF 2.0.