Forums

Wrong field type in table CollectionSearchIndexAttributes

Permalink
Hello,

i've created a custom attribute. The attribute stores a string value. The db.xml of my attribute looks like:

<?xml version="1.0" encoding="UTF-8"?>
<schema
        xmlns="http://www.concrete5.org/doctrine-xml/0.5"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.concrete5.org/doctrine-xml/0.5http://concrete5.github.io/doctrine-xml/doctrine-xml-0.5.xsd"...
        >
    <table name="atBreadcrumbLabel">
        <field name="avID" type="integer" size="10">
            <unsigned/>
            <key/>
            <default value="0"/>
        </field>
        <field name="value" type="string" size="255">
            <notnull/>
        </field>
Viewing 15 lines of 17 lines. View entire code block.


When the tool "reindex_pending_pages" is called in the background i've got the following error message in the developers toolbar:

INSERT INTO CollectionSearchIndexAttributes (cID, ak_meta_title, ak_meta_description, ak_header_extra_content, ak_exclude_sitemapxml, ak_breadcrumb_label) VALUES (?, ?, ?, ?, ?, ?)' with params ["232", "", "", "", "0", "TEst"]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'TEst' for column 'ak_breadcrumb_label' at row 1


A "show create table CollectionSearchIndexAttributes" tells me the field "ak_breadcrumb_label" is not a string but an integer ...

What I'm doing wrong? Is there a special function or property in the attribute controller I must overwrite/set?

Best,
Marcus
elpado