The number of video channels displayed by the client is inconsistent with that of the web side.

1、 problem description

**[Question 1]] **
The number of video channels displayed on the client is inconsistent with the number of video channels displayed on the web. The old version uses the vehicle information copy function to cause an exception.

**[Question 2]] **
Locate the terminal, display normal on the web side, and display "channel 1" on the client side"

2、 Solution

2.1 Solution One

Individual processing: edit vehicle information, click once to save, and the client will refresh the terminal list.
Batch processing: Execute database SQL statements and refresh the terminal list on the client.
1. Look for vehicle channel inconsistencies:

SELECT * FROM jt808_vehicle_info WHERE (LENGTH(ChnName)-  LENGTH(REPLACE(ChnName,',','')) 1)! = ChnCount && ChnName! = ''&& ChnName IS NOT NULL;

2. Repair vehicle channel inconsistency:

UPDATE 'jt808_vehicle_info' SET 'ChnCount'=(LENGTH(ChnName)-  LENGTH(REPLACE(ChnName,',','')) 1)
WHERE (LENGTH(ChnName)-  LENGTH(REPLACE(ChnName,',','')) 1)! = ChnCount && ChnName! = ''&& ChnName IS NOT NULL;

2.2 Solution One

Individual processing: edit vehicle information, click once to save, and the client will refresh the terminal list.
Batch processing: Execute database SQL statements and refresh the terminal list on the client.

UPDATE jt808_vehicle_info SET ChnCount=0 WHERE ChnCount! =0 AND ChnName= '';