[herbie]

I, Budgetman, considering the number of current users glancing towards my new Xmas Raspberry Pi4 kit and stack of 2.5" recovered drives...

[DrCaleb]

Considering the active user base, I bet CKA could run very well on a couple PIs and 500GB SD Cards. And Fedora Linux for Pi, of course.

[herbie]

Raspbian Buster seems to work quite well. I'd show you, but I live with a pitiful uplink, USB 2 v 3 drive connectors are the least of my considerations. Last Fedora I played with was Fedora4.
Almost 6 years since I set up a server. I can sure tell !
apt-get php7.2 , 7.2???? OMG I'm old....

[BartSimpson]

If you click into the Entertainment section of the forum here:

entertainment-f7/

You get a big huge dish of sql error.

$1:

General Error
SQL ERROR [ mysql4 ]

Error writing file 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\MY1753.tmp' (Errcode: 28 - No space left on device) [3]

SQL

SELECT f.*, fa.user_id, t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_status, t.topic_type, t.topic_moved_id FROM (phpbb_forums f) LEFT JOIN phpbb_forums_access fa ON (fa.forum_id = f.forum_id AND fa.session_id = '9f932b905e8a090414f3ad514324bbf7') LEFT JOIN phpbb_topics t ON (t.topic_last_post_id = f.forum_last_post_id) WHERE left_id > 172 AND left_id < 185 ORDER BY f.left_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_display.php
LINE: 111
CALL: dbal_mysql->sql_query()

FILE: viewforum.php
LINE: 189
CALL: display_forums()

[herbie]

Another no space error.
Clone the drive to a bigger one?

[DrCaleb]

Turn on disk compression.




{runs and hides}

[BartSimpson]

DrCaleb DrCaleb:

Turn on disk compression.




{runs and hides}

Or maybe defrag....

[Thanos]

Like I said over and over, just purge the system of old archived shit that hasn't been touched in years, especially ancient photos that hog so much space, and the problem will probably solve itself. Like delete any thread that's older than eight or ten years considering that the only time they'll ever be looked at again is if some goddamn spammer comes by and digs up all that old trash to post whatever crap they're trying to sell.

[DrCaleb]

We'd love to T. But we are lowly Moderators. File deletion takes an Admin, which means Hyack or Trevor.

[Thanos]

That's no excuse. Like the man says....

[herbie]

Delete files after cloning to bigger drive. Then call for volunteers to rewrite before PhpBB 2, old SQL and PHP are unsupported.
Kind of like all the people I'm updating Win 7 for who stalled updating for five years...

[raydan]

I'm getting an SQL error when trying to post...


...this is a test.



EDIT: Why does this one work, but my post in "Random thoughts, comments and observations" doesn't?

[herbie]

Did it include a pic or an attachment?

[raydan]

herbie herbie:

Did it include a pic or an attachment?

Nope, a link and text.

[herbie]

Run into the same thing once in a while, not recently though. Not a server space issue, more like the site's optimized for the XP and IE4 days...