Latest develop fails to run SQL update
@Friendica Developers I have an error while the db update
was running, Friendica was sending me an email about it.
The friendica developers released update 1274 recently,
but when I tried to install it, something went terribly wrong.
This needs to be fixed soon and I can't do it alone. Please contact a
friendica developer if you can not help me on your own. My database might be invalid.
The error message is
Errors encountered performing database changes: ALTER IGNORE TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, ...
On console I get this error:
Error 1296 occurred during database update:
Got error 64 'Temp file write failure' from InnoDB
I'm now back at my old commit so the instance can work again.
Roland Häder🇩🇪
Unknown parent • •I think this okay?
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •tmpfs 3960216 2076 3958140 1% /tmp
I try another update now. Thank you for the head up.
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •/tmp/
? Maybe the worker (CLI) has done this because ofphp.ini
setting?Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Notice: Undefined index: url in /home/quix0r/NetBeansProjects/friendica/src/Object/Post.php on line 359
. Maybe it does not exist at all initem
table? @Hyp??li????e Pet????van (he/him) @Michael Vogel or maybe #tpyo ?uri
does exist.Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •url
there.Roland Häder🇩🇪
Unknown parent • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •E_NOTICE
here:Notice: Undefined index: title in /var/www/../src/Content/Text/BBCode.php on line 565
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Notice: Undefined index: term in /var/www/../mod/filer.php on line 18
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •property_exists()
where needed.Roland Häder🇩🇪
Unknown parent • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •And I think I remember that it is lesser recommended for properties of
stdClass
objects.And yet another
E_NOTICE
here:Notice: Undefined index: verb in /var/www/../src/Core/NotificationsManager.php on line 281
. It origins from the system notification list view (/notifications/system
.Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
Unknown parent • •Paradigms
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •And 2 more
E_NOTICE
:Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Notice: Undefined index: allow_api in /var/www/../addon/xmpp/xmpp.php on line 98
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •#xdebug let suppressed warnings/errors scream:
This whole thing can be done otherwise:
- remove the
@
from it- use
file_exists()
oris_readable()
to check if file exists- if so, read it, otherwise skip further parts
This leads to better code. In addition to that, maybe this particular thing can be encapsulated away in a class?
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Some more (still there?) while requesting to follow an OStatus account:
And one from when the daemon is running:
Notice: Undefined offset: 0 in /../src/Model/GContact.php on line 970
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •( ! ) Notice: Undefined index: marital in /../mod/profiles.php on line 250
and also later for line 314.Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •$item
has really no element 'body':Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Editing a photo causes
E_NOTICEs
:Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •Notice: Undefined index: verb in /var/www/../src/Core/NotificationsManager.php on line 276
Here,
$it
misses that element.