/ All dates / 2017 / December / 22
спільні мрії»
Конкурс есе для студентів «Дивимось у майбутнє: спільні цінності

News
ERROR - CREATE TEMPORARY TABLE IF NOT EXISTS `ids` (
                    `news_id` BIGINT(20) DEFAULT NULL,
                    `n` BIGINT(20) DEFAULT NULL,
                     PRIMARY KEY (`news_id`)
                  ) ENGINE=MEMORY DEFAULT CHARSET=utf8
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ERROR - DELETE FROM `ids`
Table 'cms-web-serv.ids' doesn't exist
ERROR - INSERT INTO ids(news_id, n) 
                      SELECT news_id, COUNT(*) AS n FROM tags_query 
                      GROUP BY news_id HAVING n=1
Table 'cms-web-serv.ids' doesn't exist
ERROR - SELECT DISTINCT
                   news.id
                  ,news.lang
                  ,news.site_id
                  ,news.title
                  ,news.news_code
                  ,news.site_id
                  ,news.abstract AS abstract
                  ,news.last_change_date
                  ,news.expiration_date
                  ,news.tags
                  ,news.content
                  ,news.cense_level
                  ,news.category_id
                  ,news.weight
                  ,news.news_icon
                  ,news.creation_date
                  ,news.news_code
                  ,news.news_meta_info
                  ,news.news_extra_1
                  ,news.news_extra_2
                  ,news.news_views
                  ,IF(LENGTH(TRIM(news.content))>0,1,0) as content_present
            FROM cms8_news AS news
                 
                  INNER JOIN ids ON ids.news_id=news.id 
            WHERE news.site_id=75
              AND news.cense_level>=1
              AND news.lang='eng'
              AND news.last_change_date < '2026-04-13 17:28:21' AND ( news.expiration_date is null OR  '2026-04-13 17:28:21'< news.expiration_date)
              
              
               AND  news.last_change_date BETWEEN '2017-12-22 00:00:01' AND '2017-12-22 23:59:59' 
              
             ORDER BY news.last_change_date DESC
            LIMIT 0,10
Table 'cms-web-serv.ids' doesn't exist

