Hello @ Friendica Support 😀

I have an error that is popping up in the logs. I am not sure how to address it. I have tried to increase the amount of memory allocated to PHP. I have increased it from 128M (the default) to 1G. This did not make any difference. The server has 8G for the operating system. My question is, where can I adjust the memory settings to resolve this error with Database.php?

Here is the error message that I am getting along with information from Overview and my PHP info.

Thanks in advance for any help you can provide 🙂

Error Message

worker Fatal Error (E_ERROR): Allowed memory size of 134217728 bytes exhausted (tried to allocate 23085056 bytes)
Event details
code
1
message
Allowed memory size of 134217728 bytes exhausted (tried to allocate 23085056 bytes)
file
/var/www/html/src/Database/Database.php
line
541
trace
Source
file
line
function
request-id 67d04af996b3a
stack ErrorHandler::handleFatalError
uid 840d6a
process_id 375312

-=-=-=-=-
Overview

Version
Friendica 'Interrupted Fern' 2024.12 - 1577
Server Settings
PHP
version 8.2.26
php.ini /etc/php/8.2/apache2/php.ini
upload_max_filesize 8M
post_max_size 16M
memory_limit 1G
MySQL / MariaDB
max_allowed_packet 16777216

-=-=-=-
PHP Info

PHP Version 8.2.26
System Linux Friendica 6.5.11-7-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-7 (2023-12-05T09:44Z) x86_64
Build Date Nov 25 2024 17:21:51
Build System Linux
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php/8.2/apache2
Loaded Configuration File /etc/php/8.2/apache2/php.ini
Scan this dir for additional .ini files /etc/php/8.2/apache2/conf.d
Additional .ini files parsed /etc/php/8.2/apache2/conf.d/10-mysqlnd.ini, /etc/php/8.2/apache2/conf.d/10-opcache.ini, /etc/php/8.2/apache2/conf.d/10-pdo.ini, /etc/php/8.2/apache2/conf.d/15-xml.ini, /etc/php/8.2/apache2/conf.d/20-calendar.ini, /etc/php/8.2/apache2/conf.d/20-ctype.ini, /etc/php/8.2/apache2/conf.d/20-curl.ini, /etc/php/8.2/apache2/conf.d/20-dom.ini, /etc/php/8.2/apache2/conf.d/20-exif.ini, /etc/php/8.2/apache2/conf.d/20-ffi.ini, /etc/php/8.2/apache2/conf.d/20-fileinfo.ini, /etc/php/8.2/apache2/conf.d/20-ftp.ini, /etc/php/8.2/apache2/conf.d/20-gd.ini, /etc/php/8.2/apache2/conf.d/20-gettext.ini, /etc/php/8.2/apache2/conf.d/20-gmp.ini, /etc/php/8.2/apache2/conf.d/20-iconv.ini, /etc/php/8.2/apache2/conf.d/20-imagick.ini, /etc/php/8.2/apache2/conf.d/20-imap.ini, /etc/php/8.2/apache2/conf.d/20-intl.ini, /etc/php/8.2/apache2/conf.d/20-mbstring.ini, /etc/php/8.2/apache2/conf.d/20-mysqli.ini, /etc/php/8.2/apache2/conf.d/20-pdo_mysql.ini, /etc/php/8.2/apache2/conf.d/20-phar.ini, /etc/php/8.2/apache2/conf.d/20-posix.ini, /etc/php/8.2/apache2/conf.d/20-readline.ini, /etc/php/8.2/apache2/conf.d/20-shmop.ini, /etc/php/8.2/apache2/conf.d/20-simplexml.ini, /etc/php/8.2/apache2/conf.d/20-sockets.ini, /etc/php/8.2/apache2/conf.d/20-sysvmsg.ini, /etc/php/8.2/apache2/conf.d/20-sysvsem.ini, /etc/php/8.2/apache2/conf.d/20-sysvshm.ini, /etc/php/8.2/apache2/conf.d/20-tokenizer.ini, /etc/php/8.2/apache2/conf.d/20-xdebug.ini, /etc/php/8.2/apache2/conf.d/20-xmlreader.ini, /etc/php/8.2/apache2/conf.d/20-xmlwriter.ini, /etc/php/8.2/apache2/conf.d/20-xsl.ini, /etc/php/8.2/apache2/conf.d/20-zip.ini
PHP API 20220829
PHP Extension 20220829
Zend Extension 420220829
Zend Extension Build API420220829,NTS
PHP Extension Build API20220829,NTS
Debug Build no
Thread Safety disabled
Zend Signal Handling enabled
Zend Memory Manager enabled
Zend Multibyte Support provided by mbstring
Zend Max Execution Timers disabled
IPv6 Support enabled
DTrace Support available, disabled
Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters zlib.*, string.rot13, string.toupper, string.tolower, convert.*, consumed, dechunk, convert.iconv.*

