Technology overview | Transfera.cz

PDOException: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tr_project_institutions_name' in 'order clause' File: /home/transfera.cz/htdocs/portfolio/lib/db/pdo/db_pdo_statement.class.php, line: 25

WARNING: (2) in_array() expects parameter 2 to be array, string given File: /home/transfera.cz/htdocs/portfolio/modules/trprojectbase/templates/projects_categories_grid.phtml, line: 13

Error:

ERROR SQL: SELECT SQL_CALC_FOUND_ROWS `tr_pr`.`id_tr_project`, `tr_pr`.`id_tr_project`, `tr_pr`.`id_tr_project_dev_status`, `tr_pr`.`id_tr_project_parent_institution`, `tr_pr`.`tr_project_name_cs` ,`tr_pr`.`tr_project_name_en` , `tr_pr`.`tr_project_challenge_cs` ,`tr_pr`.`tr_project_challenge_en` , `tr_pr`.`tr_project_desc_cs` ,`tr_pr`.`tr_project_desc_en` , `tr_pr`.`tr_project_c_opportunity_cs` ,`tr_pr`.`tr_project_c_opportunity_en` , `tr_pr`.`tr_project_further_information_cs` ,`tr_pr`.`tr_project_further_information_en` , `tr_pr`.`tr_project_contact_phone`, `tr_pr`.`tr_project_contact_email`, `tr_pr`.`tr_project_ip_status_cs` ,`tr_pr`.`tr_project_ip_status_en` , `tr_pr`.`tr_project_contact_address_cs` ,`tr_pr`.`tr_project_contact_address_en` , `tr_pr`.`tr_project_dev_status_note_cs` ,`tr_pr`.`tr_project_dev_status_note_en` , `tr_pr`.`tr_project_owner`, `tr_pr`.`tr_project_created`, `tr_pr`.`tr_project_updated`, COUNT(DISTINCT id_tr_project_keyword) AS `ckeywords`, `TrProjectBase_Model_DevStatus_1`.`tr_project_dev_status_name_cs` AS tr_project_dev_status_name_cs,`TrProjectBase_Model_DevStatus_1`.`tr_project_dev_status_name_en` AS tr_project_dev_status_name_en, `TrProjectBase_Model_DevStatus_1`.`tr_project_dev_status_desc_cs` AS tr_project_dev_status_desc_cs,`TrProjectBase_Model_DevStatus_1`.`tr_project_dev_status_desc_en` AS tr_project_dev_status_desc_en, `trprinst`.`tr_project_inst_parent_name_cs` ,`trprinst`.`tr_project_inst_parent_name_en` , `trprinst`.`id_tr_project_institution`, `tr_ptr_instusers`.`id_user`, `prh`.`id_tr_project_history` AS `id_tr_project_history`, `prh`.`id_tr_project_state` AS `id_tr_project_state`, `prh`.`tr_history_note` AS `tr_history_note`, `prh`.`tr_history_created` AS `tr_history_created`, `prh`.`tr_history_orig_project` AS `tr_history_orig_project`, `TrProjectBase_Model_State_4`.`id_tr_project_state` AS `id_tr_project_state`, `TrProjectBase_Model_State_4`.`tr_project_state_name_cs` AS tr_project_state_name_cs,`TrProjectBase_Model_State_4`.`tr_project_state_name_en` AS tr_project_state_name_en, `TrProjectBase_Model_State_4`.`tr_project_state_is_public` AS `tr_project_state_is_public`, `TrProjectBase_Model_State_4`.`tr_project_state_is_archived` AS `tr_project_state_is_archived`, `TrProjectBase_Model_State_4`.`tr_project_state_is_new` AS `tr_project_state_is_new`, `TrProjectBase_Model_State_4`.`tr_project_state_is_working` AS `tr_project_state_is_working`, `TrProjectBase_Model_State_4`.`tr_project_state_label` AS `tr_project_state_label`, GROUP_CONCAT(DISTINCT trprhascats.id_tr_project_category SEPARATOR ';') AS `catids`, `trprcats`.`id_tr_project_category` AS `id_tr_project_category`, `trprcats`.`id_tr_project_parent_category` AS `id_tr_project_parent_category`, `trprcats`.`tr_project_category_name_cs` AS tr_project_category_name_cs,`trprcats`.`tr_project_category_name_en` AS tr_project_category_name_en, `trprcats`.`tr_project_category_icon` AS `tr_project_category_icon`, GROUP_CONCAT(DISTINCT id_tr_project_keyword SEPARATOR ';') AS `keywordsids`, GROUP_CONCAT(DISTINCT id_tr_project_partner_strategy SEPARATOR ';') AS `psids` FROM `transferacz_portfolio`.`web_tr_project` AS tr_pr LEFT JOIN web_tr_project_dev_status AS TrProjectBase_Model_DevStatus_1 ON (`TrProjectBase_Model_DevStatus_1`.`id_tr_project_dev_status` = `tr_pr`.`id_tr_project_dev_status`) LEFT JOIN web_tr_project_parent_institutions AS trprinst ON (`trprinst`.`id_tr_project_parent_institution` = `tr_pr`.`id_tr_project_parent_institution`) LEFT JOIN web_tr_project_institution_has_users AS tr_ptr_instusers ON (`tr_ptr_instusers`.`id_tr_project_institution` = `trprinst`.`id_tr_project_institution`) LEFT JOIN web_tr_project_history AS prh ON (`prh`.`id_tr_project_history` = (SELECT `history_w_desc`.`id_tr_project_history` FROM `transferacz_portfolio`.`web_tr_project_history` AS history_w_desc WHERE (`history_w_desc`.`id_tr_project` = `tr_pr`.`id_tr_project`) ORDER BY `history_w_desc`.`tr_history_created` DESC LIMIT 0, 1 )) LEFT JOIN web_tr_project_state AS TrProjectBase_Model_State_4 ON (`TrProjectBase_Model_State_4`.`id_tr_project_state` = `prh`.`id_tr_project_state`) LEFT JOIN web_tr_project_has_categories AS trprhascats ON (`trprhascats`.`id_tr_project` = `tr_pr`.`id_tr_project`) LEFT JOIN web_tr_project_categories AS trprcats ON (`trprcats`.`id_tr_project_category` = `trprhascats`.`id_tr_project_category`) LEFT JOIN web_tr_project_has_keywords AS TrProjectBase_Model_ProjectHasKeywords_7 ON (`TrProjectBase_Model_ProjectHasKeywords_7`.`id_tr_project` = `tr_pr`.`id_tr_project`) LEFT JOIN web_tr_project_has_partnering_strategy AS TrProjectBase_Model_ProjectHasStrategy_8 ON (`TrProjectBase_Model_ProjectHasStrategy_8`.`id_tr_project` = `tr_pr`.`id_tr_project`) WHERE (tr_project_state_is_archived = 0 AND tr_project_state_is_public = 1 AND tr_project_name_en != "" AND ( `trprcats`.`id_tr_project_category`IN (:6ca9bfdf_arr_0) OR `trprcats`.`id_tr_project_parent_category`IN (:6ca9c031_arr_0) ) AND id_tr_project_keyword IN (:6ca9c0ee_arr_0) ) GROUP BY `tr_pr`.`id_tr_project` HAVING ckeywords >= :ckeywords ORDER BY `tr_project_institutions_name` ASC LIMIT :cube_cms_fromrow, :cube_cms_rows

The name of the technology	Institution	Updated
No results found