[SOLVED] FC 1.5.6 (r862) Bug if numbers in field typ text

Hi,

I use a field (filedtyp = text) to enter/show the postal code and the city.

if I enter just the city (like Freiburg) or only the postal code (like 79110) everything seems to be ok

But when i enter the postal code and the city (like 79110 Freiburg)

following error message appears

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'freiburg ORDER BY c.title, i.title, rel.ordering, i.ordering ASC' at line 1 SQL=SELECT i.id AS value, i.title AS text, i.*, i.catid AS icatid, c.access AS cataccess, c.id AS catid, c.published AS catpublished, c.title AS cattitle, c.parent_id AS parentcat, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jossbg_content AS i LEFT JOIN jossbg_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jossbg_categories AS c ON c.id = rel.catid WHERE i.id = 79110 freiburg ORDER BY c.title, i.title, rel.ordering, i.ordering ASC

is this a bug?

Regards

It should not happen no matter what you enter in the field.
This is a bug, i put on bug tracker not to forget, hope to fix soon. As this field is commonly used.

Regards

Thanks for reporting

ggppdk wrote: It should not happen no matter what you enter in the field.
This is a bug, i put on bug tracker not to forget, hope to fix soon. As this field is commonly used.
Regards

that's right
and so it would be really great
if that could be resolved quickly

Regards

I thought that it was strange that such an obvious bug escaped for so long.

There is no bug inside the Flexicontent CORE code.

The error you provided occurs inside 'selectitem' field, which is not a core Flexicontent field.

By the details you provided, i am guessing that for some reason the field 'selectitem' is called and passed the value of the 'text' field.

But this error can only happen:
-- if you removed (or changed) this line:
which is inside the onDisplayFieldValue() function of the 'selectitem' field (file selectitem.php located in folder: plugins/flexicontent_fields)?

Please, check the above mentioned line ...

Regards

thanks

i have tested it again (FC 1.5.6 svn 889) and the selectitem field
but I can no longer reproduce the error

but it doesnt matter
i use no longer the selectitem field

your relateditems field and the SelectFlexiItem filed from yopyop001 are much better

www.flexicontent.org/forum/index.php?f=3...v=viewtopic&start=30

great work :!:

Regards