A database error occurred while performing the requested procedure. Please review the database error below for more information.
C:/inetpub/bystrice/src/system/libraries/drivers/Database/Mysqli.php [158]:
There was an SQL error: Unknown column '0' in 'order clause' - SELECT `averaged_emission`.`id` AS `averaged_emission:id`, `averaged_emission`.`emission_id` AS `averaged_emission:emission_id`, `averaged_emission`.`timespan_avg` AS `averaged_emission:timespan_avg`, `averaged_emission`.`immission_limit` AS `averaged_emission:immission_limit`, `averaged_emission`.`description_cs` AS `averaged_emission:description_cs`, `averaged_emission`.`description_en` AS `averaged_emission:description_en`, `averaged_emission`.`description_de` AS `averaged_emission:description_de`, `averaged_emission`.`description_pl` AS `averaged_emission:description_pl`, `averaged_emission`.`description_lt` AS `averaged_emission:description_lt`, `measures`.*
FROM `measures`
JOIN `stations` ON (`measures`.`station_id` = `stations`.`id`)
LEFT JOIN `averaged_emissions` AS `averaged_emission` ON (`averaged_emission`.`id` = `measures`.`averaged_emission_id`)
WHERE `averaged_emission`.`emission_id` = 10
AND stations.web_accessible = 1
AND measures.enabled = 1
AND `measures`.`station_id` NOT IN ('')
ORDER BY 0 ASC, `1` ASC, `measures`.`id` ASC
Kohana_Mysqli_Result->__construct( mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 1054 [error] => Unknown column '0' in 'order clause' [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667983 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) , 1, SELECT `averaged_emission`.`id` AS `averaged_emission:id`, `averaged_emission`.`emission_id` AS `averaged_emission:emission_id`, `averaged_emission`.`timespan_avg` AS `averaged_emission:timespan_avg`, `averaged_emission`.`immission_limit` AS `averaged_emission:immission_limit`, `averaged_emission`.`description_cs` AS `averaged_emission:description_cs`, `averaged_emission`.`description_en` AS `averaged_emission:description_en`, `averaged_emission`.`description_de` AS `averaged_emission:description_de`, `averaged_emission`.`description_pl` AS `averaged_emission:description_pl`, `averaged_emission`.`description_lt` AS `averaged_emission:description_lt`, `measures`.* FROM `measures` JOIN `stations` ON (`measures`.`station_id` = `stations`.`id`) LEFT JOIN `averaged_emissions` AS `averaged_emission` ON (`averaged_emission`.`id` = `measures`.`averaged_emission_id`) WHERE `averaged_emission`.`emission_id` = 10 AND stations.web_accessible = 1 AND measures.enabled = 1 AND `measures`.`station_id` NOT IN ('') ORDER BY 0 ASC, `1` ASC, `measures`.`id` ASC )
Database_Mysqli_Driver->query( SELECT `averaged_emission`.`id` AS `averaged_emission:id`, `averaged_emission`.`emission_id` AS `averaged_emission:emission_id`, `averaged_emission`.`timespan_avg` AS `averaged_emission:timespan_avg`, `averaged_emission`.`immission_limit` AS `averaged_emission:immission_limit`, `averaged_emission`.`description_cs` AS `averaged_emission:description_cs`, `averaged_emission`.`description_en` AS `averaged_emission:description_en`, `averaged_emission`.`description_de` AS `averaged_emission:description_de`, `averaged_emission`.`description_pl` AS `averaged_emission:description_pl`, `averaged_emission`.`description_lt` AS `averaged_emission:description_lt`, `measures`.* FROM `measures` JOIN `stations` ON (`measures`.`station_id` = `stations`.`id`) LEFT JOIN `averaged_emissions` AS `averaged_emission` ON (`averaged_emission`.`id` = `measures`.`averaged_emission_id`) WHERE `averaged_emission`.`emission_id` = 10 AND stations.web_accessible = 1 AND measures.enabled = 1 AND `measures`.`station_id` NOT IN ('') ORDER BY 0 ASC, `1` ASC, `measures`.`id` ASC )
Database_Core->query( SELECT `averaged_emission`.`id` AS `averaged_emission:id`, `averaged_emission`.`emission_id` AS `averaged_emission:emission_id`, `averaged_emission`.`timespan_avg` AS `averaged_emission:timespan_avg`, `averaged_emission`.`immission_limit` AS `averaged_emission:immission_limit`, `averaged_emission`.`description_cs` AS `averaged_emission:description_cs`, `averaged_emission`.`description_en` AS `averaged_emission:description_en`, `averaged_emission`.`description_de` AS `averaged_emission:description_de`, `averaged_emission`.`description_pl` AS `averaged_emission:description_pl`, `averaged_emission`.`description_lt` AS `averaged_emission:description_lt`, `measures`.* FROM `measures` JOIN `stations` ON (`measures`.`station_id` = `stations`.`id`) LEFT JOIN `averaged_emissions` AS `averaged_emission` ON (`averaged_emission`.`id` = `measures`.`averaged_emission_id`) WHERE `averaged_emission`.`emission_id` = 10 AND stations.web_accessible = 1 AND measures.enabled = 1 AND `measures`.`station_id` NOT IN ('') ORDER BY 0 ASC, `1` ASC, `measures`.`id` ASC )
Database_Core->get( measures )
ORM_Core->load_result( 1 )
ORM_Core->find_all( )
Emission_Controller->detail( 10 )
ReflectionMethod->invokeArgs( Emission_Controller Object ( [template] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/public_base.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [stationMenu] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/station_menu.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [stations] => ORM_Iterator Object ( [class_name:protected] => Station_Model [primary_key:protected] => id [primary_val:protected] => name [result:protected] => Kohana_Mysqli_Result Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667984 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) [fetch_type:protected] => fetch_object [return_type:protected] => stdClass [result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 27 [lengths] => [num_rows] => 1 [type] => 0 ) [insert_id:protected] => [sql:protected] => SELECT `stations`.* FROM `stations` WHERE web_accessible = 1 ORDER BY `stations`.`position` ASC, `stations`.`id` ASC [current_row:protected] => 0 [total_rows:protected] => 1 ) ) [stationCount] => 1 [currentStationId] => [currentEmissionId] => ) ) [emissionMenu] => [articleMenu] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/article_menu.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [articles] => ORM_Iterator Object ( [class_name:protected] => Article_Model [primary_key:protected] => id [primary_val:protected] => name [result:protected] => Kohana_Mysqli_Result Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667985 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) [fetch_type:protected] => fetch_object [return_type:protected] => stdClass [result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 17 [lengths] => [num_rows] => 4 [type] => 0 ) [insert_id:protected] => [sql:protected] => SELECT `articles`.* FROM `articles` WHERE menu_title_cs IS NOT NULL OR menu_title_cs='' ORDER BY `articles`.`position` ASC, `articles`.`id` DESC [current_row:protected] => 0 [total_rows:protected] => 4 ) ) [currentArticleId] => ) ) [title] => Velká Bystřice [header_title] => Velká Bystřice [header_subtitle] => Imisní monitoring [header_logo] => 2 [header_background] => 4 [footer_text] => [languages] => Array ( [0] => cs [1] => en ) [currentLanguage] => cs [content] => ) ) [stationMenu:protected] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/station_menu.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [stations] => ORM_Iterator Object ( [class_name:protected] => Station_Model [primary_key:protected] => id [primary_val:protected] => name [result:protected] => Kohana_Mysqli_Result Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667986 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) [fetch_type:protected] => fetch_object [return_type:protected] => stdClass [result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 27 [lengths] => [num_rows] => 1 [type] => 0 ) [insert_id:protected] => [sql:protected] => SELECT `stations`.* FROM `stations` WHERE web_accessible = 1 ORDER BY `stations`.`position` ASC, `stations`.`id` ASC [current_row:protected] => 0 [total_rows:protected] => 1 ) ) [stationCount] => 1 [currentStationId] => [currentEmissionId] => ) ) [emissionMenu:protected] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/emission_menu.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [emissions] => ORM_Iterator Object ( [class_name:protected] => Emission_Model [primary_key:protected] => id [primary_val:protected] => name [result:protected] => Kohana_Mysqli_Result Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667987 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) [fetch_type:protected] => fetch_object [return_type:protected] => stdClass [result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 25 [lengths] => [num_rows] => 11 [type] => 0 ) [insert_id:protected] => [sql:protected] => SELECT `emissions`.* FROM `emissions` JOIN `averaged_emissions` ON (`averaged_emissions`.`emission_id` = `emissions`.`id`) JOIN `measures` ON (`measures`.`averaged_emission_id` = `averaged_emissions`.`id`) JOIN `stations` ON (`measures`.`station_id` = `stations`.`id`) WHERE measures.enabled = 1 AND stations.web_accessible = 1 GROUP BY `id` ORDER BY `emissions`.`position` ASC, `emissions`.`id` ASC [current_row:protected] => 0 [total_rows:protected] => 11 ) ) [currentEmissionId] => 10 [excludedStations] => Array ( [0] => ) ) ) [articleMenu:protected] => View Object ( [kohana_filename:protected] => C:/inetpub/bystrice/src/meteo_public/views/article_menu.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [articles] => ORM_Iterator Object ( [class_name:protected] => Article_Model [primary_key:protected] => id [primary_val:protected] => name [result:protected] => Kohana_Mysqli_Result Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 6 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.16-log [server_version] => 50616 [stat] => Uptime: 3031347 Threads: 18 Questions: 54667988 Slow queries: 405144 Opens: 280 Flush tables: 1 Open tables: 267 Queries per second avg: 18.034 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 450224 [warning_count] => 0 ) [fetch_type:protected] => fetch_object [return_type:protected] => stdClass [result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 17 [lengths] => [num_rows] => 4 [type] => 0 ) [insert_id:protected] => [sql:protected] => SELECT `articles`.* FROM `articles` WHERE menu_title_cs IS NOT NULL OR menu_title_cs='' ORDER BY `articles`.`position` ASC, `articles`.`id` DESC [current_row:protected] => 0 [total_rows:protected] => 4 ) ) [currentArticleId] => ) ) [content:protected] => [auto_render] => 1 [uri] => URI Object ( ) [input] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => [ip_address] => ) ) , Array ( [0] => 10 ) )
Kohana::instance( )
call_user_func( Array ( [0] => Kohana [1] => instance ) )
Event::run( system.execute )
require( C:\inetpub\bystrice\src\system\core\Bootstrap.php )
Loaded in 0.0468 seconds, using 1.34MB of memory. Generated by Kohana v2.3.2.