Post A9YWLXwBo9Ey4arKls by tobias@social.diekershoff.de
(DIR) More posts by tobias@social.diekershoff.de
(DIR) Post #A9YUCkzNiItC2M28Dg by jesuisatirebitpickup@squeet.me
2021-07-22T05:59:47Z
0 likes, 0 repeats
@helpersgithub.com/friendica/friendica…downloadsfull-2021.01.tar.gz friendica-addons 2021.01.tar.gzThe files were unpacked and uploaded via ftp to the server.The initial install check page displays only one issue.ImageMagick PHP:No está instalada la extensión ImageMagick PHP - Optional requirement not satisfiedActivating display PHP errors the following warning message is displayed:Warning: shell_exec() has been disabled for security reasons in /var/www/virtual/../htdocs/src/Core/Installer.php on line 254This probably will effect proc_open.What other issues will or might come up by experience with this kind of restricted setup?--------------------------------------------------------------------After completing the initial install process visiting the admin panel for the first time the option proc_open:Don't use "proc_open" with the workeris enabled and fixed by default.---------------------------------------------------------------------Cron job enabled:enabled url executed: subdomains.domain.com/worker */5 * * * *---------------------------------------------------------------------This is Friendica, version 2021.01 that is running at the web location https://subdomain.domain.com. The database version is 1384/1383, the post update version is 1383/.
(DIR) Post #A9YUCnjtULHcZBoIzo by jesuisatirebitpickup@squeet.me
2021-07-22T16:49:04Z
0 likes, 0 repeats
Error message trying to follow this profile over here → System::externalRedirectToInternal Server Error → squeet.me/dfrn_request'https://squeet.me/dfrn_request/jesuisatirebitpickup&addr=6269747069636b75704066656469766572732e747570616d6261652e636f6d is not a relative path, please use System::externalRedirectToException thrown in /var/www/virtual/../htdocs/src/App/BaseURL.php:451Stack trace:#0 /var/www/virtual/../htdocs/src/Model/Contact.php(2198): Friendica\App\BaseURL->redirect()#1 /var/www/virtual/../htdocs/mod/follow.php(188): Friendica\Model\Contact::createFromProbe()#2 /var/www/virtual/../htdocs/mod/follow.php(125): follow_process()#3 /var/www/virtual/../htdocs/src/LegacyModule.php(90): follow_content()#4 /var/www/virtual/../htdocs/src/LegacyModule.php(64): Friendica\LegacyModule::runModuleFunction()#5 [internal function]: Friendica\LegacyModule::content()#6 /var/www/virtual/../htdocs/src/App/Page.php(332): call_user_func()#7 /var/www/virtual/../src/App/Page.php(389): Friendica\App\Page->initContent()#8 /var/www/virtual/../src/App.php(562): Friendica\App\Page->run()#9 /var/www/virtual/../index.php(40): Friendica\App->runFrontend()#10 {main}
(DIR) Post #A9YUCqlQF7HvwnY4IK by heluecht@pirati.ca
2021-07-22T17:06:18Z
0 likes, 0 repeats
Try to follow the other direction. Maybe this works.
(DIR) Post #A9YWL2Nj8EFoCjUsFc by jesuisatirebitpickup@squeet.me
2021-07-22T06:04:22Z
0 likes, 0 repeats
Can't call any profile page or post something.Admin panel and settings panel seem to work well./profile/adminException thrown in /var/www/virtual/ .. /htdocs/src/Module/Profile/Status.php:57Stack trace:#0 /var/www/virtual/../htdocs/src/Module/Profile/Index.php(44): Friendica\Module\Profile\Status::content()#1 [internal function]: Friendica\Module\Profile\Index::content()#2 /var/www/virtual/.. /htdocs/src/App/Page.php(332): call_user_func()#3 /var/www/virtual/.. /htdocs/src/App/Page.php(389): Friendica\App\Page->initContent()#4 /var/www/virtual/ .. /htdocs/src/App.php(562): Friendica\App\Page->run()#5 /var/www/virtual/.. /htdocs/index.php(40): Friendica\App->runFrontend()#6 {main}
(DIR) Post #A9YWL6rIUEHg5bMXtg by tobias@social.diekershoff.de
2021-07-22T11:27:56Z
0 likes, 0 repeats
@jesuisatirebitpickup what is the error exactly? You've only copied the part about where the error is happening.
(DIR) Post #A9YWL9zuodxbpCPyFM by jesuisatirebitpickup@squeet.me
2021-07-22T12:29:36Z
0 likes, 0 repeats
@tobiasCan't call [or display] any profile page or post something/anything.
(DIR) Post #A9YWLIiAQ06wqlBQKe by tobias@social.diekershoff.de
2021-07-22T12:33:27Z
0 likes, 0 repeats
@jesuisatirebitpickup yes, but what is the PHP error that is reported to the logfile. The line above the trace that you have posted should contain it.
(DIR) Post #A9YWLLXdtaTVczHYqO by jesuisatirebitpickup@squeet.me
2021-07-22T12:45:48Z
0 likes, 0 repeats
@tobiasNo line above.In the admin panel there is the following line:Notice: Trying to access array offset on value of type bool in /var/www/virtual/tupambae.net/tupambae.com/fedivers/htdocs/src/Database/Database.php on line 1610Notice: Trying to access array offset on value of type bool in /var/www/virtual/tupambae.net/tupambae.com/fedivers/htdocs/src/Database/Database.php on line 1610logoFriendicaPHP Version 7.4.21
(DIR) Post #A9YWLOMlOUYUO7DPns by jesuisatirebitpickup@squeet.me
2021-07-22T12:56:51Z
0 likes, 0 repeats
@tobiasTrying to activate:Administration - LogsEnable Debugging/admin/logs/view says:Error trying to open <strong>log/friendica.log</strong> log file.\r\n<br/>Check to see if file log/friendica.log exist and is readable.Should I create a folder /log and the respective friendica.log?
(DIR) Post #A9YWLRCaqlCdBRTprs by jesuisatirebitpickup@squeet.me
2021-07-22T13:06:10Z
0 likes, 0 repeats
@tobiasJust created the log file, first entry:2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}
(DIR) Post #A9YWLTzaTZa7pyPzVo by jesuisatirebitpickup@squeet.me
2021-07-22T13:21:15Z
0 likes, 0 repeats
some more log file entries:2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}2021-07-22T13:05:01Z index [NOTICE]: no data for session {"session_id":"utnoe5qtf85oj838rrjv32tanv","uri":"\/worker"} - {"file":"Database.php","line":72,"function":"read","uid":"43c183","process_id":18245}2021-07-22T13:06:21Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, Network::getItems, Network::content, call_user_func, Page::initContent, Page::run, App::runFrontend","params":"SELECT * FROM `network-thread-view` WHERE (`uid` = 2) ORDER BY `received` DESC LIMIT 40"} - {"file":"Database.php","line":662,"function":"p","uid":"286044","process_id":18245}2021-07-22T13:06:21Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"286044","process_id":18245}2021-07-22T13:06:24Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, Network::getItems, Network::rawContent, call_user_func, Module::run, App::runFrontend","params":"SELECT * FROM `network-item-view` WHERE (`unseen` = 1 AND `gravity` = 0 AND `uid` = 2) ORDER BY `received` DESC LIMIT 100"} - {"file":"Database.php","line":662,"function":"p","uid":"32e0cc","process_id":18245}2021-07-22T13:06:25Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"0de3be","process_id":18245}2021-07-22T13:06:25Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"0de3be","process_id":18245}
(DIR) Post #A9YWLXwBo9Ey4arKls by tobias@social.diekershoff.de
2021-07-22T14:19:53Z
0 likes, 0 repeats
@jesuisatirebitpickup regarding those "needs to be re-prepared" messages, I think @heluecht knows the config setting you need to apply.
(DIR) Post #A9YWLdsrhQ98W1LlQG by heluecht@pirati.ca
2021-07-22T15:06:00Z
0 likes, 0 repeats
'pdo_emulate_prepares' => true,
(DIR) Post #A9YWLgkT36DBOqRbFY by jesuisatirebitpickup@squeet.me
2021-07-22T15:26:42Z
0 likes, 0 repeats
@heluecht @tobias'pdo_emulate_prepares' => true,¿?Where do I find this to set it?I guess in the DB?Where?
(DIR) Post #A9YWLhseq8MCuXHeee by kinetix@social.isurf.ca
2021-07-22T15:44:36Z
0 likes, 0 repeats
I believe in your friendica config file - might be config/local.config.php (it's what I'm still using but the location changed over the years). In the 'database' section, you'd want the line @heluecht suggested.
(DIR) Post #A9YWLkvxUJmQNdqpiS by jesuisatirebitpickup@squeet.me
2021-07-22T16:07:07Z
0 likes, 0 repeats
@kinetix @tobias¿Something like this @heluecht ?local.config.php'database' => ['hostname' => 'localhost','username' => 'xxxx','password' => 'xxxxx','database' => 'xxxxxx','charset' => 'utf8mb4', 'pdo_emulate_prepares' => true,],
(DIR) Post #A9YWLo0g3EKxv958zI by heluecht@pirati.ca
2021-07-22T16:18:11Z
0 likes, 0 repeats
Yes. This might work. But in that version the feature was new and I'm not very confident that it worked well.