Author Topic: Connected Route Question  (Read 767 times)

0 Members and 1 Guest are viewing this topic.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3026
  • Last Login:Today at 02:55:32 am
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.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3026
  • Last Login:Today at 02:55:32 am
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.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2000
  • Last Login:Yesterday at 11:50:39 pm
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: 3026
  • Last Login:Today at 02:55:32 am
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.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1108
  • Last Login:Yesterday at 07:22:20 pm
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: 663
  • Last Login:Yesterday at 12:23:43 pm
    • 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...