!Friendica Support

!Friendica Support
Does anyone else have a problem trying to connect with @meldrik@lemmy.wtf?

I can follow the profile in Mastodon, but when I enter this user in the box to connect with them, I get a white screen, and I see this in the log

2025-02-07T12:22:07Z app [ERROR]: Uncaught Exception TypeError: "Friendica\Addon\s3_storage\src\S3Client:😛ut(): Argument #1 ($data) must be of type string, null given, called in /var/www/html/src/Model/Photo.php on line 446" at /var/www/html/addon/s3_storage/src/S3Client.php line 73 {"exception":"TypeError: Friendica\\Addon\\s3_storage\\src\\S3Client:😛ut(): Argument #1 ($data) must be of type string, null given, called in /var/www/html/src/Model/Photo.php on line 446 and defined in /var/www/html/addon/s3_storage/src/S3Client.php:73\nStack trace:\n#0 /var/www/html/src/Model/Photo.php(446): Friendica\\Addon\\s3_storage\\src\\S3Client->put()\n#1 /var/www/html/src/Model/Photo.php(638): Friendica\\Model\\Photo::store()\n#2 /var/www/html/src/Model/Contact.php(2412): Friendica\\Model\\Photo::importProfilePhoto()\n#3 /var/www/html/src/Model/Contact.php(2924): Friendica\\Model\\Contact::updateAvatar()\n#4 /var/www/html/src/Model/Contact.php(1461): Friendica\\Model\\Contact::updateFromProbeArray()\n#5 /var/www/html/src/Model/Contact.php(321): Friendica\\Model\\Contact::getIdForURL()\n#6 /var/www/html/src/Module/Contact/Follow.php(109): Friendica\\Model\\Contact::getByURL()\n#7 /var/www/html/src/BaseModule.php(236): Friendica\\Module\\Contact\\Follow->content()\n#8 /var/www/html/src/App.php(668): Friendica\\BaseModule->run()\n#9 /var/www/html/index.php(32): Friendica\\App->runFrontend()\n#10 {main}"} - {"file":null,"line":null,"function":null,"request-id":"67a5fae9a5295","stack":"ErrorHandler::handleException (114), ErrorHandler::Friendica\\Core\\Logger\\Handler\\{closure}","uid":"658b76","process_id":2208182}

Just me?

Hi !Friendica Support

I set up a Friendica server couple days ago. We have seen couple times a problem where an image attached to a post is visible only to the author of the post. This doesn't happen all the time or for all the images, but has happened to multiple users. If the image is shown broken once, it will stay broken. All the users are on the same server.

- As far as I know, this has happened only in private posts.
- Same person has posted both an image I can see and an image I can't see.
- As the author can see the image in the post, the data definitely is on the server and even accessible from the UI.
- Editing the post and re-adding the image didn't fix the problem.

The error message shown when trying to open a broken image is:

Not Found

The Photo with id 1181454791679d39a348725148987421 is not available.

#0 /var/www/html/src/BaseModule.php(230): Friendica\Module\Photo->rawContent()
#1 /var/www/html/src/Module/BaseApi.php(95): Friendica\BaseModule->run()
#2 /var/www/html/src/App.php(668): Friendica\Module\BaseApi->run()
#3 /var/www/html/index.php(32): Friendica\App->runFrontend()
#4 {main}

Request: 679debda529e1

