scte65scan sql table error

[Glb1945]

The sql table was generated, but mysql chokes on it with the error meaasge:

ERROR 1406 (22001) at line 168: Data too long for column 'callsign' at row 1

Here is line 168:

INSERT INTO channel SET mplexid=1015,serviceid=1,freqid=2,chanid=1002,sourceid=1,channum='2',callsign='KWGNDT_12913_KWGNDT(KWGNDT)(CW)';

It appears to me that the call sign field contains too many characters? How can I fix that?

Jerry

[pgbennett]

I am surprised that anybody can still use sctescan. I thought that since comcast encrypted everything a couple of years ago, that sctescan became useless. Who is your provider?

As far as the error is concerned, can you edit the sql before in goes into mysql and shorten the callsign? It is bogus anyway, should be just KWGN, not that long repetitive thing.

[Glb1945]

There is so much confusing and contradictory info on the mythtv wiki. It needs to be brought up to date so user don't go down dead ends!

Jerry

[Glb1945]

Found in mythtv wiki:

Myth Setup Ordering

Within mythtv-setup create the tuner cards and grabbers but don't do the "connections" yet
run scte65scan as described below
fill the database with the results
Go back to mythtv-setup and create the connections and set the starting channel to a valid channel

Misleading to say the least.

Jerry

[pgbennett]

Please let us know what is incorrect, misleading or confusing. Better still, apply for a user id and help us all by updating the wiki.

[Steve Goodey]

Unfortunately, due to spammers, wiki registrations are disabled at the moment. But that can be changed if you'd like an account.