Project banner

Editor - Higher Taxa table

PDO

phpMyEdit error: Invalid SQL: [SELECT `PMEtable0`.`ID` 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`.`T_KINGDOM` AS `qf2`,`PMEtable0`.`T_KINGDOM` AS `qf2_idx`,`PMEtable0`.`T_PHYLUM` AS `qf3`,`PMEtable0`.`T_CLASS` AS `qf4`,`PMEtable0`.`T_ORDER` AS `qf5`,`PMEtable0`.`T_FAMILY` AS `qf6` FROM `highertaxa` 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.ID' in 'field list'

phpMyEdit error code: 42S22

MySQL error


phpMyEdit error: invalid SQL query 1


SELECT `PMEtable0`.`ID` 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`.`T_KINGDOM` AS `qf2`,`PMEtable0`.`T_KINGDOM` AS `qf2_idx`,`PMEtable0`.`T_PHYLUM` AS `qf3`,`PMEtable0`.`T_CLASS` AS `qf4`,`PMEtable0`.`T_ORDER` AS `qf5`,`PMEtable0`.`T_FAMILY` AS `qf6` FROM `highertaxa` 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 Kingdom name Phylum/Division name Class name Order name Family name