Server info:
This is Friendica, version 2024.12 that is running at the web location https://capybara.community. The database version is 1576/1576, the post update version is 1550/1550.

Any ideas what could be wrong or how to continue debugging this?

(I'll be able to investigate this now for couple hours. After that I'll have to come back to this on Monday.)

I'm writing this from my Piefed server because my Friendica server, my-place.social, can no longer view helpers@forum.friendi.ca. I get a 500 error. As far as I can tell, viewing all other groups and contacts works fine.

This problem may be related to the Wasabi outage from yesterday. I use Wasabi S3 for image storage, and they had a partial outage yesterday that caused obvious issues on the server, like blurred images. I say this because the exception may be image related.

This is the error in the friendica log:

2024-11-30T13:23:16Z app [ERROR]: ** Uncaught Exception TypeError: "Friendica\Object\Image::__construct(): Argument #1 ($data) must be of type string, null given, ** called in /var/www/html/src/Object/Image.php on line 781" at /var/www/html/src/Object/Image.php line 62 {"exception":"TypeError: Friendica\Object\Image::__construct(): Argument #1 ($data) must be of type string, null given, called in /var/www/html/src/Object/Image.php on line 781 and defined in /var/www/html/src/Object/Image.php:62\nStack trace:\n#0 /var/www/html/src/Object/Image.php(781): Friendica\Object\Image->__construct()\n#1 /var/www/html/src/Model/Post/Link.php(152): Friendica\Object\Image->getBlurHash()\n#2 /var/www/html/src/Model/Post/Link.php(79): Friendica\Model\Post\Link::fetchMimeType()\n#3 /var/www/html/src/Content/Text/BBCode.php(321): Friendica\Model\Post\Link::getByLink()\n#4 /var/www/html/src/Content/Text/BBCode.php(861): Friendica\Content\Text\BBCode:😛roxyUrl()\n#5 [internal function]: Friendica\Content\Text\BBCode::Friendica\Content\Text\{closure}()\n#6 /var/www/html/src/Content/Text/BBCode.php(851): preg_replace_callback()\n#7 /var/www/html/src/Content/Text/BBCode.php(1883): Friendica\Content\Text\BBCode::convertImages()\n#8 /var/www/html/src/Content/Text/BBCode.php(1389): Friendica\Content\Text\BBCode::convertImagesToHtml()\n#9 /var/www/html/src/Util/Strings.php(517): Friendica\Content\Text\BBCode::Friendica\Content\Text\{closure}()\n#10 /var/www/html/src/Content/Text/BBCode.php(2517): Friendica\Util\Strings:😛erformWithEscapedBlocks()\n#11 /var/www/html/src/Content/Text/BBCode.php(1324): Friendica\Content\Text\BBCode:😛erformWithEscapedTags()\n#12 /var/www/html/src/Util/Strings.php(517): Friendica\Content\Text\BBCode::Friendica\Content\Text\{closure}()\n#13 /var/www/html/src/Content/Text/BBCode.php(2517): Friendica\Util\Strings:😛erformWithEscapedBlocks()\n#14 /var/www/html/src/Content/Text/BBCode.php(1323): Friendica\Content\Text\BBCode:😛erformWithEscapedTags()\n#15 /var/www/html/src/Content/Text/BBCode.php(1283): Friendica\Content\Text\BBCode::convert()\n#16 /var/www/html/src/Model/Item.php(3340): Friendica\Content\Text\BBCode::convertForUriId()\n#17 /var/www/html/src/Model/Item.php(3471): Friendica\Model\Item:😛utInCache()\n#18 /var/www/html/src/Object/Post.php(464): Friendica\Model\Item:😛repareBody()\n#19 /var/www/html/src/Object/Post.php(655): Friendica\Object\Post->getTemplateData()\n#20 /var/www/html/src/Object/Post.php(655): Friendica\Object\Post->getTemplateData()\n#21 /var/www/html/src/Object/Post.php(655): Friendica\Object\Post->getTemplateData()\n#22 /var/www/html/src/Object/Thread.php(204): Friendica\Object\Post->getTemplateData()\n#23 /var/www/html/src/Content/Conversation.php(680): Friendica\Object\Thread->getTemplateData()\n#24 /var/www/html/src/Content/Conversation.php(583): Friendica\Content\Conversation->getThreadList()\n#25 /var/www/html/src/Model/Contact.php(1725): Friendica\Content\Conversation->render()\n#26 /var/www/html/src/Module/Contact/Conversations.php(123): Friendica\Model\Contact::getThreadsFromId()\n#27 /var/www/html/src/BaseModule.php(250): Friendica\Module\Contact\Conversations->content()\n#28 /var/www/html/src/App.php(682): Friendica\BaseModule->run()\n#29 /var/www/html/index.php(46): Friendica\App->runFrontend()\n#30 {main}"} - {"file":null,"line":null,"function":null,"request-id":"674b11c1ce218","stack":"ErrorHandler::handleException (128), ErrorHandler::Friendica\Core\Logger\Handler\{closure}","uid":"caec99","process_id":9285}

