/ Всі дати
2017 2018 2019 2020
спільні мрії»
Конкурс есе для студентів «Дивимось у майбутнє: спільні цінності

Новини
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='ukr'
              AND news.last_change_date < '2023-02-05 06:52:02' AND ( news.expiration_date is null OR  '2023-02-05 06:52:02'< news.expiration_date)
              
              
              
              
             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.0000360480{main}( ).../index.php:0
20.0026602328run( ).../index.php:82
30.0026605768include( '/var/www/cms/scripts/news/view.php' ).../functions.php:34
40.0141888088process_template( ).../view.php:142
50.0142895200Smarty->fetch( ).../page_view_functions.php:106
60.0220992880include( '/var/www/cms/cache/%%C4^C44^C44E32C5%%template_news_view_list2.html.php' ).../Smarty.class.php:1270
70.02591004912CmsNewsViewer->__get( ).../%%C4^C44^C44E32C5%%template_news_view_list2.html.php:129
80.02591004912CmsNewsViewer->createNewsList( ).../get_public_list4.php:236
90.02871018736e::db_getrows( ).../get_public_list4.php:1020
100.02871019112e::__callStatic( ).../get_public_list4.php:1020
110.02871019112db->db_getrows( ).../core.php:69