Soutěže
VytisknoutDolo k chybě dne 20.05.2013 v 04:07:52
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=52 GROUP BY Blocks.identifier, DataObjects.type, DataObjects.identifier
