Jump to content

kazad63

Clients
  • Posts

    18
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by kazad63

  1. 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 : 

    Could contain: Page, Text, File, Computer Hardware, Electronics, Hardware, Monitor, Screen

     

     

     

     

  2. Hello,

    I have updated web site to last version 4.7.10 and PHP 8.1, but I can't use feature : rebuild existing content. Error 1S111/1 You do not have permission to do this.

    The error in question comes from the New Topic Placeholders/Prefilled Custom Fields mod:

     

    Error: SELECT * FROM `newtopicplaceholders_content` ORDER BY id ASC LIMIT 0.250 Unknown column 'id' in 'order clause'

    Thanks to invision support for the information.

    Best regards.

    Could contain: File, Page, Text, Computer Hardware, Electronics, Hardware, Monitor, Screen, Webpage

     

×
×
  • Create New...