3: Error writing file '/var/log/mysq.log' (Errcode: 28) Dotaz: SELECT
DataObjects.id,
DataObjects.type,
DataObjects.identifier,
Blocks.id AS bid,
Blocks.identifier AS block_identifier
,textarea_table.data AS textarea_data
,textarea_table.id AS textarea_id
,h_textarea_table.data AS h_textarea_data
,h_textarea_table.id AS h_textarea_id
,text_table.data AS text_data
,text_table.id AS text_id
,h_text_table.data AS h_text_data
,h_text_table.id AS h_text_id
,wysiwyg_table.data AS wysiwyg_data
,wysiwyg_table.id AS wysiwyg_id
,h_wysiwyg_table.data AS h_wysiwyg_data
,h_wysiwyg_table.id AS h_wysiwyg_id
,include_table.data AS include_data
,include_table.id AS include_id
,link_table.data AS link_data
,link_table.id AS link_id
,h_link_table.data AS h_link_data
,h_link_table.id AS h_link_id
,survey_table.data AS survey_data
,survey_table.id AS survey_id
,news_table.data AS news_data
,news_table.id AS news_id
,file_table.data AS file_data
,file_table.id AS file_id
,h_file_table.data AS h_file_data
,h_file_table.id AS h_file_id
,h_fileinfo_table.data AS h_fileinfo_data
,h_fileinfo_table.id AS h_fileinfo_id
,structure_tree_table.data AS structure_tree_data
,structure_tree_table.id AS structure_tree_id
,map_tree_table.data AS map_tree_data
,map_tree_table.id AS map_tree_id
,articles_table.data AS articles_data
,articles_table.id AS articles_id
,forum_table.data AS forum_data
,forum_table.id AS forum_id
,forum_category_table.data AS forum_category_data
,forum_category_table.id AS forum_category_id
,switch_table.data AS switch_data
,switch_table.id AS switch_id
,gallery_link_table.data AS gallery_link_data
,gallery_link_table.id AS gallery_link_id
,gallery_pict_table.data AS gallery_pict_data
,gallery_pict_table.id AS gallery_pict_id
,gallery_file_table.data AS gallery_file_data
,gallery_file_table.id AS gallery_file_id
,prodcatalogue_table.data AS prodcatalogue_data
,prodcatalogue_table.id AS prodcatalogue_id
,enum_table.data AS enum_data
,enum_table.id AS enum_id
,banner_table.data AS banner_data
,banner_table.id AS banner_id
,datetime_table.data AS datetime_data
,datetime_table.id AS datetime_id
,quiz_table.data AS quiz_data
,quiz_table.id AS quiz_id
,faq_table.data AS faq_data
,faq_table.id AS faq_id
FROM `mcms_structure_data_objects` AS DataObjects
LEFT JOIN `mcms_structure_blocks` AS Blocks
ON Blocks.id=DataObjects.id_block
LEFT JOIN `mcms_structure_data_object_textareas` AS textarea_table
ON DataObjects.id=textarea_table.id_data_object
LEFT JOIN `mcms_structure_data_object_textareas` AS h_textarea_table
ON DataObjects.id=h_textarea_table.id_data_object
LEFT JOIN `mcms_structure_data_object_texts` AS text_table
ON DataObjects.id=text_table.id_data_object
LEFT JOIN `mcms_structure_data_object_texts` AS h_text_table
ON DataObjects.id=h_text_table.id_data_object
LEFT JOIN `mcms_structure_data_object_wysiwygs` AS wysiwyg_table
ON DataObjects.id=wysiwyg_table.id_data_object
LEFT JOIN `mcms_structure_data_object_wysiwygs` AS h_wysiwyg_table
ON DataObjects.id=h_wysiwyg_table.id_data_object
LEFT JOIN `mcms_structure_data_object_includes` AS include_table
ON DataObjects.id=include_table.id_data_object
LEFT JOIN `mcms_structure_data_object_links` AS link_table
ON DataObjects.id=link_table.id_data_object
LEFT JOIN `mcms_structure_data_object_links` AS h_link_table
ON DataObjects.id=h_link_table.id_data_object
LEFT JOIN `mcms_structure_data_object_surveys` AS survey_table
ON DataObjects.id=survey_table.id_data_object
LEFT JOIN `mcms_structure_data_object_news` AS news_table
ON DataObjects.id=news_table.id_data_object
LEFT JOIN `mcms_structure_data_object_files` AS file_table
ON DataObjects.id=file_table.id_data_object
LEFT JOIN `mcms_structure_data_object_files` AS h_file_table
ON DataObjects.id=h_file_table.id_data_object
LEFT JOIN `mcms_structure_data_object_files` AS h_fileinfo_table
ON DataObjects.id=h_fileinfo_table.id_data_object
LEFT JOIN `mcms_structure_data_object_tree` AS structure_tree_table
ON DataObjects.id=structure_tree_table.id_data_object
LEFT JOIN `mcms_structure_data_object_tree` AS map_tree_table
ON DataObjects.id=map_tree_table.id_data_object
LEFT JOIN `mcms_structure_data_object_articles` AS articles_table
ON DataObjects.id=articles_table.id_data_object
LEFT JOIN `mcms_structure_data_object_forum` AS forum_table
ON DataObjects.id=forum_table.id_data_object
LEFT JOIN `mcms_structure_data_object_forum_category` AS forum_category_table
ON DataObjects.id=forum_category_table.id_data_object
LEFT JOIN `mcms_structure_data_object_switches` AS switch_table
ON DataObjects.id=switch_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS gallery_link_table
ON DataObjects.id=gallery_link_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS gallery_pict_table
ON DataObjects.id=gallery_pict_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS gallery_file_table
ON DataObjects.id=gallery_file_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS prodcatalogue_table
ON DataObjects.id=prodcatalogue_table.id_data_object
LEFT JOIN `mcms_structure_data_object_varchar255` AS enum_table
ON DataObjects.id=enum_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS banner_table
ON DataObjects.id=banner_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS datetime_table
ON DataObjects.id=datetime_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS quiz_table
ON DataObjects.id=quiz_table.id_data_object
LEFT JOIN `mcms_structure_data_object_int11` AS faq_table
ON DataObjects.id=faq_table.id_data_object
WHERE
id_version=14
GROUP BY
Blocks.identifier, DataObjects.type, DataObjects.identifier