I just created a fresh DB / Table with some demo data.
Column with ID 1 works, Column with ID 2 causes problems…
SQL - File for import (MySQL):
CREATE TABLE IF NOT EXISTS test
(
ID
int(11) NOT NULL,
Test1
varchar(200) NOT NULL,
Test2
longtext NOT NULL,
Test3
text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO test
(ID
, Test1
, Test2
, Test3
) VALUES
(1, ‘demotest’, ‘Some really long text for testing…’, ‘Other text’),
(2, ‘Zürich’, ‘Zürich in Switzerland’, ‘Zürich also in CH’);
This is schema dump:
{
“name”: “test”,
“is_view”: false,
“label”: “Test”,
“plural”: “Tests”,
“description”: null,
“alias”: null,
“field”: [
{
“name”: “ID”,
“label”: “ID”,
“description”: null,
“type”: “integer”,
“db_type”: “int(11)”,
“length”: 11,
“precision”: null,
“scale”: null,
“default”: null,
“required”: true,
“allow_null”: false,
“fixed_length”: false,
“supports_multibyte”: false,
“auto_increment”: false,
“is_primary_key”: false,
“is_foreign_key”: false,
“is_unique”: false,
“is_index”: false,
“ref_table”: null,
“ref_fields”: null,
“picklist”: null,
“validation”: null,
“alias”: null
},
{
“name”: “Test1”,
“label”: “Test1”,
“description”: null,
“type”: “string”,
“db_type”: “varchar(200)”,
“length”: 200,
“precision”: null,
“scale”: null,
“default”: null,
“required”: true,
“allow_null”: false,
“fixed_length”: false,
“supports_multibyte”: true,
“auto_increment”: false,
“is_primary_key”: false,
“is_foreign_key”: false,
“is_unique”: false,
“is_index”: false,
“ref_table”: null,
“ref_fields”: null,
“picklist”: null,
“validation”: null,
“alias”: null
},
{
“name”: “Test2”,
“label”: “Test2”,
“description”: null,
“type”: “text”,
“db_type”: “longtext”,
“length”: null,
“precision”: null,
“scale”: null,
“default”: null,
“required”: true,
“allow_null”: false,
“fixed_length”: false,
“supports_multibyte”: true,
“auto_increment”: false,
“is_primary_key”: false,
“is_foreign_key”: false,
“is_unique”: false,
“is_index”: false,
“ref_table”: null,
“ref_fields”: null,
“picklist”: null,
“validation”: null,
“alias”: null
},
{
“name”: “Test3”,
“label”: “Test3”,
“description”: null,
“type”: “text”,
“db_type”: “text”,
“length”: null,
“precision”: null,
“scale”: null,
“default”: null,
“required”: true,
“allow_null”: false,
“fixed_length”: false,
“supports_multibyte”: true,
“auto_increment”: false,
“is_primary_key”: false,
“is_foreign_key”: false,
“is_unique”: false,
“is_index”: false,
“ref_table”: null,
“ref_fields”: null,
“picklist”: null,
“validation”: null,
“alias”: null
}
],
“related”: [],
“primary_key”: null,
“name_field”: null,
“access”: 31
}