• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Installation of RSform update fails- sql error

Installation of RSform update fails- sql error 3 years 6 days ago #42013

Hi,
Getting this error when trying to install an update on joomla 3.x:
SQLSTATE[42000]: Syntax error or access violation: 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
problem is I can't find the row that needs to be changed.
Thanks
The administrator has disabled public write access.

Installation of RSform update fails- sql error 2 years 8 months ago #42199

  • dragos
  • dragos's Avatar
  • OFFLINE
  • Administrator
  • Posts: 634
  • Thank you received: 117
Hello,

What you're experiencing is most likely due to the fact that when your initial RSForm!Pro tables were created, you had an older version of MySQL. You can take these steps:

- make a full backup of your database.

- access your database manager like phpMyAdmin and change the ROW_FORMAT for your RSForm!Pro tables (these have a "rsform" prefix) to DYNAMIC instead (you probably have COMPACT thus your issue).

- after this is done, try the manual update for RSForm!Pro
The administrator has disabled public write access.

Installation of RSform update fails- sql error 2 years 3 months ago #42527

The SQL Statement for this is ->
ALTER TABLE `yourprefix_rsticketspro_*all_tables_from_rs` ROW_FORMAT=DYNAMIC;

Got the same issue, with this MySQL fix the update works and the system is runnin.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!