Hello from Germany,
I'm using modx since a while and never had big problems. Until now ...
When I use a TV of type "image" or "file" in a ressource, the ressource will load correct in the front end. But only the first time. After a reload of that ressource, NO chunks are loaded and of course the page looks broken then.
After clearing the cache, on the first load the ressource looks fine again ... after reload it is broken again. All the stuff with templates and snippets works fine, but no chunks are loaded when a TV of type "file" or "image" is filled on that ressource and ony after the first loading :/
When I use a TV of type text or leave the TV of type image or file empty, everything works fine. Strange, isn't it?
This error produces always the same entry in error.log:
(ERROR @ /index.php) Error 42S22 executing query: SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file`, `` FROM `modx_site_htmlsnippets` AS `modChunk` LEFT JOIN `modx_media_sources` `Source` ON `modChunk`.`source` = `Source`.`id` WHERE `modChunk`.`name` = ? ORDER BY `modChunk`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column '' in 'field list'
)
So it seems there is a problem with the SQL-Statement. Do you have an idea what the problem could be or where i can fix this SQL-Statement?
Best Greetings an thanks from germany,
Sebastian
[ed. note: elektrodampf last edited this post 14 years ago.]
