Project banner

Editor - Resources table

PDO

phpMyEdit error: Invalid SQL: [SELECT `PMEtable0`.`R_NO` AS `qf0`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) AS `qf1`,`PMEtable0`.`T_NO` AS `qf1_idx`,`PMEtable0`.`R_TYPE` AS `qf2`,`PMEtable0`.`R_TYPE` AS `qf2_idx`,`PMEtable0`.`R_RESOURCE` AS `qf3`,`PMEtable0`.`R_CAPTION` AS `qf4` FROM `resources` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) ORDER BY CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) LIMIT 0, 15] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'PMEtable0.R_NO' in 'field list'

phpMyEdit error code: 42S22

MySQL error


phpMyEdit error: invalid SQL query 1


SELECT `PMEtable0`.`R_NO` AS `qf0`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) AS `qf1`,`PMEtable0`.`T_NO` AS `qf1_idx`,`PMEtable0`.`R_TYPE` AS `qf2`,`PMEtable0`.`R_TYPE` AS `qf2_idx`,`PMEtable0`.`R_RESOURCE` AS `qf3`,`PMEtable0`.`R_CAPTION` AS `qf4` FROM `resources` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) ORDER BY CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) LIMIT 0, 15

phpMyEdit error code: 42S22

Download as: Excel | CSV


Powered by ACACIA

Taxon name Type of resource Filename of media resource Resource caption