Warning (2) : Error while sending QUERY packet. PID=19459 [CORE/Cake/Model/Datasource/DboSource.php , line 460 ]Code Context $query = $this -> _connection -> prepare ( $sql , $prepareOptions );
$query -> setFetchMode ( PDO :: FETCH_LAZY );
if (! $query -> execute ( $params )) {
$sql = 'SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12'
$params = array()
$prepareOptions = array()
$this = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => false
affected => null
numRows => null
took => null
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql',
'encoding' => 'utf8'
)
cacheSources => true
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
)
)
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array(
'utf8_general_ci' => 'utf8',
'latin1_swedish_ci' => 'latin1'
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 0
[protected] _queriesTime => null
[protected] _queriesLog => array()
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => true
[protected] _descriptions => array(
'yomken.y_links' => array(
[maximum depth reached]
),
'yomken.y_menus' => array(
[maximum depth reached]
),
'yomken.y_i18n' => array(
[maximum depth reached]
),
'yomken.y_errors' => array(
[maximum depth reached]
),
'yomken.y_countries' => array(
[maximum depth reached]
),
'yomken.y_users_addresses' => array(
[maximum depth reached]
),
'yomken.y_news' => array(
[maximum depth reached]
),
'yomken.y_news_categories' => array(
[maximum depth reached]
),
'yomken.y_mediafiles' => array(
[maximum depth reached]
),
'yomken.y_innovations' => array(
[maximum depth reached]
),
'yomken.y_innovations_categories' => array(
[maximum depth reached]
),
'yomken.y_innovations_needs' => array(
[maximum depth reached]
),
'yomken.y_users' => array(
[maximum depth reached]
),
'yomken.y_challenges' => array(
[maximum depth reached]
),
'yomken.y_ratings' => array(
[maximum depth reached]
),
'yomken.y_comments' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'y_acos',
(int) 1 => 'y_answers',
(int) 2 => 'y_aros',
(int) 3 => 'y_aros_acos',
(int) 4 => 'y_avatars',
(int) 5 => 'y_b_ptranslations',
(int) 6 => 'y_brainstorms',
(int) 7 => 'y_challenges',
(int) 8 => 'y_challenges_categories',
(int) 9 => 'y_challenges_experts',
(int) 10 => 'y_challenges_questions',
(int) 11 => 'y_challenges_related_to',
(int) 12 => 'y_challenges_subscribers',
(int) 13 => 'y_comments',
(int) 14 => 'y_configurations',
(int) 15 => 'y_countries',
(int) 16 => 'y_currencies',
(int) 17 => 'y_deposits',
(int) 18 => 'y_donates',
(int) 19 => 'y_errors',
(int) 20 => 'y_files',
(int) 21 => 'y_forms',
(int) 22 => 'y_forms_questions',
(int) 23 => 'y_forms_responses',
(int) 24 => 'y_funds',
(int) 25 => 'y_groups',
(int) 26 => 'y_i18n',
(int) 27 => 'y_innovations',
(int) 28 => 'y_innovations_categories',
(int) 29 => 'y_innovations_needs',
(int) 30 => 'y_institutions',
(int) 31 => 'y_links',
(int) 32 => 'y_media_files',
(int) 33 => 'y_mediafiles',
(int) 34 => 'y_mediafilesx',
(int) 35 => 'y_members',
(int) 36 => 'y_menus',
(int) 37 => 'y_news',
(int) 38 => 'y_news_categories',
(int) 39 => 'y_ngos',
(int) 40 => 'y_options',
(int) 41 => 'y_page_categories',
(int) 42 => 'y_page_pages',
(int) 43 => 'y_pcategories',
(int) 44 => 'y_permissions',
(int) 45 => 'y_pledges',
(int) 46 => 'y_pptranslation',
(int) 47 => 'y_product_categories',
(int) 48 => 'y_product_logs',
(int) 49 => 'y_product_product_targets',
(int) 50 => 'y_product_targets',
(int) 51 => 'y_products',
(int) 52 => 'y_ptranslations',
(int) 53 => 'y_question_types',
(int) 54 => 'y_questions',
(int) 55 => 'y_ratings',
(int) 56 => 'y_reports',
(int) 57 => 'y_resetpasswords',
(int) 58 => 'y_responses_answers',
(int) 59 => 'y_schedules',
(int) 60 => 'y_shipping_zones',
(int) 61 => 'y_sliders',
(int) 62 => 'y_solutions',
(int) 63 => 'y_solutions_categories',
(int) 64 => 'y_solutions_inquiries',
(int) 65 => 'y_solver_profiles',
(int) 66 => 'y_specializations',
(int) 67 => 'y_trends',
(int) 68 => 'y_user_social_details',
(int) 69 => 'y_users',
(int) 70 => 'y_users_addresses',
(int) 71 => 'y_users_groups',
(int) 72 => 'y_widgets'
)
[protected] _transactionStarted => false
}
$query = object(PDOStatement) {
queryString => 'SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12'
} PDOStatement::execute() - [internal], line ??
DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line 460
DboSource::execute() - CORE/Cake/Model/Datasource/DboSource.php, line 426
DboSource::fetchAll() - CORE/Cake/Model/Datasource/DboSource.php, line 670
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1081
Model::find() - CORE/Cake/Model/Model.php, line 2688
PaginatorComponent::paginate() - CORE/Cake/Controller/Component/PaginatorComponent.php, line 196
Controller::paginate() - CORE/Cake/Controller/Controller.php, line 1074
InnovationsController::index() - APP/Controller/InnovationsController.php, line 165
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 109
Innovations | Yomken.com
Database Error
Error:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
SQL Query:
SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12
Notice:
If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array) try {
$query = $this -> _connection -> prepare ( $sql , $prepareOptions );
$query -> setFetchMode ( PDO :: FETCH_LAZY );
if (! $query -> execute ( $params )) {
$this -> _results = $query ;
CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array) $options += array( 'log' => $this -> fullDebug );
$t = microtime ( true );
$this -> _result = $this -> _execute ( $sql , $params );
'SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12'
array()
CORE/Cake/Model/Datasource/DboSource.php line 670 → DboSource->execute(string, array, array) if ( $cache && ( $cached = $this -> getQueryCache ( $sql , $params )) !== false ) {
return $cached ;
}
if ( $result = $this -> execute ( $sql , array(), $params )) {
$out = array();
'SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12'
array()
array()
CORE/Cake/Model/Datasource/DboSource.php line 1081 → DboSource->fetchAll(string, boolean)
$query = trim ( $this -> generateAssociationQuery ( $model , null , null , null , null , $queryData , false , $null ));
$resultSet = $this -> fetchAll ( $query , $model -> cacheQueries );
'SELECT `Innovation`.`id`, `Innovation`.`challenge_id`, `Innovation`.`country_id`, `Innovation`.`category_id`, `Innovation`.`need_id`, `Innovation`.`type`, `Innovation`.`title`, `Innovation`.`short_description`, `Innovation`.`description`, `Innovation`.`need`, `Innovation`.`cover_photo`, `Innovation`.`field_of_research`, `Innovation`.`number_of_pages`, `Innovation`.`institution`, `Innovation`.`price`, `Innovation`.`langauge`, `Innovation`.`file_type`, `Innovation`.`file`, `Innovation`.`published`, `Innovation`.`user_id`, `Innovation`.`mobile`, `Innovation`.`video`, `Innovation`.`access_file`, `Innovation`.`added_date`, `Innovation`.`rating`, `Innovation`.`rating_sum`, `Innovation`.`rating_count`, `Innovation`.`comments`, `Innovation`.`created_at`, `Innovation`.`published_on`, (`I18n__title`.`content`) AS `Innovation__i18n_title`, (`I18n__short_description`.`content`) AS `Innovation__i18n_short_description`, (`I18n__description`.`content`) AS `Innovation__i18n_description`, (`I18n__need`.`content`) AS `Innovation__i18n_need`, (`I18n__field_of_research`.`content`) AS `Innovation__i18n_field_of_research`, (`I18n__institution`.`content`) AS `Innovation__i18n_institution`, (`I18n__langauge`.`content`) AS `Innovation__i18n_langauge`, (`I18n__file_type`.`content`) AS `Innovation__i18n_file_type`, `InnovationsCategory`.`id`, `InnovationsCategory`.`title`, `InnovationsCategory`.`description`, `InnovationsNeed`.`id`, `InnovationsNeed`.`title`, `InnovationsNeed`.`description`, `User`.`id`, `User`.`group_id`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`password`, `User`.`mobile`, `User`.`balance`, `User`.`about`, `User`.`currency`, `User`.`country_id`, `User`.`random_hash`, `User`.`is_admin`, `User`.`locale`, `User`.`address_1`, `User`.`address_2`, `User`.`city`, `User`.`zip`, `User`.`state`, `User`.`old`, `User`.`signup_date`, `User`.`last_login`, `User`.`fb_access_token`, `Country`.`code`, `Country`.`country`, `Country`.`country_ar`, `Country`.`country_fr`, `Challenge`.`id`, `Challenge`.`country_id`, `Challenge`.`currency_id`, `Challenge`.`location`, `Challenge`.`challenges_category_id`, `Challenge`.`related_to_id`, `Challenge`.`title`, `Challenge`.`description`, `Challenge`.`end_date`, `Challenge`.`deadline_scenario`, `Challenge`.`reward`, `Challenge`.`notes`, `Challenge`.`impact`, `Challenge`.`previous_solution`, `Challenge`.`challenge_field`, `Challenge`.`specializations`, `Challenge`.`difficulty`, `Challenge`.`image`, `Challenge`.`video`, `Challenge`.`link`, `Challenge`.`award_number`, `Challenge`.`reward_type`, `Challenge`.`reward_amount`, `Challenge`.`reward_description`, `Challenge`.`team`, `Challenge`.`expect`, `Challenge`.`user_id`, `Challenge`.`mobile`, `Challenge`.`published`, `Challenge`.`solved`, `Challenge`.`reward_sponsors`, `Challenge`.`is_selected`, `Challenge`.`under_evl`, `Challenge`.`form_id`, `Challenge`.`solution_count`, `Challenge`.`comments`, `Challenge`.`created_at` FROM `yomken`.`y_innovations` AS `Innovation` INNER JOIN `yomken`.`y_i18n` AS `I18n__title` ON (`Innovation`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Innovation' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__short_description` ON (`Innovation`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Innovation' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__description` ON (`Innovation`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Innovation' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__need` ON (`Innovation`.`id` = `I18n__need`.`foreign_key` AND `I18n__need`.`model` = 'Innovation' AND `I18n__need`.`field` = 'need' AND `I18n__need`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__field_of_research` ON (`Innovation`.`id` = `I18n__field_of_research`.`foreign_key` AND `I18n__field_of_research`.`model` = 'Innovation' AND `I18n__field_of_research`.`field` = 'field_of_research' AND `I18n__field_of_research`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__institution` ON (`Innovation`.`id` = `I18n__institution`.`foreign_key` AND `I18n__institution`.`model` = 'Innovation' AND `I18n__institution`.`field` = 'institution' AND `I18n__institution`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__langauge` ON (`Innovation`.`id` = `I18n__langauge`.`foreign_key` AND `I18n__langauge`.`model` = 'Innovation' AND `I18n__langauge`.`field` = 'langauge' AND `I18n__langauge`.`locale` = 'ar') INNER JOIN `yomken`.`y_i18n` AS `I18n__file_type` ON (`Innovation`.`id` = `I18n__file_type`.`foreign_key` AND `I18n__file_type`.`model` = 'Innovation' AND `I18n__file_type`.`field` = 'file_type' AND `I18n__file_type`.`locale` = 'ar') LEFT JOIN `yomken`.`y_innovations_categories` AS `InnovationsCategory` ON (`Innovation`.`category_id` = `InnovationsCategory`.`id`) LEFT JOIN `yomken`.`y_innovations_needs` AS `InnovationsNeed` ON (`Innovation`.`need_id` = `InnovationsNeed`.`id`) LEFT JOIN `yomken`.`y_users` AS `User` ON (`Innovation`.`user_id` = `User`.`id`) LEFT JOIN `yomken`.`y_countries` AS `Country` ON (`Innovation`.`country_id` = `Country`.`code`) LEFT JOIN `yomken`.`y_challenges` AS `Challenge` ON (`Innovation`.`challenge_id` = `Challenge`.`id`) WHERE `Innovation`.`published` = 1 AND `category_id` = 13 AND `type` = 'Innovation' ORDER BY `Innovation`.`added_date` desc LIMIT 12'
false
CORE/Cake/Model/Model.php line 2688 → DboSource->read(Innovation, array) return null ;
}
$results = $this -> getDataSource ()-> read ( $this , $query );
$this -> resetAssociations ();
object(Innovation) {
actsAs => array(
[maximum depth reached]
)
displayField => 'title'
validate => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
cdata => array([maximum depth reached])
getData => array([maximum depth reached])
useDbConfig => 'default'
useTable => 'innovations'
id => false
data => array([maximum depth reached])
schemaName => 'yomken'
table => 'innovations'
primaryKey => 'id'
validationErrors => array([maximum depth reached])
validationDomain => null
plugin => null
name => 'Innovation'
alias => 'Innovation'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'all'
recursive => (int) 1
order => null
virtualFields => array(
[maximum depth reached]
)
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
findMethods => array(
[maximum depth reached]
)
Rating => object(Rating) {}
Comment => object(Comment) {}
recaptcha => true
InnovationsCategory => object(InnovationsCategory) {}
InnovationsNeed => object(InnovationsNeed) {}
tablePrefix => 'y_'
locale => 'ar'
User => object(User) {}
Country => object(Country) {}
Challenge => object(Challenge) {}
Mediafile => object(Mediafile) {}
[protected] _schema => array(
[maximum depth reached]
)
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
array(
'conditions' => array(
'Innovation.published' => (int) 1,
'category_id' => '13',
'type' => 'Innovation'
),
'fields' => null,
'joins' => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
)
),
'limit' => (int) 12,
'offset' => null,
'order' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'maxLimit' => (int) 12,
'paramType' => 'named'
)
CORE/Cake/Controller/Component/PaginatorComponent.php line 196 → Model->find(string, array) if ( $recursive != $object -> recursive ) {
$parameters [ 'recursive' ] = $recursive ;
}
$results = $object -> find ( $type , array_merge ( $parameters , $extra ));
}
'all'
array(
'conditions' => array(
'Innovation.published' => (int) 1,
'category_id' => '13',
'type' => 'Innovation'
),
'fields' => null,
'order' => array(
'Innovation.added_date' => 'desc'
),
'limit' => (int) 12,
'page' => (int) 1,
'maxLimit' => (int) 12,
'paramType' => 'named'
)
CORE/Cake/Controller/Controller.php line 1074 → PaginatorComponent->paginate(null, array, array) * @ deprecated Use PaginatorComponent instead
*/
public function paginate ( $object = null , $scope = array(), $whitelist = array()) {
return $this -> Components -> load ( 'Paginator' , $this -> paginate )-> paginate ( $object , $scope , $whitelist );
}
APP/Controller/InnovationsController.php line 165 → Controller->paginate() $innovationsCategories = $this -> Innovation -> InnovationsCategory -> find ( 'list' );
$innovationsNeeds = $this -> Innovation -> InnovationsNeed -> find ( 'list' );
$innovations = $this -> paginate ();
[internal function] → InnovationsController->index(string, string, string, string, string) 'cat-13'
'type-Innovation'
'need-all'
'order-added_date,DESC'
'all'
CORE/Cake/Controller/Controller.php line 486 → ReflectionMethod->invokeArgs(InnovationsController, array) 'action' => $request -> params [ 'action' ]
));
}
return $method -> invokeArgs ( $this , $request -> params [ 'pass' ]);
object(InnovationsController) {
components => array(
[maximum depth reached]
)
helpers => array(
[maximum depth reached]
)
name => 'Innovations'
uses => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Innovations'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'index'
layout => 'home'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Innovation'
modelKey => 'innovation'
validationErrors => null
Acl => object(AclComponent) {}
Auth => object(AuthComponent) {}
Session => object(SessionComponent) {}
Recaptcha => object(RecaptchaComponent) {}
Paginator => object(PaginatorComponent) {}
Ratings => object(RatingsComponent) {}
Comments => object(CommentsComponent) {}
Innovation => object(Innovation) {}
Link => object(Link) {}
Error => object(Error) {}
News => object(News) {}
SolverProfile => object(SolverProfile) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => 'cat-13',
(int) 1 => 'type-Innovation',
(int) 2 => 'need-all',
(int) 3 => 'order-added_date,DESC',
(int) 4 => 'all'
)
CORE/Cake/Routing/Dispatcher.php line 187 → Controller->invokeAction(CakeRequest) $controller -> startupProcess ();
$render = true ;
$result = $controller -> invokeAction ( $request );
if ( $result instanceof CakeResponse ) {
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
base => ''
webroot => '/'
here => '/ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(InnovationsController, CakeRequest, CakeResponse) ));
}
$response = $this -> _invoke ( $controller , $request , $response );
if (isset( $request -> params [ 'return' ])) {
object(InnovationsController) {
components => array(
[maximum depth reached]
)
helpers => array(
[maximum depth reached]
)
name => 'Innovations'
uses => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Innovations'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'index'
layout => 'home'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Innovation'
modelKey => 'innovation'
validationErrors => null
Acl => object(AclComponent) {}
Auth => object(AuthComponent) {}
Session => object(SessionComponent) {}
Recaptcha => object(RecaptchaComponent) {}
Paginator => object(PaginatorComponent) {}
Ratings => object(RatingsComponent) {}
Comments => object(CommentsComponent) {}
Innovation => object(Innovation) {}
Link => object(Link) {}
Error => object(Error) {}
News => object(News) {}
SolverProfile => object(SolverProfile) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
base => ''
webroot => '/'
here => '/ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array([maximum depth reached])
}
APP/webroot/index.php line 109 → Dispatcher->dispatch(CakeRequest, CakeResponse) $Dispatcher -> dispatch (
new CakeRequest (),
new CakeResponse ()
);
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
base => ''
webroot => '/'
here => '/ar/marketplace/cat-13/type-Innovation/need-all/order-added_date,DESC/all'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array([maximum depth reached])
}