Am using domain access module with tb_university theme. it has work well until resent when i try saving theme configuration for a domain I get "PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'settings' at row 1: " error

CommentFileSizeAuthor
error msg.txt75.75 KBallancache
error sreenshot.png80.61 KBallancache
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

allancache created an issue. See original summary.

allancache’s picture

allancache CreditAttribution: allancache commented

I have found out that data size of TB University theme settings is higher than size of other themes such as Batik, Bootstrap and Seven. The reason behind it is that TB University support "Page preview & direct settings" feature which allows you to regions and blocks settings. Therefore, the more blocks and more complex settings your site has will lead to bigger data size of the settings. According to your above error image, data size of TB University settings in your site somehow has been exceeded the maximum size of BLOB in MySQL which is 65535 bytes maximum. At the moment, I suggest you should manually modify type of "settings" column in domain_theme table in your database to a MEDIUMBLOB for 16777215 bytes or a LONGBLOB for 4294967295 bytes. So-that, the column could store more data.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
CreditAttribution: agentrickard as a volunteer commented
Status: Active » Closed (won't fix)
paddy_deburca’s picture

paddy_deburca CreditAttribution: paddy_deburca as a volunteer commented

I have created a sub-theme of bootstrap (https://www.drupal.org/project/bootstrap 7.x-3.10), and when customising the domain theme I experienced the same issue.

Even if I do not change anything, and just edit the theme (admin/structure/domain/view/2/theme/subtheme/theme-settings) and click 'Save configuration', the error happens.

I have altered the domain_theme table, changing the settings column to MEDIUMBLOB from BLOB - this solved my immediate problem. I will continue testing this sub-theme within the domain to see if there are any further side effects.

ALTER TABLE `domain_theme` CHANGE `settings` `settings` MEDIUMBLOB NULL DEFAULT NULL ;