Introducing Gridbox 2.14.0

Introducing Gridbox 2.14.0 with animation on scroll, LottieFiles and more.
Mon. - Fri. 9 am - 5 pm Ask a Question
Remember me

Error while updating

1 year 4 months ago #1

  • Jurgen's Avatar
  • Jurgen
  • Posts: 11
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
Attachments:

1 year 4 months ago #2

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 25416
Hello,
Thank you for contacting us

With this question you need to contact your hosting support

Best Regards,
Vyacheslav, Balbooa Support Team

1 year 4 months ago #3

  • Jurgen's Avatar
  • Jurgen
  • Posts: 11
Hi,

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

Thanks!

1 year 4 months ago #4

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 25416
Just tell them the error you got: "Fout SQL Row size too large..."

Best Regards,
Vyacheslav, Balbooa Support Team

1 year 4 months ago #5

  • Jurgen's Avatar
  • Jurgen
  • Posts: 11
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.

1 year 4 months ago #6

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 25416
Let us know if you need more assistance!

Best Regards,
Vyacheslav, Balbooa Support Team

1 year 21 hours ago #7

  • Remco's Avatar
  • Remco
  • Posts: 13
Hi Jurgen,

Can you tell me how you have fixed it?

Regards,
Remco

1 year 5 hours ago #8

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 25416
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

1 year 5 hours ago #9

  • Jurgen's Avatar
  • Jurgen
  • Posts: 11
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.

2 months 1 week ago #10

  • Daniel's Avatar
  • Daniel
  • Posts: 16
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

2 months 1 week ago #11

  • Artem's Avatar
  • Artem
  • Posts: 10533
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

2 months 1 week ago #12

  • Daniel's Avatar
  • Daniel
  • Posts: 16
Thank you! :-)

Great Software anyways :-)
Powered by Kunena Forum