I tried updating the contact information, unfollowing/following. I can't view it from any other account on the server. I assume the contact record in the database is corrupted.

I thought of playing with the .console archive function to archive the contact and see if I can follow it again to have the server build a new record, but stuff like this could have unintended consequences. So, I'm reaching out first.

Does anyone have advice on how to fix this?

!Friendica Support
I had my first-ever server crash of https://my-place.social. This is in syslog:

2024-11-18T21:34:49.022603-05:00 my-place php: PHP Fatal error: Uncaught mysqli_sql_exception: Too many connections in /var/www/html/src/Database/Database.php:201
2024-11-18T21:34:49.022822-05:00 my-place php: Stack trace:
2024-11-18T21:34:49.022855-05:00 my-place php: #0 /var/www/html/src/Database/Database.php(201): mysqli->__construct()
2024-11-18T21:34:49.022885-05:00 my-place php: #1 /var/www/html/src/Database/Database.php(106): Friendica\Database\Database->connect()
2024-11-18T21:34:49.022911-05:00 my-place php: #2 [internal function]: Friendica\Database\Database->__construct()
2024-11-18T21:34:49.022933-05:00 my-place php: #3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
2024-11-18T21:34:49.022958-05:00 my-place php: #4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.022985-05:00 my-place php: #5 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023014-05:00 my-place php: #6 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023049-05:00 my-place php: #7 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023074-05:00 my-place php: #8 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023100-05:00 my-place php: #9 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023125-05:00 my-place php: #10 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023147-05:00 my-place php: #11 /var/www/html/index.php(34): Dice\Dice->create()
2024-11-18T21:34:49.023172-05:00 my-place php: #12 {main}
2024-11-18T21:34:49.023208-05:00 my-place php: thrown in /var/www/html/src/Database/Database.php on line 201

show variables like 'max_connections'; shows 151 max_connections.

I did: SET GLOBAL max_connections = 200;

I also edited /etc/mysql/mariadb.conf.d/50-server.cnf and set max_connections = 200

Is this too high? Too low? Did I do this the correct way?

Thank you!

Thanks!

Uppsi.
The Server works so far, but going to /admon/site throws an error:
---
Service Unavailable

unable to create directory /var/www/friendica/view/smarty3/compiled/58/70/d1

Exception thrown in /var/www/friendica/src/Core/Renderer.php:90
Stack trace:
#0 /var/www/friendica/src/Module/Admin/Site.php(592): Friendica\Core\Renderer::replaceMacros('file:/var/www/f...', Array)
#1 /var/www/friendica/src/BaseModule.php(250): Friendica\Module\Admin\Site->content(Array)
#2 /var/www/friendica/src/App.php(711): Friendica\BaseModule->run(Object(Friendica\Module\Special\HTTPException), Array)
#3 /var/www/friendica/index.php(55): Friendica\App->runFrontend(Object(Friendica\App\Router), Object(Friendica\Core\PConfig\Type\JitPConfig), Object(Friendica\Security\Authentication), Object(Friendica\App\Page), Object(Friendica\Content\Nav), Object(Friendica\Module\Special\HTTPException), Object(Friendica\Util\HTTPInputData), 1702744026.4542, Array)
#4 {main}

