SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1
Disk full (/tmp/#sql-temptable-254-3b8cc5-42125.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
$_SERVER
<?
array (
'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'HTTP_X_FORWARDED_FOR' => '216.73.216.34',
'HTTP_X_REAL_IP' => NULL,
'REMOTE_ADDR' => '216.73.216.34',
)
?>
$_GET
<?
array (
'path' => 'seminars/',
'ITEM' => '12062',
'section' => 36,
'menu' => '',
'seminars_category' => '',
)
?>
$_POST
<?
array (
)
?>
$_SESSION
<?
array (
'section' =>
array (
'current_path' => 'seminars',
),
'meta' =>
array (
'id' => '2',
'id_section' => '1',
'id_item' => '0',
'title' => 'Семинары, тренинги и конференции в Москве, России: личностный рост, повышение продаж, обучение персонала, ведение переговоров.',
'description' => 'На сайте представлен график проведения конференций, семинаров и тренингов в Москве и других городах России, цены за участие и имена тренеров. Темы мероприятий: личностный рост, повышение продаж, обучение персонала, ведение переговоров, бухучет, финансы, менеджмент и маркетинг.',
'keywords' => '',
),
'current' => 'seminars',
)
?>
BACKTRACE
<?
array (
0 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/db.php',
'line' => 41,
'function' => 'report',
'class' => 'Error',
'type' => '::',
'args' =>
array (
0 =>
array (
0 => 'SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1',
1 => 'Disk full (/tmp/#sql-temptable-254-3b8cc5-42125.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")',
),
),
),
1 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/db.php',
'line' => 26,
'function' => 'simple_query',
'class' => 'Db',
'object' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
)),
'type' => '->',
'args' =>
array (
0 => 'SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1',
),
),
2 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/db.php',
'line' => 187,
'function' => 'query',
'class' => 'Db',
'object' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
)),
'type' => '->',
'args' =>
array (
0 => 'SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1',
1 => NULL,
),
),
3 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/xml.php',
'line' => 365,
'function' => 'get_all',
'class' => 'Db',
'object' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
)),
'type' => '->',
'args' =>
array (
0 => 'SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1',
1 => NULL,
),
),
4 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/modules/seminars/client_seminars.php',
'line' => 143,
'function' => 'from_db',
'class' => 'Xml',
'type' => '::',
'args' =>
array (
0 => '/',
1 => 'SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1',
2 => NULL,
3 => 'random',
4 => NULL,
),
),
5 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/events.php',
'line' => 13,
'function' => 'get_list',
'class' => 'Client_seminars',
'object' =>
Client_seminars::__set_state(array(
'city' => '',
'corporative' => ' AND s.corporative=0',
'field' => ', s.corporative',
'sec' => NULL,
'sections' => NULL,
'path' => NULL,
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
)),
'table' => 'seminars',
'verify' => true,
'rules' =>
stdClass::__set_state(array(
'bridge' =>
array (
0 => 'id_section',
1 => 'id_trainers',
2 => 'id_contacts',
),
'checkbox' =>
array (
0 => 'corporative',
1 => 'open',
2 => 'free',
),
)),
'field_verify' =>
stdClass::__set_state(array(
'empty' =>
stdClass::__set_state(array(
'name' => 'Название',
'text' => 'Полное описание',
'id_section' => 'Категория',
'id_place' => 'Место проведения',
)),
)),
)),
'type' => '->',
'args' =>
array (
0 => 'random',
),
),
6 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/client_control.php',
'line' => 51,
'function' => 'show',
'class' => 'Events',
'object' =>
Client_seminars::__set_state(array(
'city' => '',
'corporative' => ' AND s.corporative=0',
'field' => ', s.corporative',
'sec' => NULL,
'sections' => NULL,
'path' => NULL,
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
)),
'table' => 'seminars',
'verify' => true,
'rules' =>
stdClass::__set_state(array(
'bridge' =>
array (
0 => 'id_section',
1 => 'id_trainers',
2 => 'id_contacts',
),
'checkbox' =>
array (
0 => 'corporative',
1 => 'open',
2 => 'free',
),
)),
'field_verify' =>
stdClass::__set_state(array(
'empty' =>
stdClass::__set_state(array(
'name' => 'Название',
'text' => 'Полное описание',
'id_section' => 'Категория',
'id_place' => 'Место проведения',
)),
)),
)),
'type' => '->',
'args' =>
array (
0 => 36,
),
),
7 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/index.php',
'line' => 7,
'function' => 'show',
'class' => 'Client_control',
'object' =>
Client_control::__set_state(array(
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
1 => 36,
),
)),
)),
'type' => '->',
'args' =>
array (
),
),
)
?>
SELECT s.module,s.id, s.name, s.visible, s.static, s.sys, s.id_parent, s.path, s.alias, s.count, s.count_open, s.count_last, s.count_corporative, s.count_corporative_open, s.count_corporative_last FROM section s LEFT JOIN meta_tags m ON s.id = m.id_section and m.id_item=0
ORDER BY s.priority
Disk full (/tmp/#sql-temptable-254-3b8cc5-42128.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
$_SERVER
<?
array (
'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'HTTP_X_FORWARDED_FOR' => '216.73.216.34',
'HTTP_X_REAL_IP' => NULL,
'REMOTE_ADDR' => '216.73.216.34',
)
?>
$_GET
<?
array (
'path' => 'seminars/',
'ITEM' => '12062',
'section' => 36,
'menu' => '',
'seminars_category' => '',
)
?>
$_POST
<?
array (
)
?>
$_SESSION
<?
array (
'section' =>
array (
'current_path' => 'seminars',
),
'meta' =>
array (
'id' => '2',
'id_section' => '1',
'id_item' => '0',
'title' => '"ТРЕНЕР ПО ПРОДАЖАМ"',
'description' => '"ТРЕНЕР ПО ПРОДАЖАМ": специализированная программа подготовки тренеров к обучению торгового персонала с полным методическим обеспечением.',
'keywords' => '',
),
'current' => 'seminars',
'permission' =>
array (
'view' =>
array (
),
'add' =>
array (
),
),
'type' => 'seminars',
)
?>
BACKTRACE
<?
array (
0 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/db.php',
'line' => 41,
'function' => 'report',
'class' => 'Error',
'type' => '::',
'args' =>
array (
0 =>
array (
0 => 'SELECT s.module,s.id, s.name, s.visible, s.static, s.sys, s.id_parent, s.path, s.alias, s.count, s.count_open, s.count_last, s.count_corporative, s.count_corporative_open, s.count_corporative_last FROM section s LEFT JOIN meta_tags m ON s.id = m.id_section and m.id_item=0
ORDER BY s.priority',
1 => 'Disk full (/tmp/#sql-temptable-254-3b8cc5-42128.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")',
),
),
),
1 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/db.php',
'line' => 26,
'function' => 'simple_query',
'class' => 'Db',
'object' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
),
)),
'type' => '->',
'args' =>
array (
0 => 'SELECT s.module,s.id, s.name, s.visible, s.static, s.sys, s.id_parent, s.path, s.alias, s.count, s.count_open, s.count_last, s.count_corporative, s.count_corporative_open, s.count_corporative_last FROM section s LEFT JOIN meta_tags m ON s.id = m.id_section and m.id_item=0
ORDER BY s.priority',
),
),
2 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/client_section.php',
'line' => 59,
'function' => 'query',
'class' => 'Db',
'object' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
),
)),
'type' => '->',
'args' =>
array (
0 => 'SELECT s.module,s.id, s.name, s.visible, s.static, s.sys, s.id_parent, s.path, s.alias, s.count, s.count_open, s.count_last, s.count_corporative, s.count_corporative_open, s.count_corporative_last FROM section s LEFT JOIN meta_tags m ON s.id = m.id_section and m.id_item=0
ORDER BY s.priority',
),
),
3 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/client_section.php',
'line' => 122,
'function' => 'get_section',
'class' => 'Client_section',
'object' =>
Client_section::__set_state(array(
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
),
)),
'ar' => NULL,
'index' => NULL,
'mites' => NULL,
'cursor' =>
array (
'current_name' => 'Семинары',
'parent_name' => NULL,
'parent_id' => NULL,
'current_module' => 'mod_seminars',
'current_path' => 'seminars',
'current_id' => 36,
),
'add_ar' => NULL,
'children_id' =>
array (
),
'ar_full' => NULL,
)),
'type' => '->',
'args' =>
array (
),
),
4 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/engine/class/client_control.php',
'line' => 77,
'function' => 'show',
'class' => 'Client_section',
'object' =>
Client_section::__set_state(array(
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
),
)),
'ar' => NULL,
'index' => NULL,
'mites' => NULL,
'cursor' =>
array (
'current_name' => 'Семинары',
'parent_name' => NULL,
'parent_id' => NULL,
'current_module' => 'mod_seminars',
'current_path' => 'seminars',
'current_id' => 36,
),
'add_ar' => NULL,
'children_id' =>
array (
),
'ar_full' => NULL,
)),
'type' => '->',
'args' =>
array (
0 => 'section_category',
1 => '36',
2 => true,
),
),
5 =>
array (
'file' => '/home/allevents/domains/allevents.ru/public_html/index.php',
'line' => 7,
'function' => 'show',
'class' => 'Client_control',
'object' =>
Client_control::__set_state(array(
'db' =>
Db::__set_state(array(
'prepare_tokens' =>
array (
),
'prepare_types' =>
array (
),
'prepared_queries' =>
array (
),
'error' => true,
'last_parameters' =>
array (
0 => 36,
1 => 36,
),
)),
)),
'type' => '->',
'args' =>
array (
),
),
)
?>