1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

xf_thread_view table full?

Discussion in 'Feedback & Suggestions' started by Gareth Halfacree, 9 Aug 2026.

  1. Gareth Halfacree

    Gareth Halfacree WIIGII! Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    4 Dec 2007
    Posts:
    18,693
    Likes Received:
    9,351
    @MLyons: getting the following error when trying to view the opnsense thread in Hardware.
    Code:
    An exception occurred: Mysqli statement execute error : The table 'xf_thread_view' is full in /home/bit-tech/xenforo/forum/library/Zend/Db/Statement/Mysqli.php on line 214
    
        Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
        Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
        Zend_Db_Adapter_Abstract->query() in XenForo/Model/Thread.php at line 2506
        XenForo_Model_Thread->logThreadView() in XenForo/ControllerPublic/Thread.php at line 159
        XenForo_ControllerPublic_Thread->actionIndex() in XenForo/FrontController.php at line 351
        XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
        XenForo_FrontController->run() in /home/bit-tech/xenforo/forum/index.php at line 16
     
    MLyons likes this.
  2. adidan

    adidan Guesswork is still work

    Joined:
    25 Mar 2009
    Posts:
    21,090
    Likes Received:
    6,945
    FWIW I can see it fine on chrome on my phone if that's any use to know.
     
    MLyons likes this.
  3. Gareth Halfacree

    Gareth Halfacree WIIGII! Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    4 Dec 2007
    Posts:
    18,693
    Likes Received:
    9,351
    Seems to be fixed now - I was getting that error viewing any thread (including this one that I made!)
     
    adidan and MLyons like this.
  4. MLyons

    MLyons 70% Dev, 30% Doge. DevDoge. Software Dev @ Corsair Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    3 Mar 2017
    Posts:
    4,316
    Likes Received:
    3,037
    the disk is full. I'm using every trick i can find to get us some more space.
     
    adidan likes this.
  5. Gareth Halfacree

    Gareth Halfacree WIIGII! Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    4 Dec 2007
    Posts:
    18,693
    Likes Received:
    9,351
    Is it the same disk that holds the main site? Could win a little bit back by running all the JPEGs through jpgcrush. Lossless optimisation - it'll shave 1-15% off the file size (but most usually 2-3% - not much, but every little helps!)

    EDIT:
    I've just used jpgcrush on today's article images, before I upload 'em to my Gemini site, to give you an idea of real-world gains:

    Code:
    blacklaw@xerxes:~/Documents/backtoit$ parallel jpgcrush {} ::: *jpg
    [1/1 -6.58%] 20260810-uwb.jpg   
    [1/1 -13.18%]20260810-rak.jpg   
    [1/1 -0.68%] 20260810-pirate.jpg   
    [1/1 -0.47%] 20260810-ilabs.jpg 
    Those were saved with the latest GIMP, so it's not like I was using an inefficient encoder in the first place. It's not much, but if you've thousands of high-res JPEGs sitting there it could add up!
     
    Last edited: 10 Aug 2026
    MLyons and adidan like this.
  6. Mr_Mistoffelees

    Mr_Mistoffelees The Bit-Tech Cat. New Improved Version.

    Joined:
    26 Aug 2014
    Posts:
    6,535
    Likes Received:
    3,615
    Would it be better if us members used third party picture hosting, rather than on-site albums? I've only recently started using the albums but, am open to suggestions for a good, free hosting service.
     
    Arboreal, MLyons and adidan like this.
  7. Krikkit

    Krikkit All glory to the hypnotoad! Super Moderator

    Joined:
    21 Jan 2003
    Posts:
    24,103
    Likes Received:
    808
    I have no idea how benign they are, but I like imgbb
     
    MLyons and Mr_Mistoffelees like this.
  8. Cheapskate

    Cheapskate Insane? or just stupid?

    Joined:
    13 May 2007
    Posts:
    12,742
    Likes Received:
    2,270
    3rd party is bad. All the pics on old logs are gone because of them. If I had money, I'd send a hard drive.
     
    Arboreal likes this.
  9. MLyons

    MLyons 70% Dev, 30% Doge. DevDoge. Software Dev @ Corsair Lover of bit-tech Administrator Super Moderator Moderator

    Joined:
    3 Mar 2017
    Posts:
    4,316
    Likes Received:
    3,037
    there's storage there it's getting it all assigned to the server an shifting around the partitions.
     
    Arboreal likes this.
  10. Pete J

    Pete J Employed scum

    Joined:
    28 Sep 2009
    Posts:
    7,917
    Likes Received:
    2,636
    @MLyons always reach out if you need some funds to help keep the server up and running. Not talking £100s, but a few 10s of quid here and there are a possibility. I'm sure there are others on here who'd also be willing to give small donations.

    I'd love to share the burden, but I'm actually very poor in terms of computing knowledge. I know how to build a PC, install Windows and then play games and watch Netflix, but that's about it! This server malarkey is magical to me.
     
    Idioteque, MLyons and Arboreal like this.

Share This Page