Hello

I am unable to save a layout on a new installation of Display Suite, getting:

user warning: Field 'fields' doesn't have a default value query: INSERT INTO ds_settings (module, type, build_mode, settings) VALUES ('nd', 'profile', 'full', 'a:3:{s:6:\"fields\";a:1:{s:5:\"links\";a:5:{s:6:\"region\";s:6:\"header\";s:6:\"weight\";s:4:\"-100\";s:6:\"format\";s:0:\"\";s:9:\"css-class\";s:0:\"\";s:11:\"labelformat\";s:6:\"hidden\";}}s:6:\"status\";i:1;s:13:\"region_styles\";a:5:{s:6:\"header\";s:0:\"\";s:4:\"left\";s:0:\"\";s:6:\"middle\";s:0:\"\";s:5:\"right\";s:0:\"\";s:6:\"footer\";s:0:\"\";}}')

I've tried modifying the database to include a default field, but was not successful (the 'field' type is a blob/longtext, which apparently can't have a default value)

Using Drupal 6.22
PHP 5.2.17 (Zend CE)
MySQL 5.5.13

CommentFileSizeAuthor
#4 1416986.patch1.55 KBxtfer

Comments

hctom’s picture

hctom
Primary language German
commented

I can confirm that this error also already happens when trying to run the update hook of DS.

xtfer’s picture

xtfer commented
Priority: Normal » Critical
xtfer’s picture

xtfer commented
Priority: Critical » Major
Status: Active » Postponed (maintainer needs more info)

I can't repeat this on a clean installation using the latest versions of Display Suite (2.1) and Node Displays (2.8). Can you provide more information on your configuration, and how you triggered the error (what were you saving, for example)?

xtfer’s picture

xtfer commented
Status: Postponed (maintainer needs more info) » Active
StatusFileSize
new 1416986.patch1.55 KB

Having done some more research, this appears to be an issue where some versions of MySQL (and possibly PGSQL) don't create table schema's correctly (hence why I can't repeat it).

The attached patch should change the schema to fix this issue. I would appreciate it if some could apply the patch and see if their problem goes away. Note, you will need to run update.php if applying to an existing site.

xtfer’s picture

xtfer commented
Status: Active » Needs review
xtfer’s picture

xtfer commented
Status: Needs review » Fixed

This has been pushed to the latest -dev, so Im going to close this. Please reopen if that doesnt fix it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.