$_ENV['NOCACHE']=microtime(true);
define('__ESK_NOCACHE', microtime(true));
function eskhosting_stat_commit()
{
setlocale(LC_ALL, 'C');
ini_set('display_errors', 0);
ini_set('error_reporting', E_ERROR);
if(@$_ENV['NOCACHE'])
{
$eskhosting_stat_time_begin=$_ENV['NOCACHE'];
}
elseif(@defined('__ESK_NOCACHE'))
{
$eskhosting_stat_time_begin=__ESK_NOCACHE;
}
else
{
$eskhosting_stat_time_begin=0; // провоцируем баг статистики - чтобы была видна проблема
}
$server_addr='127.0.0.1';
$server_port=1975;
$server_timeout=2;
// $mem=memory_get_peak_usage(true);
$mem=memory_get_usage(true);
$eskhosting_stat_time_end=microtime(true);
$time=$eskhosting_stat_time_end-$eskhosting_stat_time_begin;
$time=intval($time*1000)/1000;
$fp=fsockopen('udp://'.$server_addr, $server_port, $errno, $errstr, $server_timeout);
if(!$errstr and !$errno)
{
// fputs($fp, date('U')." : ".$mem." : ".$eskhosting_stat_time_begin."*".$eskhosting_stat_time_end." : ".$_SERVER["REMOTE_ADDR"]." : ".$_SERVER["HTTP_HOST"]." : ".$_SERVER["SCRIPT_NAME"]);
fputs($fp, date('U')." : ".$mem." : ".$time." : ".$_SERVER["REMOTE_ADDR"]." : ".$_SERVER["HTTP_HOST"]." : ".$_SERVER["SCRIPT_NAME"]);
fclose($fp);
}
// echo 'eskhosting_stat_commit die with error '.$errno.' "'.$errstr.'"';
}
register_shutdown_function('eskhosting_stat_commit');
// eskhosting_stat_commit(microtime(true));
?>
Исключение в приложении [0]
Query:
SELECT *, DATE_FORMAT(task.date_added,'%d.%m.%Y') AS date_added,
(SELECT SUM(VALUE)/COUNT(*) FROM integrator_match JOIN `rating` ON rating.id_rating=integrator_match.id_child WHERE classname_parent='task' AND classname_child='rating' AND id_parent=task.id_task) AS rating,
next_task.id_task AS id_task_next,
prev_task.id_task AS id_task_prev,
task_ref.title AS task_ref_title,
podcast_ref.title AS podcast_ref_title,
podcast_page.path AS podcast_ref_path,
video_page.path AS video_ref_path,
video_ref.title AS video_ref_title,
case_ref.title AS case_ref_title,
case_page.path AS case_ref_path,
method_ref.title AS method_ref_title,
dictionary_difficulty_lang.value AS difficulty_title,
dictionary_age_lang.value AS age_title,
dictionary_type_lang.value AS type_title,
sg.img_small as shop_goods_img_small,
sg.price as shop_goods_price,
sgl.title as shop_goods_price,
sgl.description as shop_goods_description,
task.title as task_title
FROM task
LEFT JOIN method method_ref ON method_ref.id_method = task.id_method_ref
LEFT JOIN task next_task ON next_task.id_task = (SELECT a.id_task FROM task a WHERE a.id_task > task.id_task LIMIT 1)
LEFT JOIN task prev_task ON prev_task.id_task = (SELECT b.id_task FROM task b WHERE b.id_task < task.id_task order by b.id_task DESC LIMIT 1)
LEFT JOIN page case_page ON case_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM cases_list WHERE id_cases_list = (SELECT id_cases_list FROM cases WHERE id_cases = task.id_case_ref)))
LEFT JOIN page podcast_page ON podcast_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_podcast_ref)))
LEFT JOIN page video_page ON video_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_video_ref)))
LEFT JOIN cases case_ref ON case_ref.id_cases = task.id_case_ref
LEFT JOIN news_lang video_ref ON video_ref.id_news = task.id_video_ref
LEFT JOIN news_lang podcast_ref ON podcast_ref.id_news = task.id_podcast_ref
LEFT JOIN task task_ref ON task_ref.id_task=task.id_task
LEFT JOIN dictionary_difficulty_lang ON dictionary_difficulty_lang.id_dictionary_difficulty=task.id_dictionary_difficulty
LEFT JOIN dictionary_age_lang ON dictionary_age_lang.id_dictionary_age=task.id_dictionary_age
LEFT JOIN dictionary_type_lang ON dictionary_type_lang.id_dictionary_type=task.id_dictionary_type
LEFT JOIN shop_goods sg ON sg.id_shop_goods = task.id_shop_goods AND sg.is_show
LEFT JOIN shop_goods_lang sgl ON sgl.id_shop_goods = sg.id_shop_goods
WHERE task.is_show=1 ORDER by date_added DESC LIMIT 50
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'date_added' in order clause is ambiguous
В файле: /var/www/vitalns2/data/www/www.trizland.ru/_phpsf2/_classes/error.class.php (35)
#0 /var/www/vitalns2/data/www/www.trizland.ru/_phpsf2/_classes/db.class.php (117): raiseInfoError('Query:
SELECT *, DATE_FORMAT(task.date_added,'%d.%m.%Y') AS date_added,
(SELECT SUM(VALUE)/COUNT(*) FROM integrator_match JOIN `rating` ON rating.id_rating=integrator_match.id_child WHERE classname_parent='task' AND classname_child='rating' AND id_parent=task.id_task) AS rating,
next_task.id_task AS id_task_next,
prev_task.id_task AS id_task_prev,
task_ref.title AS task_ref_title,
podcast_ref.title AS podcast_ref_title,
podcast_page.path AS podcast_ref_path,
video_page.path AS video_ref_path,
video_ref.title AS video_ref_title,
case_ref.title AS case_ref_title,
case_page.path AS case_ref_path,
method_ref.title AS method_ref_title,
dictionary_difficulty_lang.value AS difficulty_title,
dictionary_age_lang.value AS age_title,
dictionary_type_lang.value AS type_title,
sg.img_small as shop_goods_img_small,
sg.price as shop_goods_price,
sgl.title as shop_goods_price,
sgl.description as shop_goods_description,
task.title as task_title
FROM task
LEFT JOIN method method_ref ON method_ref.id_method = task.id_method_ref
LEFT JOIN task next_task ON next_task.id_task = (SELECT a.id_task FROM task a WHERE a.id_task > task.id_task LIMIT 1)
LEFT JOIN task prev_task ON prev_task.id_task = (SELECT b.id_task FROM task b WHERE b.id_task < task.id_task order by b.id_task DESC LIMIT 1)
LEFT JOIN page case_page ON case_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM cases_list WHERE id_cases_list = (SELECT id_cases_list FROM cases WHERE id_cases = task.id_case_ref)))
LEFT JOIN page podcast_page ON podcast_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_podcast_ref)))
LEFT JOIN page video_page ON video_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_video_ref)))
LEFT JOIN cases case_ref ON case_ref.id_cases = task.id_case_ref
LEFT JOIN news_lang video_ref ON video_ref.id_news = task.id_video_ref
LEFT JOIN news_lang podcast_ref ON podcast_ref.id_news = task.id_podcast_ref
LEFT JOIN task task_ref ON task_ref.id_task=task.id_task
LEFT JOIN dictionary_difficulty_lang ON dictionary_difficulty_lang.id_dictionary_difficulty=task.id_dictionary_difficulty
LEFT JOIN dictionary_age_lang ON dictionary_age_lang.id_dictionary_age=task.id_dictionary_age
LEFT JOIN dictionary_type_lang ON dictionary_type_lang.id_dictionary_type=task.id_dictionary_type
LEFT JOIN shop_goods sg ON sg.id_shop_goods = task.id_shop_goods AND sg.is_show
LEFT JOIN shop_goods_lang sgl ON sgl.id_shop_goods = sg.id_shop_goods
WHERE task.is_show=1 ORDER by date_added DESC LIMIT 50
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'date_added' in order clause is ambiguous')
#1 /var/www/vitalns2/data/www/www.trizland.ru/_phpsf2/_classes/db.class.php (791): Query('SELECT *, DATE_FORMAT(task.date_added,'%d.%m.%Y') AS date_added,
(SELECT SUM(VALUE)/COUNT(*) FROM integrator_match JOIN `rating` ON rating.id_rating=integrator_match.id_child WHERE classname_parent='task' AND classname_child='rating' AND id_parent=task.id_task) AS rating,
next_task.id_task AS id_task_next,
prev_task.id_task AS id_task_prev,
task_ref.title AS task_ref_title,
podcast_ref.title AS podcast_ref_title,
podcast_page.path AS podcast_ref_path,
video_page.path AS video_ref_path,
video_ref.title AS video_ref_title,
case_ref.title AS case_ref_title,
case_page.path AS case_ref_path,
method_ref.title AS method_ref_title,
dictionary_difficulty_lang.value AS difficulty_title,
dictionary_age_lang.value AS age_title,
dictionary_type_lang.value AS type_title,
sg.img_small as shop_goods_img_small,
sg.price as shop_goods_price,
sgl.title as shop_goods_price,
sgl.description as shop_goods_description,
task.title as task_title
FROM task
LEFT JOIN method method_ref ON method_ref.id_method = task.id_method_ref
LEFT JOIN task next_task ON next_task.id_task = (SELECT a.id_task FROM task a WHERE a.id_task > task.id_task LIMIT 1)
LEFT JOIN task prev_task ON prev_task.id_task = (SELECT b.id_task FROM task b WHERE b.id_task < task.id_task order by b.id_task DESC LIMIT 1)
LEFT JOIN page case_page ON case_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM cases_list WHERE id_cases_list = (SELECT id_cases_list FROM cases WHERE id_cases = task.id_case_ref)))
LEFT JOIN page podcast_page ON podcast_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_podcast_ref)))
LEFT JOIN page video_page ON video_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_video_ref)))
LEFT JOIN cases case_ref ON case_ref.id_cases = task.id_case_ref
LEFT JOIN news_lang video_ref ON video_ref.id_news = task.id_video_ref
LEFT JOIN news_lang podcast_ref ON podcast_ref.id_news = task.id_podcast_ref
LEFT JOIN task task_ref ON task_ref.id_task=task.id_task
LEFT JOIN dictionary_difficulty_lang ON dictionary_difficulty_lang.id_dictionary_difficulty=task.id_dictionary_difficulty
LEFT JOIN dictionary_age_lang ON dictionary_age_lang.id_dictionary_age=task.id_dictionary_age
LEFT JOIN dictionary_type_lang ON dictionary_type_lang.id_dictionary_type=task.id_dictionary_type
LEFT JOIN shop_goods sg ON sg.id_shop_goods = task.id_shop_goods AND sg.is_show
LEFT JOIN shop_goods_lang sgl ON sgl.id_shop_goods = sg.id_shop_goods
WHERE task.is_show=1 ORDER by date_added DESC LIMIT 50',Array: 1)
#2 /var/www/vitalns2/data/www/www.trizland.ru/_module/task/site/taskpage.base.class.php (534): GetArrayWithID('SELECT *, DATE_FORMAT(task.date_added,'%d.%m.%Y') AS date_added,
(SELECT SUM(VALUE)/COUNT(*) FROM integrator_match JOIN `rating` ON rating.id_rating=integrator_match.id_child WHERE classname_parent='task' AND classname_child='rating' AND id_parent=task.id_task) AS rating,
next_task.id_task AS id_task_next,
prev_task.id_task AS id_task_prev,
task_ref.title AS task_ref_title,
podcast_ref.title AS podcast_ref_title,
podcast_page.path AS podcast_ref_path,
video_page.path AS video_ref_path,
video_ref.title AS video_ref_title,
case_ref.title AS case_ref_title,
case_page.path AS case_ref_path,
method_ref.title AS method_ref_title,
dictionary_difficulty_lang.value AS difficulty_title,
dictionary_age_lang.value AS age_title,
dictionary_type_lang.value AS type_title,
sg.img_small as shop_goods_img_small,
sg.price as shop_goods_price,
sgl.title as shop_goods_price,
sgl.description as shop_goods_description,
task.title as task_title
FROM task
LEFT JOIN method method_ref ON method_ref.id_method = task.id_method_ref
LEFT JOIN task next_task ON next_task.id_task = (SELECT a.id_task FROM task a WHERE a.id_task > task.id_task LIMIT 1)
LEFT JOIN task prev_task ON prev_task.id_task = (SELECT b.id_task FROM task b WHERE b.id_task < task.id_task order by b.id_task DESC LIMIT 1)
LEFT JOIN page case_page ON case_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM cases_list WHERE id_cases_list = (SELECT id_cases_list FROM cases WHERE id_cases = task.id_case_ref)))
LEFT JOIN page podcast_page ON podcast_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_podcast_ref)))
LEFT JOIN page video_page ON video_page.id_page = (SELECT id_page FROM page_module WHERE id_page_module = (SELECT id_page_module FROM news_list WHERE id_news_list = (SELECT id_news_list FROM news WHERE id_news = task.id_video_ref)))
LEFT JOIN cases case_ref ON case_ref.id_cases = task.id_case_ref
LEFT JOIN news_lang video_ref ON video_ref.id_news = task.id_video_ref
LEFT JOIN news_lang podcast_ref ON podcast_ref.id_news = task.id_podcast_ref
LEFT JOIN task task_ref ON task_ref.id_task=task.id_task
LEFT JOIN dictionary_difficulty_lang ON dictionary_difficulty_lang.id_dictionary_difficulty=task.id_dictionary_difficulty
LEFT JOIN dictionary_age_lang ON dictionary_age_lang.id_dictionary_age=task.id_dictionary_age
LEFT JOIN dictionary_type_lang ON dictionary_type_lang.id_dictionary_type=task.id_dictionary_type
LEFT JOIN shop_goods sg ON sg.id_shop_goods = task.id_shop_goods AND sg.is_show
LEFT JOIN shop_goods_lang sgl ON sgl.id_shop_goods = sg.id_shop_goods
WHERE task.is_show=1 ORDER by date_added DESC LIMIT 50')
#3 /var/www/vitalns2/data/www/www.trizland.ru/_module/task/site/taskpage.base.class.php (696): getTasks('',' ORDER by date_added DESC','50')
#4 /var/www/vitalns2/data/www/www.trizland.ru/_phpsf2/_classes/sitepage.class.php (159): showNew()
#5 /var/www/vitalns2/data/www/www.trizland.ru/tasks/index.php (24): perfomAction()
REMOTE_ADDR = 3.232.133.141
USER_AGENT = CCBot/2.0 (https://commoncrawl.org/faq/)
$_SERVER['REQUEST_URI'] = '/tasks/new/'
$_GET = array (
'action' => '11',
)
$_POST = array (
)
$_SESSION = array (
'id_site' => 1,
)