PDOException: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tr_pr.id_tr_project_university' in 'on clause' soubor: /home/transfera.cz/htdocs/portfolio/lib/db/pdo/db_pdo_statement.class.php, řádek: 25

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

Chyba:

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_cs != "" AND ( `trprcats`.`id_tr_project_category`IN (:2c8e3646_arr_0) OR `trprcats`.`id_tr_project_parent_category`IN (:2c8e369b_arr_0) ) AND id_tr_project_keyword IN (:2c8e36e6_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

Přehled technologií

Vítejte v databázi technologií Transfera.

Databáze představuje centrální místo pro prezentaci inovativních a komerčně využitelných projektů z univerzit a vědeckovýzkumných institucí z celé České republiky. Pokud pro svůj další rozvoj hledáte zajímavé inovace nebo výzkumného partnera, jste na správném místě. V případě, že si nevyberete z projektů prezentovaných níže, neváhejte nás se svou poptávkou oslovit pomocí poptávkového formuláře vpravo.

Databáze Transfera je tu pro vás, aby vám pomohla nabrat správný směr ve světě inovací.