There has been an error with the database. An e-mail has been automatically sent to us, and we'll look into the problem as soon as possible.

Sorry for any inconvenience, we are working hard to make the site as error-proof as possible and your input helps incredibly.Error Type 256: /usr/local/website/evergreen/php/include/lib/db_functions.inc Line: 15
CUSTOM ERROR: Database Error: SELECT s.live_plant_ID, CONCAT(l.genus, ' ', l.species, ' ', l.subspecies) as full_name, l.common_name, l.genus, l.species, l.subspecies, l.family_latin, l.family_common, l.synonyms, s.natureserve_level_1, s.type, s.province, s.red_alert, s.ecozone, s.evergreen, CONCAT(s.natural_habitat,s.manmade_habitat,s.ecozone) as habitat, s.natural_habitat, s.manmade_habitat, s.temperature_zone, s.erosion_control, CONCAT( IF(s.evergreen IS NOT NULL,s.evergreen,''), IF(s.height_low != 0,s.height_low,''), IF(s.height_high != 0,s.height_high,''), IF(s.drought_tol != 0,s.drought_tol,''), IF(s.salt_tol != 0,s.salt_tol,''), IF(s.compaction_tol != 0,s.compaction_tol,''), IF(s.juglones_tol != 0,s.juglones_tol,''), IF(s.drought_tol != 0,s.drought_tol,''), s.moisture_req, s.light_req, s.soil_req, s.acid_req, s.temperature_zone) as characteristics, s.height_low, s.height_high, s.drought_tol, s.salt_tol, s.compaction_tol, s.juglones_tol, s.moisture_req, s.light_req, s.soil_req, s.acid_req, CONCAT( IF(s.flowers_showy IS NOT NULL,s.flowers_showy,''), s.bloom_start, s.bloom_finish, s.flower_colour, s.fragrant_flowers) as flowers, s.flowers_showy, s.bloom_start, s.bloom_finish, s.flower_colour, CONCAT( IF(s.fruit_showy IS NOT NULL,s.fruit_showy,''), s.fruit_edible, s.fruit_colour) as fruit, s.fruit_showy, s.fruit_edible, s.fruit_colour, s.fragrant_flowers, CONCAT( IF(s.fragrant_foliage IS NOT NULL AND s.fragrant_foliage != 0,s.fragrant_foliage,''), IF(s.fall_colour IS NOT NULL AND s.fall_colour != 0,s.fall_colour,''), IF(s.distinctive_bark IS NOT NULL AND s.distinctive_bark != 0,s.distinctive_bark,''), IF(s.poisonous IS NOT NULL AND s.poisonous != 0, s.poisonous,''), IF(s.thorns_prickles IS NOT NULL AND s.thorns_prickles != 0, s.thorns_prickles,''), s.attracts_wildlife, l.larval_host_species, IF(s.plant_watch_species IS NOT NULL,s.plant_watch_species,'')) as miscellaneous, s.fragrant_foliage, s.fall_colour, s.distinctive_bark, s.poisonous, s.thorns_prickles, s.attracts_wildlife, l.larval_host_species, s.plant_watch_species, CONCAT(s.uses,s.provincial_symbol) as allUses, s.uses, s.provincial_symbol, l.tidbits, l.notes, s.invasive FROM npl_live_plants_english as l, npl_live_plants AS s, npl_plants as p WHERE l.live_plant_ID = s.live_plant_ID AND s.live_plant_ID = p.live_plant_ID AND p.plant_ID = '00377'