[SOLVED] [ strace sql ] Contacts Section of Company UI show multiple duplicate rows

[SOLVED] [ strace sql ] Contacts Section of Company UI show multiple duplicate rows#4794

By KarlR - 29 Jul 2020, 07:51

- 29 Jul 2020, 07:51 #4794

Hello Everyone!

I'm 1/2 way through migrating 2.5 million rows Commercial ATS to OpenCats. Lots of fun !

One issue im facing is that the 'contacts' datagrid of the Company UI page is showing duplicate multiple rows FORALL assoc. contacts of that company.

I'm really struggling to get my head around the OC Lib/MOD stack.

I know the contacts datagrid is constructed via LINES: 296-404 of modules/companies/Show.tpl.

How to find the actual SQL that creates this DataGrid so i may "Re-create" the output in phpMyadmin or bash console via mysql command line, please so I can find the source of the duplicate rows.

Many thanks for any assistance in advance,
Karl

Attachments

contracts_grid.jpg (156.42 KiB) Viewed 4706 times

Last edited by KarlR on 29 Jul 2020, 07:58, edited 1 time in total.

Re: [ strace sql ] Contacts Section of Company UI show multiple duplicate rows#4795

By KarlR - 29 Jul 2020, 07:58

- 29 Jul 2020, 07:58 #4795

Silly me! I found the problem... duplicates on contacts table.

Apologies for any inconveniance.

Re: [SOLVED] [ strace sql ] Contacts Section of Company UI show multiple duplicate rows#4798

By RussH - 31 Jul 2020, 10:25

- 31 Jul 2020, 10:25 #4798

sorry Karl, took a while to check this thread. Glad you sorted it. Hope it's going well.. If you find any issues or propose any improvements please post them here - or on github.

RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Re: [SOLVED] [ strace sql ] Contacts Section of Company UI show multiple duplicate rows#4805

By KarlR - 05 Aug 2020, 07:31

- 05 Aug 2020, 07:31 #4805

Thanks @RussH .

Just a bad migration script on my end.