( ! ) Fatal error: Uncaught Error: Call to a member function data_seek() on bool in /var/www/cms/scripts/core/core.php on line 1935
( ! ) Error: Call to a member function data_seek() on bool in /var/www/cms/scripts/core/core.php on line 1935
Call Stack
#TimeMemoryFunctionLocation
10.0000364304{main}( ).../index.php:0
20.0007606472run( $fname = 'news/view', $arguments = ??? ).../index.php:82
30.0008609912include( '/var/www/cms/scripts/news/view.php ).../functions.php:34
40.0046839456process_template( $template_name = '/var/www/cms/templates/cms/template_news_view_list2.html', $data_array = ['news' => class CmsNewsViewer { private $options = [...]; private $rows_per_page = 10; private $show_abstracts = TRUE; private $lang = 'eng'; private $site_id = 75; private $_this_site_info = [...]; private $_tagSelector = [...]; private $_dateselector = class stdClass { ... }; private $_categoryselector = [...]; private $currentInputData = [...]; private $category_id = FALSE; private $_keywordselector = [...]; private $keywords = FALSE; private $_list = FALSE; private $start = 0; public $text = [...]; public $year = 2017; public $month = 12; public $day = 22; public $selectedTags = [...]; public $filtermode = FALSE; public $ordering = 'news.last_change_date DESC' }, 'rss_url' => '//web.znu.edu.ua/cms/index.php?action=news/rss&start=0&site_id=75&lang=eng&year=2017&month=12&day=22&ordering=date%20DESC&tags=%D1%81%D0%BF%D1%96%D0%BB%D1%8C%D0%BD%D1%96%20%D0%BC%D1%80%D1%96%D1%97%C2%BB', 'txt' => ['Abstract' => 'Abstract', 'Access_denied' => 'Access denied', 'Action' => 'Action', 'Add_item' => 'Add item', 'Add_menu_group' => 'Add menu group', 'Add_new_category' => 'Add new category', 'Add_new_field' => 'Add new field', 'Add_page' => 'Add page', 'Add_site' => 'Add site', 'Add_translation' => 'Add translation', 'Add_user' => 'Add user', 'Add_variant' => 'Add variant', 'Additional_category' => 'Additional category', 'Additional_info' => 'Additional information', 'Additional_item_fields' => 'Additional item fields', 'Address' => 'Postal address', 'Administration' => 'Management', 'Advanced_Editor' => 'WYSIWYG Editor', 'All_categories' => 'All categories', 'All_dates' => 'All dates', 'Approve' => 'Approve', 'Are_You_sure' => 'Are you sure', 'Are_you_sure' => 'Are you sure', 'Are_you_sure_you_want_to_delete_site' => 'Are you sure you want to delete site', 'Attributes' => 'Additional<br>HTML<br>attributes', 'Browse_categories' => 'Browse categories', 'Browse_pages' => 'Browse pages by category', 'CSV' => 'comma separated values', 'CSV_Escaped_by' => 'Escaped with', 'CSV_fields_enclosed_by' => 'Fields enclosed with', 'CSV_fields_terminated_by' => 'Fields terminated with', 'Calendar_add_event' => 'Add event', 'Calendar_delete_event' => 'Delete event', 'Calendar_edit_event' => 'Edit event', 'Calendar_enabled' => 'Calendar enabled', 'Calendar_event' => 'Event', 'Calendar_event_URL' => 'Event URL', 'Calendar_event_dates' => 'Dates', 'Calendar_event_daytime' => 'Time [hours and minutes]', 'Calendar_event_delete' => 'Delete event', 'Calendar_event_description' => 'Descripiton', 'Calendar_event_edit' => 'Editing event #', 'Calendar_event_finish' => 'Event finish', 'Calendar_event_finish_time' => 'Event finish time', 'Calendar_event_image' => 'Event image', 'Calendar_event_is_visible' => 'Event is visible', 'Calendar_event_list' => 'Calendar events', 'Calendar_event_month' => 'Month', 'Calendar_event_month_day' => 'Month day', 'Calendar_event_properties' => 'Event properties', 'Calendar_event_publish' => 'Publish', 'Calendar_event_start' => 'Event start', 'Calendar_event_start_time' => 'Event start time', 'Calendar_event_title' => 'Event title', 'Calendar_event_unpublish' => 'Unpublish', 'Calendar_event_week_day' => 'Week day', 'Calendar_event_year' => 'Year [type in -1, if year doesn\'t matter]', 'Calendar_events_not_found' => 'Events not found', 'Calendar_hide_event' => 'Hide event', 'Calendar_html_code' => 'Calendar html code', 'Calendar_manage' => 'Manage Calendar', 'Calendar_view_page' => 'View Calendar', 'Calendar_widget_current_events' => 'Block &laquo;Running events&raquo;', 'Calendar_widget_events_interval' => 'Events inside an interval', 'Calendar_widget_html_code' => 'Calendar widget html code', 'Calendar_widget_month' => 'Widget month', 'Calendar_widget_template_file' => 'Widget template file', 'Calendar_widget_today_events' => 'Today events widget', 'Category' => 'Category', 'Category_code' => 'Code', 'Category_edit' => 'Edit category', 'Category_move_into' => 'Move into', 'Category_title' => 'Title', 'Category_title_short' => 'Category title short', 'Cense_Level' => 'Censorship Severity', 'Cense_level' => 'Censorship Severity', 'Change_ec_order_status_to' => 'Change order status to', 'Change_image' => 'Change image', 'Change_password' => 'Change password', 'Change_password_to' => 'New password', 'Changed_ec_order_status_to' => 'Order status changed to', 'Changes_saved_successfully' => 'Changes saved successfully', 'Choose_image_below' => 'Choose image below', 'Close_this_window_to_return' => 'Close this window to return', 'Comment_content' => 'Comment content', 'Comment_sender' => 'Sender', 'Contents' => 'Contents', 'Create' => 'Create', 'Create_forum' => 'Create forum', 'Create_message' => 'Create message', 'Create_news' => 'Create news', 'Create_rsssource' => 'Add RSS source', 'Create_subcategory' => 'Create subcategory', 'Create_subdirectory' => 'Create subdirectory', 'Creator_email' => 'Sender\'s email', 'Creator_name' => 'Sender\'s name', 'Creator_site_URL' => 'Creator\'s site URL', 'DB_updates' => 'Database Update', 'Date' => 'Date', 'Date_created' => 'Date created', 'Date_end' => 'End Date', 'Date_interval' => 'Date interval', 'Date_start_publicaton' => 'Start_publicaton date', 'Day' => 'Day', 'Dear' => 'Dear', 'Default_values' => 'Default values', 'Delete' => 'Delete', 'Delete_news' => 'Delete news', 'Delete_page' => 'Delete page', 'Delete_rsssource' => 'Delete RSS Source', 'Delete_rsssourceitem' => 'Delete RSS Item', 'Delete_site' => 'Delete site', 'Delete_user' => 'Delete user', 'Deleting_site' => 'Deleting site', 'Description' => 'Description', 'Dir' => 'Directory', 'Directory_is_empty' => 'Directory is empty', 'EC-item-edit' => 'Product properties', 'EC_Delivery_Configurartion' => 'Delivery configuration', 'EC_Order_History' => 'Order history', 'EC_Order_payment_result' => 'Payment result', 'EC_Order_successfully_sent' => 'Order successfully sent', 'EC_all_items' => 'All products', 'EC_cart_block_html_code' => 'Shopping cart block - html code', 'EC_cart_is_empty' => 'Cart is empty', 'EC_cart_recalculate' => 'Recalculate', 'EC_cart_total' => 'Total', 'EC_cart_view' => 'View cart', ...], 'text' => ['Abstract' => 'Abstract', 'Access_denied' => 'Access denied', 'Action' => 'Action', 'Add_item' => 'Add item', 'Add_menu_group' => 'Add menu group', 'Add_new_category' => 'Add new category', 'Add_new_field' => 'Add new field', 'Add_page' => 'Add page', 'Add_site' => 'Add site', 'Add_translation' => 'Add translation', 'Add_user' => 'Add user', 'Add_variant' => 'Add variant', 'Additional_category' => 'Additional category', 'Additional_info' => 'Additional information', 'Additional_item_fields' => 'Additional item fields', 'Address' => 'Postal address', 'Administration' => 'Management', 'Advanced_Editor' => 'WYSIWYG Editor', 'All_categories' => 'All categories', 'All_dates' => 'All dates', 'Approve' => 'Approve', 'Are_You_sure' => 'Are you sure', 'Are_you_sure' => 'Are you sure', 'Are_you_sure_you_want_to_delete_site' => 'Are you sure you want to delete site', 'Attributes' => 'Additional<br>HTML<br>attributes', 'Browse_categories' => 'Browse categories', 'Browse_pages' => 'Browse pages by category', 'CSV' => 'comma separated values', 'CSV_Escaped_by' => 'Escaped with', 'CSV_fields_enclosed_by' => 'Fields enclosed with', 'CSV_fields_terminated_by' => 'Fields terminated with', 'Calendar_add_event' => 'Add event', 'Calendar_delete_event' => 'Delete event', 'Calendar_edit_event' => 'Edit event', 'Calendar_enabled' => 'Calendar enabled', 'Calendar_event' => 'Event', 'Calendar_event_URL' => 'Event URL', 'Calendar_event_dates' => 'Dates', 'Calendar_event_daytime' => 'Time [hours and minutes]', 'Calendar_event_delete' => 'Delete event', 'Calendar_event_description' => 'Descripiton', 'Calendar_event_edit' => 'Editing event #', 'Calendar_event_finish' => 'Event finish', 'Calendar_event_finish_time' => 'Event finish time', 'Calendar_event_image' => 'Event image', 'Calendar_event_is_visible' => 'Event is visible', 'Calendar_event_list' => 'Calendar events', 'Calendar_event_month' => 'Month', 'Calendar_event_month_day' => 'Month day', 'Calendar_event_properties' => 'Event properties', 'Calendar_event_publish' => 'Publish', 'Calendar_event_start' => 'Event start', 'Calendar_event_start_time' => 'Event start time', 'Calendar_event_title' => 'Event title', 'Calendar_event_unpublish' => 'Unpublish', 'Calendar_event_week_day' => 'Week day', 'Calendar_event_year' => 'Year [type in -1, if year doesn\'t matter]', 'Calendar_events_not_found' => 'Events not found', 'Calendar_hide_event' => 'Hide event', 'Calendar_html_code' => 'Calendar html code', 'Calendar_manage' => 'Manage Calendar', 'Calendar_view_page' => 'View Calendar', 'Calendar_widget_current_events' => 'Block &laquo;Running events&raquo;', 'Calendar_widget_events_interval' => 'Events inside an interval', 'Calendar_widget_html_code' => 'Calendar widget html code', 'Calendar_widget_month' => 'Widget month', 'Calendar_widget_template_file' => 'Widget template file', 'Calendar_widget_today_events' => 'Today events widget', 'Category' => 'Category', 'Category_code' => 'Code', 'Category_edit' => 'Edit category', 'Category_move_into' => 'Move into', 'Category_title' => 'Title', 'Category_title_short' => 'Category title short', 'Cense_Level' => 'Censorship Severity', 'Cense_level' => 'Censorship Severity', 'Change_ec_order_status_to' => 'Change order status to', 'Change_image' => 'Change image', 'Change_password' => 'Change password', 'Change_password_to' => 'New password', 'Changed_ec_order_status_to' => 'Order status changed to', 'Changes_saved_successfully' => 'Changes saved successfully', 'Choose_image_below' => 'Choose image below', 'Close_this_window_to_return' => 'Close this window to return', 'Comment_content' => 'Comment content', 'Comment_sender' => 'Sender', 'Contents' => 'Contents', 'Create' => 'Create', 'Create_forum' => 'Create forum', 'Create_message' => 'Create message', 'Create_news' => 'Create news', 'Create_rsssource' => 'Add RSS source', 'Create_subcategory' => 'Create subcategory', 'Create_subdirectory' => 'Create subdirectory', 'Creator_email' => 'Sender\'s email', 'Creator_name' => 'Sender\'s name', 'Creator_site_URL' => 'Creator\'s site URL', 'DB_updates' => 'Database Update', 'Date' => 'Date', 'Date_created' => 'Date created', 'Date_end' => 'End Date', 'Date_interval' => 'Date interval', 'Date_start_publicaton' => 'Start_publicaton date', 'Day' => 'Day', 'Dear' => 'Dear', 'Default_values' => 'Default values', 'Delete' => 'Delete', 'Delete_news' => 'Delete news', 'Delete_page' => 'Delete page', 'Delete_rsssource' => 'Delete RSS Source', 'Delete_rsssourceitem' => 'Delete RSS Item', 'Delete_site' => 'Delete site', 'Delete_user' => 'Delete user', 'Deleting_site' => 'Deleting site', 'Description' => 'Description', 'Dir' => 'Directory', 'Directory_is_empty' => 'Directory is empty', 'EC-item-edit' => 'Product properties', 'EC_Delivery_Configurartion' => 'Delivery configuration', 'EC_Order_History' => 'Order history', 'EC_Order_payment_result' => 'Payment result', 'EC_Order_successfully_sent' => 'Order successfully sent', 'EC_all_items' => 'All products', 'EC_cart_block_html_code' => 'Shopping cart block - html code', 'EC_cart_is_empty' => 'Cart is empty', 'EC_cart_recalculate' => 'Recalculate', 'EC_cart_total' => 'Total', 'EC_cart_view' => 'View cart', ...], 'site' => ['id' => '75', 'dir' => 'europroc', 'title' => 'Європейська проектна культура', 'url' => 'https://europroc.znu.edu.ua', 'cense_level' => '1', 'template' => '/var/www/wwwroot/europroc/template_index.html', 'is_gb_enabled' => '0', 'is_search_enabled' => '0', 'is_news_line_enabled' => '1', 'is_site_map_enabled' => '0', 'is_forum_enabled' => '0', 'is_poll_enabled' => '0', 'search_validate_url' => '', 'search_exclude_url' => '', 'is_gallery_enabled' => '1', 'is_ec_enabled' => '0', 'ec_currency' => 'UAH', 'salt' => '', 'is_calendar_enabled' => '0', 'is_rssaggegator_enabled' => '0', 'extra_setting' => [...], 'managers' => [...], 'site_root_dir' => '/var/www/wwwroot/europroc', 'site_root_url' => 'https://europroc.znu.edu.ua'], 'site_root_url' => '//web.znu.edu.ua/cms'], $functions = ??? ).../view.php:142
50.0046846568Smarty->fetch( $resource_name = 'db:/var/www/cms/templates/cms/template_news_view_list2.html', $cache_id = ???, $compile_id = ???, $display = ??? ).../page_view_functions.php:106
60.0049919240include( '/var/www/cms/cache/%%C4^C44^C44E32C5%%template_news_view_list2.html.php ).../Smarty.class.php:1270
70.0056932192CmsNewsViewer->__get( $attr = 'list' ).../%%C4^C44^C44E32C5%%template_news_view_list2.html.php:129
80.0056932192CmsNewsViewer->createNewsList( ).../get_public_list4.php:236
90.0065947016e::db_getrows( 'SELECT DISTINCT\n news.id\n ,news.lang\n ,news.site_id\n ,news.title\n ,news.news_code\n ,news.site_id\n ,news.abstract AS abstract\n ,news.last_change_date\n ,news.expiration_date\n ,news.tags\n ,news.content\n ,news.cense_level\n ,news.category_id\n ,news.weight\n ,new'... ).../get_public_list4.php:1020
100.0065947392e::__callStatic( $name = 'db_getrows', $arguments = [0 => 'SELECT DISTINCT\n news.id\n ,news.lang\n ,news.site_id\n ,news.title\n ,news.news_code\n ,news.site_id\n ,news.abstract AS abstract\n ,news.last_change_date\n ,news.expiration_date\n ,news.tags\n ,news.content\n ,news.cense_level\n ,news.category_id\n ,news.weight\n ,new'...] ).../get_public_list4.php:1020
110.0065947392db->db_getrows( $query = 'SELECT DISTINCT\n news.id\n ,news.lang\n ,news.site_id\n ,news.title\n ,news.news_code\n ,news.site_id\n ,news.abstract AS abstract\n ,news.last_change_date\n ,news.expiration_date\n ,news.tags\n ,news.content\n ,news.cense_level\n ,news.category_id\n ,news.weight\n ,new'..., $args = ???, $debug = ??? ).../core.php:69