Author Topic: Connected Route Question  (Read 979 times)

0 Members and 1 Guest are viewing this topic.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3196
  • Last Login:Yesterday at 10:53:45 pm
Re: Connected Route Question
« Reply #15 on: December 29, 2020, 10:26:48 pm »
Code: [Select]
From https://github.com/TravelMapping/Web
   96e1a70..f72a08d  master     -> origin/master
Updating 96e1a70..f72a08d
Fast-forward
 README.md | 2 ++
 1 file changed, 2 insertions(+)
yakra@BiggaTomato:~/TravelMapping/Web$ git log -n 1 README.md
commit f72a08d7a1de1a821211cccb3f1efafb0538e2b5 (HEAD -> master, origin/master, origin/HEAD)
Author: Jim Teresco <terescoj@gmail.com>
Date:   Tue Dec 29 22:01:24 2020 -0500

    Note the change to group_concat_max_len DB server parameter

The MD I-95 case is fixed with a mysqld parameter, as the results of the query to get the lists of drivers/clinchers were being truncated to 1024 characters.  No TM code changes for that.

I'll have to check this out -- noreaster correctly shows 189 Total Drivers; lab2 shows 109.
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3196
  • Last Login:Yesterday at 10:53:45 pm
Re: Connected Route Question
« Reply #16 on: December 29, 2020, 10:35:29 pm »
Jim is this in the my.cnf file? Do I want to add in a
Code: [Select]
group_concat_max_len = 10000?

Edit: Yes.
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2119
  • Last Login:Today at 06:33:59 am
Re: Connected Route Question
« Reply #17 on: December 29, 2020, 10:56:58 pm »
I believe I've got the fix up on the main site.  Looking at various usai and usaus routes, I am seeing much more reasonable results.  Thanks again to mapmikey for the observation that pointed out the problem with my new showroute code from last summer.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3196
  • Last Login:Yesterday at 10:53:45 pm
Re: Connected Route Question
« Reply #18 on: December 29, 2020, 11:43:04 pm »
Thanks again to mapmikey for the observation
Yes. Very well done.
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1497
  • Last Login:Today at 09:02:32 am
Re: Connected Route Question
« Reply #19 on: December 30, 2020, 08:08:47 am »
Thanks everyone.  I agree that the numbers look to be much more realistic now.

Offline mapmikey

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 784
  • Last Login:Today at 06:33:46 am
    • Co-curator Virginia Highways Project
Re: Connected Route Question
« Reply #20 on: December 30, 2020, 08:57:50 am »
Thanks again to mapmikey for the observation
Yes. Very well done.

Happy to have been helpful...