Myths on Maps

  • Log in
  • « Group concat max length - MySQL
  • Further to previous post »

Bug report

Posted by gregster on 17 Nov 2010 in Tasks

Bug: results containing anomalous citations
e.g.
Place: Pylus
Char: Abas (1)
Cite: Apollodorus 1.9.9

Problem: Abas doesn't actually show up in 1.9.9

Also, in tracking this down I notice that when I look at the view (in phpMyAdmin) I get data that's cut off. Are the fields too short? How? Why?

Here's the view:
CREATE VIEW `view_characters_places` AS select
`view_events_characters`.`character_name` AS `character_name`,
`view_events_characters`.`character_id` AS `character_id`,
group_concat(distinct `view_events_places`.`place_name` order by `view_events_places`.`place_name` ASC separator ', ') AS `place_name`,
group_concat(distinct cast(`view_events_places`.`place_id` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `place_id`,
group_concat(distinct cast(`Places`.`latitude` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `latitude`,
group_concat(distinct cast(`Places`.`longitude` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `longitude`,
group_concat(distinct `view_events_places`.`citation` order by `view_events_places`.`place_name` ASC separator ', ') AS `citation`

from (
(`view_events_characters` join `view_events_places`) join `Places`
)
where (
(`view_events_places`.`event_id` = `view_events_characters`.`event_id`)
and (`Places`.`place_id` = `view_events_places`.`place_id`)
)
group by `view_events_characters`.`character_name` order by `view_events_characters`.`character_name`;

This entry was posted by Greg and filed under Tasks.

Myths on Maps

This project will focus on deploying an interactive map of Europe with overlays for Greek and Roman myths, history, people and events.
SVN instructions for MoM editors
Development URL
HCMC Blogs home
  • Archives
  • Categories

Search

XML Feeds

  • Atom: Posts
  • RSS 2.0: Posts
More on RSS

This collection ©2023 by admin • Help • evoCore