Новини
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 < '2024-10-03 13:07:22' AND ( news.expiration_date is null OR '2024-10-03 13:07:22'< news.expiration_date)
AND news.last_change_date BETWEEN '2019-01-01 00:00:01' AND '2019-01-31 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 |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0000 | 361488 | {main}( ) | .../index.php:0 |
| 2 | 0.0027 | 603336 | run( ) | .../index.php:82 |
| 3 | 0.0028 | 606776 | include( '/var/www/cms/scripts/news/view.php' ) | .../functions.php:34 |
| 4 | 0.0135 | 889864 | process_template( ) | .../view.php:142 |
| 5 | 0.0135 | 896976 | Smarty->fetch( ) | .../page_view_functions.php:106 |
| 6 | 0.0200 | 994728 | include( '/var/www/cms/cache/%%C4^C44^C44E32C5%%template_news_view_list2.html.php' ) | .../Smarty.class.php:1270 |
| 7 | 0.0638 | 1007296 | CmsNewsViewer->__get( ) | .../%%C4^C44^C44E32C5%%template_news_view_list2.html.php:129 |
| 8 | 0.0638 | 1007296 | CmsNewsViewer->createNewsList( ) | .../get_public_list4.php:236 |
| 9 | 0.0670 | 1021744 | e::db_getrows( ) | .../get_public_list4.php:1020 |
| 10 | 0.0670 | 1022120 | e::__callStatic( ) | .../get_public_list4.php:1020 |
| 11 | 0.0670 | 1022120 | db->db_getrows( ) | .../core.php:69 |