Joomla 6 Notice

We are pleased to announce that all our Joomla extensions have been compatible with Joomla 6 since October 14th, 2025.

For those currently upgrading from Joomla 3 to 4: Instructions for Joomla 4 migration can be found here:

There are standalone documentations Visforms Joomla 4, Visforms Joomla 5 and Visforms Joomla 6.

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

Update auf 3.14.10 Fehler Row size too large + FIX

More
3 years 8 months ago - 3 years 8 months ago #8273 by yellowbird
Hallo zusammen,
ich habe gerade veruscht, die herunter geladene Version 3.14.10 über eine ältre Version zu installieren.

Fehlermeldung:
<quote>JInstaller: :Install: SQL-Fehler Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Erweiterung „Aktualisierung“: SQL Fehler beim Ausführen der Abfrage: „DB-Funktion mit Fehlercode 1118 fehlgeschlagen!
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
SQL =ALTER TABLE `#__visfields` ADD COLUMN `isfilterfield` tinyint(1) DEFAULT 0 NOT NULL;“
Paket Installieren: Bei der Installation der Erweiterung trat ein Fehler auf: com_visforms_j3.9.0_3.14.10.zip
</quote>

Das scheint daran zu liegen, dass die Tabelle(n) noch im älteren COMPACT Format angelegt wurden.
Geholfen hat:
MariaDB> ALTER TABLE meinjoomlaprefix_visfield ROW_FORMAT=DYNAMIC;
MariaDB> ALTER TABLE meinjoomlaprefix_visfields ADD COLUMN `isfilterfield` tinyint(1) DEFAULT 0 NOT NULL;
Wenn man sicherheitshalber das Paket noch einmal neu installieren möchte, darf das zweite ALTER nicht ausgeführt werden.

Vielleicht hilft es ja jemandem!
Last edit: 3 years 8 months ago by yellowbird.

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum