Saving Remote Data Sources

[nilshoerrmann]

Double quotes " inside the Included Elements field are breaking the backend:

Symphony Fatal Database Error: Unknown column 'namespace' in 'field list'

Single quotes work. This is on Symphony 2.6.0-alpha.

[nilshoerrmann]

It seems like the quotes are not the culprit. It happens on every second attempt to save (1, 3, 5 …).

[nilshoerrmann]

Wild guess: might this be related to the autoload changes in the core?

[nilshoerrmann]

This is the erroneous line:

MySQL Error (1054): Unknown column 'namespace' in 'field list' in query: INSERT INTO `sym_cache` (`hash`, `creation`, `expiry`, `data`, `namespace`) VALUES ('703945698188300f7dbbcfadbb121be7', '1416993837', '1416994137', 'eCodEDgaRbaGE', null)

[nilshoerrmann]

Aha, the migration file for 2.6.0 contains this:

ALTER TABLE `tbl_cache` ADD `namespace` VARCHAR(255) COLLATE utf8_unicode_ci;

But the installer excludes that column.

[nilshoerrmann]

Executing that command fixes the issue.