search

symphonycms / remote_datasource

An improved datasource to fetch data from TXT, CSV, XML and JSON sources.
Other
14 stars 9 forks source link

Saving Remote Data Sources #28

Closed nilshoerrmann closed 9 years ago

nilshoerrmann commented 9 years ago

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 commented 9 years ago

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

nilshoerrmann commented 9 years ago

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

nilshoerrmann commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

Executing that command fixes the issue.