Hello, I often encounter the problem 1 time per day on the index of the page which displays:
[code]SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `forums_topics` LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums; ',forums_topics.tid)) LEFT JOIN `core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_forums.club_id IS NULL AND forums_forums. min_posts_view<=39699 AND forums_topics.approved < 2 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id NOT IN (6,14 ,28,45,63,99,152,220,286,289,291,293,296,315,349,350,356,364,371) ORDER BY forums_topics.pinned DESC, forums_topics.last_post desc LIMIT 0.52
IPS\Db\Exception: Disk full (/tmp/#sql-temptable-70e-3aef8-cea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021)
#0 /home/nzbnewzfrance/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 [internal function]: IPS\Db\_Select->rewind()
#2 [internal function]: IteratorIterator->rewind()
#3 /home/.../public_html/system/Helpers/Table/Content.php(359): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#4 /home/.../public_html/system/Helpers/Table/Table.php(504): IPS\Helpers\Table\_Content->getRows(Array)
#5 /home/.../public_html/uploads/template_22_b9ece655dd44c92e77c425d3dea4cf8f_index.php(5411): IPS\Helpers\Table\_Table->__toString()
#6 /home/.../public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_forums_front_index->simplifiedView(Object(IPS\Helpers\Table\Content))
#7 /home/.../public_html/applications/forums/modules/front/forums/index.php(204): IPS\Theme\_SandboxedTemplate->__call('simplifiedView', Array)
#8 /home/.../public_html/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_index->manage()
#9 /home/.../public_html/applications/forums/modules/front/forums/index.php(52): IPS\Dispatcher\_Controller->execute()
#10 /home/.../public_html/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_index->execute()
#11 /home/.../public_html/index.php(13): IPS\_Dispatcher->run()
#12 {hand}
in "smooth view" since the last 2 updates, and the forum index is very slow to load.
Error : EX1021
Can you help me.[/code]
Invision Community v4.7.16
Skin 4.7.15
PHP : 8.1.27
SQL : MariaDB 10.6.17
InnoDButf8mb4_unicode_ci
phpMyAdmin 5.2.1
In the System log :