PDOException: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tr_pr.id_tr_project_university' in 'on 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`.`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_contact_address_cs` ,`tr_pr`.`tr_project_contact_address_en` , `tr_pr`.`tr_project_ip_status_cs` ,`tr_pr`.`tr_project_ip_status_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`, `tr_pr`.`id_tr_api`, `tr_pr`.`tr_external_id`, `tr_pr`.`tr_in_competition`, 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, GROUP_CONCAT(DISTINCT trprhasuniv.id_tr_project_university SEPARATOR ';') AS `catids`, `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_3`.`id_tr_project_state` AS `id_tr_project_state`, `TrProjectBase_Model_State_3`.`tr_project_state_name_cs` AS tr_project_state_name_cs,`TrProjectBase_Model_State_3`.`tr_project_state_name_en` AS tr_project_state_name_en, `TrProjectBase_Model_State_3`.`tr_project_state_is_public` AS `tr_project_state_is_public`, `TrProjectBase_Model_State_3`.`tr_project_state_is_archived` AS `tr_project_state_is_archived`, `TrProjectBase_Model_State_3`.`tr_project_state_is_new` AS `tr_project_state_is_new`, `TrProjectBase_Model_State_3`.`tr_project_state_is_working` AS `tr_project_state_is_working`, `TrProjectBase_Model_State_3`.`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_has_university AS trprhasuniv ON (`trprhasuniv`.`id_tr_project` = `tr_pr`.`id_tr_project_university`) 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_3 ON (`TrProjectBase_Model_State_3`.`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_6 ON (`TrProjectBase_Model_ProjectHasKeywords_6`.`id_tr_project` = `tr_pr`.`id_tr_project`) LEFT JOIN web_tr_project_has_partnering_strategy AS TrProjectBase_Model_ProjectHasStrategy_7 ON (`TrProjectBase_Model_ProjectHasStrategy_7`.`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 (:2674b4a5_arr_0) OR `trprcats`.`id_tr_project_parent_category`IN (:2674b506_arr_0) ) AND id_tr_project_keyword IN (:2674b55d_arr_0) ) GROUP BY `tr_pr`.`id_tr_project` HAVING ckeywords >= :ckeywords ORDER BY `tr_pr`.`tr_project_updated` DESC LIMIT :cube_cms_fromrow, :cube_cms_rows

Technology overview

Welcome to the Transfera Technology database.

The Database is a central place for presenting the innovative and commercially usable projects from universities and RaD institutions from all over Czech Republic. If you are looking for an interesting innovation or research partner for your further development, you have come to the right place. In case you do not choose from the projects presented below, do not hesitate to contact us with your request using the inquiry form on your right.

The Transfera Database is there for you to help you to take the right direction in the world of innovation.