Catalog list item error

[Dmitry]

Hi!
I have found an error, connected with display catalog item list.

if you create a many catalog fields, with too long description, you will possibly see an empty list item (see img 1)

When you enable error reporting you will see:
Warning: Invalid argument supplied for foreach() in XXX\drivers\DC_Table.php on line 3749
Warning: Invalid argument supplied for foreach() in XXXX\drivers\DC_Table.php on line 3472
Warning: Invalid argument supplied for foreach() in XXXX\system\drivers\DC_Table.php on line 3135
Warning: vsprintf() [function.vsprintf]: Too few arguments in xxxx\system\drivers\DC_Table.php on line 3194
Warning: Invalid argument supplied for foreach() in xxxx\system\drivers\DC_Table.php on line 3135

that's because update SQL - UPDATE tl_catalog_types SET dca='a:5:{s:6:\"config\";a:5:{s:13:\"d ......... returned error, that data is too big to insert data into field type "text"

To resolve it - simply change data type from "text" to "long text" for "dca" field in tl_catalog_types


This problem reproduced in TYPOlight 2.7.3 and TYPOlight 2.8.1
catalog 0.3.6 stable
catalog_ext 0.8.9 stable

Thanks
p.s. Sorry for my English

[thyon]

You can upgrade to the new version 2.0 alpha, which doesn't store the dca in the database anymore, but calculates it dynamically, remove the need to "Regenerate DCA"