Advertisement:

Author Topic: Database Error: The table '[dbname]_tmp_log_search_topics' is full  (Read 459 times)

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,463
  • Gender: Male
  • "mods" junkie
    • dopetalk
https://myforum/index.php?action=search2

Hi guys, i need some help with avoiding/fixing this error please - if i run the same search on the SM site then it works ok.

Database Error: The table 'smf209_tmp_log_search_topics' is full

INSERT IGNORE INTO smf209_tmp_log_search_topics
(id_topic)
SELECT t.id_topic
FROM smf209_topics AS t
INNER JOIN smf209_log_search_subjects AS subj1 ON (subj1.id_topic = t.id_topic)
WHERE subj1.word LIKE '%to%'
AND t.id_board IN (1, 2, 3, 4, 6, 7, 9, 11, 12, 13, 14, 21, 22, 23, 24, 25, 26, 29, 31, 32, 33, 34, 36, 37, 38, 39, 40, 41, 49, 52, 53, 55, 57, 58, 59, 62, 63, 64, 66, 67, 68, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 86, 89, 90, 95, 96)
LIMIT 1054

File: /var/www/html/Sources/Search.php
Line: 1364

I also tried the same search of the word "to" and got this:

Database Error

The table 'smf209_tmp_log_search_topics' is full
File: /var/www/html/Sources/Search.php
Line: 1364

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.9. The above error might possibly go away if you execute the latest version of upgrade.php.
« Last Edit: January 24, 2018, 04:09:58 AM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,143
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #1 on: January 24, 2018, 04:16:14 AM »
https://dev.mysql.com/doc/refman/5.7/en/full-table.html
Contact your host to find out the actual cause of the error, or drop your search index to make the table disappear.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,463
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #2 on: January 24, 2018, 04:20:08 AM »
Thanks, i am my host ... and forgot to search enough - i have now modified the my.cnf value: tmp_table_size=1k

... i had it set to 1k as part of my aggressive memory usage cull (only can afford 1 GB) but now bumped it up to 512k.

I will refer to that link again should i have this type of error on another table.

 8)
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,143
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #3 on: January 24, 2018, 04:26:08 AM »
Alrighty :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,463
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #4 on: January 24, 2018, 04:29:39 AM »
yes but it failed so i reviewing the doco at your link again ... standby

EDIT: I removed these and let them default:

Code: [Select]
max_heap_table_size=16K
tmp_table_size=1K

(I had to restart mysqld and logout/login to SMF)

I am happy that i can't find too many occurrences of the word "to", despite possibly being wrong - it should be in the "trivial" word list)

no errors so i will mark this as solved.

« Last Edit: January 24, 2018, 04:44:21 AM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,143
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #5 on: January 24, 2018, 05:13:58 AM »
Sounds good, if you run in to further trouble with your database settings - perhaps post to Server Performance and Configuration :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,463
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Database Error: The table '[dbname]_tmp_log_search_topics' is full
« Reply #6 on: January 24, 2018, 06:28:59 AM »
noted
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)