Error while updating

Hello,

I got this error message while trying to update BAFORMS:

Waarschuwing
JInstaller: :Installeren: Fout SQL 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
Extensie Update: SQL fout verwerken zoekopdracht: DB functie is mislukt met het volgende foutnummer 1118
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 `#__baforms_forms` ADD COLUMN `acym_lists` text NOT NULL;
Pakket Update: Er deed zich een fout voor tijdens het installeren van een extensie: com_baforms.zip

Hello,
Thank you for contacting us

With this question you need to contact your hosting support

Best Regards,
Vyacheslav, Balbooa Support Team

Hi,

not an expert here; so what exactly should the host do about it?

Thanks!

Just tell them the error you got: "Fout SQL Row size too large..."

Best Regards,
Vyacheslav, Balbooa Support Team

Did some further googling and this ARTICLE explained it very well.

Turns out, with a lot of columns being set to VARCHAR(255), the grand total makes up for the row being too long.

I changed the column 'title' from VARCHAR(255) to TEXT and after that the update went fine.

Let us know if you need more assistance!

Best Regards,
Vyacheslav, Balbooa Support Team

Hi Jurgen,

Can you tell me how you have fixed it?

Regards,
Remco

Hello,
Thank you for contacting us

With this error (Error SQL Row size too large.) You need to contact your hosting support

Best Regards,
Vyacheslav, Balbooa Support Team

Hello Remco,

I logged into my database through PHPmyadmin, then searched for the table "#__baforms_forms", and then I changed the column "title" from "VARCHAR(255)" to "TEXT".

After this the update worked fine.

Just came up to this Error, could believe what I read here.
Whether Hosting Provider nor the Joomla Team has something to do with the Table x_baforms_forms.
Or am I wrong?? The Table _baforms_forms was created by balbooa not from the Hosting Provider.
The title Column VARCHAR255 as well.
Just change to TEXT was perfect. Would be good to have better support in those cases as just refer to other Support Channels which are not responsible.

Sorry, but just honest feedback.
Glad that I found this Forum Post.

thank you, @jurgen

Hi there!

to Daniel
Thank you for your comment about our technical support. We will do our best to improve this moment. Sorry for the inconvenience!

to Jurgen
Thank you for sharing the solution with the community

Regards,
Artem, Balbooa.com

Thank you!

Great Software anyways