Request: 657dcfda7165b
---
BTW. Sorry for not using some formatting (e.g., for code), but currently, I'm running from a live Slax on an ancient laptop with an exotic German keyboard.

New error message (of FRIO) about a folder created by the user root.

I haven't found the extensive conversation about this problem with @Hypolite Petovan yet but I'm quite sure that I changed all folders to ownership of user www-data before 28th of November of the smarty folder. Actually there was another conversation about ownership of folders and I changed all folders to be owned by root except storage and view that day on 02:45hs, the new folder owned by root at /view/smarty3/compiled/ like stated below was created on 3:50hs.

As for what I remember of all the conversations this shouldn't have happened.

<?php
/* Smarty version 4.3.1, created on 2023-11-28 03:50:02
  from '7cd2693513597460a71347ba02d3179c5e5ab822' */
/* @var Smarty_Internal_Template $_smarty_tpl */
if ($_smarty_tpl->_decodeProperties($_smarty_tpl, array (
  'version' => '4.3.1',
  'unifunc' => 'content_6565636a645732_50647552',
  'has_nocache_code' => false,
  'file_dependency' => 
  array (
  ),
  'includes' => 
  array (
  ),
),false)) {
function content_6565636a645732_50647552 (Smarty_Internal_Template $_smarty_tpl) {
?>[url=https://tupambae.org/profile/utopiarte]utopiArte[/url] replied to you on [url=https://tupambae.org/display/0ac89072-1065-6562-6405-8bb240314547]"bugreport - can't answer, like or reshare posts"[/url]<?p>

@Friendica Support

#bugResearch

hi there, I have this message in my php.error.log

what should I do?

I didn't have a look at gitHub

@utzer [Friendica]
smallest VPS:
VPS #1
1GB RAM
1 CPU
25GB DISK
1TB TRANSFER(tx+rx)

your recomandation:
VPS #4
8GB RAM
4 CPU
160GB DISK
5TB TRANSFER(tx+rx)

btw, this is what they state about the debian options:

OpenVPN
For freedom fighters
The only VPN to be trusted is the one you have full control over.
The server and client certificates are automatically generated and the client file sent via email to the customer after. Runs on port 443, which is almost always accessible. All logging is sent to /dev/null and DNS queries are made on the same server.

Wireguard
Also for freedom fighters
40-50% faster than OpenVPN.
Route all your traffic through an encrypted tunnel, perfect for bypassing internet controlled by a fascist government.

LEMP
Ready to use webserver
LEMP stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. It comes preconfigured with an optimized PHP setup which can run, depending on the size of the server, load heavy sites. It is also good as a content delivery server for example advertisement banners, videos, or even a fileserver for files to download.

Nextcloud Server
Ready to use Nextcloud
Run your own cloud service.
Nextcloud, the next generation open source Enterprise File Sync and Share software, the server is optimized for high usage with Let's Encrypt https certificate.

@bitPickup mʕ•ﻌ•ʔm @Hank G ☑️ @Raroun @TupambAdmin

!Friendica Support
https://wiki.friendi.ca/docs/install
So I am stuck at the create a database point. I can't tell if they just told me, create a database without telling me how or if this helped create a database. I went with B and here were the resutls. Are there peices missing or are these warnings ok for the system we are using?

$ bin/console autoinstall -v
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Executable: /home/anubis2814/mywebsite/bin/console.php
Arguments: array (
0 => 'autoinstall',
)
Options: array (
'v' => 1,
)
Command: autoinstall
Initializing setup...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Complete!

Checking environment...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.

[Error] --------
GNU Multiple Precision PHP module: Error: GNU Multiple Precision PHP module required but not installed.

[Backtrace]:
#0 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Console\AutomaticInstallation->doExecute()
#1 /home/anubis2814/mywebsite/src/Core/Console.php(163): Asika\SimpleConsole\Console->execute()
#2 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Core\Console->doExecute()
#3 /home/anubis2814/mywebsite/bin/console.php(41): Asika\SimpleConsole\Console->execute()
#4 {main}