Hello #MariaDB people, my #Friendica server is down since I installed the latest MariaDB update and it also switched from #PHP 7 to 8.
All I get in the php error log is this:
Any ideas are welcome! I need your help!
!Friendica Support #help
All I get in the php error log is this:
4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
Any ideas are welcome! I need your help!
!Friendica Support #help
hoergen
•utzer (on squeet.me)
•https://www.linuxquestions.org/questions/slackware-14/heads-up-mariadb-10-6-breaking-change-4175694396/
I think I will set this, but generally I wonder if this is a Friendica thing or how I can "convert" my database to not do compression.
@Michael Vogel I think, as you told you use compression, you want to check it and I hope I can follow your solution after. I am really no good in database management/setting.
Michael Vogel
•Michael Vogel
•worker-ipc
must not be converted.utzer (on squeet.me)
•I did this query here:
and got:
... show more
I did this query here:
and got:
Michael Vogel
•DYNAMIC
for all tables exceptworker-ipc
which isMEMORY
.utzer (on squeet.me)
•Do you happen to know how I can run this query so it lists all tables with any format?
utzer (on squeet.me)
•script:
maybe someone can use this. Get a list of tables to convert with this query in mysql:
this lists all compressed tables, take all items from the list that do not have an @ in the name, add all those table names in the place where
tbl1 tbl2
is above.utzer (on squeet.me)
•utzer (on squeet.me)
•utzer (on squeet.me)
•Tealk
•utzer (on squeet.me)
•Tealk
•dann versuch ich auch mal auf php8 umzustellen, mal sehen was dann noch geht :P
Tealk
•sonst bekam ich nur den Fehler: