Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

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
2 years 4 months ago - 2 years 4 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: 2 years 4 months ago by yellowbird.

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum