No device listed -- error saving capture source: SQLite Error 1: 'no such column: −1'

[sub]

If in fact GetOrdinal is generating the offending column index that's being used (that's what I gathered from your description), then shouldn't the calls to it be a critical part of the code to be examined? I can't spot any calls to it at least.

NextPVR is not calling it itself. The stack trace indicates that Microsoft's SQLite data libraries are calling it somewhere within their implementation of ExecuteNonQuery(). We don't have any visibility of what they're doing inside that call.

Honestly though, since you're the only person to ever report this, over ten's of thousands of downloads, I suspect it's not an application issue, but something like conflicting OS package versions or permissions, and it's just reporting in an unexpected way.

Code:

2024-04-12 04:23:50.138    [ERROR][24]    Unexpected error saving capture source: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such column: −1'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at NShared.Visible.CaptureSource.Save()

Got any other Linux machines around you can try it on?

[skrottapple]

Okay, I can't for the life of me see what part of the stacktrace reveals this, so I'll take your word for it.

I can maybe try on other machines. Can't do it right now though.

[mvallevand]

NextPVR will create an insert string like the one I gave you to use with sqlite3 and sends it to ExecuteNonQuery() as sub showed here https://forums.nextpvr.com/showthread.ph...#pid590582 The stack trace shows it going through the internal C# steps that the library not NextPVR calls. Either the string is bad and we'd expect more than one report if that is the case or one of the library steps is failing.

If the table was truly missing a column then the sqlite3 insert would failed for the same reason. The fact that NextPVR loads the table to show you the IPTV device confirms also confirms the table is complete.

Martin

[skrottapple]

Thank you for the explanation. I understand that part. I was pointing out that since "GetOrdinal" is not itself present in the stacktrace, I (as a non-C# dev) can't see any indication in the stacktrace that "getOrdinal" is being called by "ExecuteNonQuery" or its subroutines. I'm perfectly willing to accept that that is obvious to you who are more experienced, but I personally can't see it and so I can't follow along in your reasoning (which is fine).

> Either the string is bad and we'd expect more than one report

Ok, that's a conclusion that I'll take your word for. I personally can't see how that string is being generated because I can't tell how the constituent variables are being assigned from the code snippet that was posted. If, for example, any part of that chain is locale sensitive then I certainly couldn't tell what would happen or to how many.

Like you, I have no doubt that the database has all the columns that it intends to have, after your inspection. I've always imagined that the query is erroneously asking it for something impossible.

I don't want this to sound like I expect you to explain all your reasoning to me, but I appreciate hearing it if you're willing. I'm just struggling to follow along at the moment.

Anyway, I tested this on another machine: same result. You can count that as a second report if you want :-)

So, what's common between the machines?
- Laptops (1x macbook, 1x pc)
- 8 GB ram
- Ubuntu 23.10
- Swedish locale
- Same network
- Same era (both have Intel i5 with hd graphics 4000)
- both run wayland

I'm willing to provide additional info if you still suspect package versions and permissions.

[mvallevand]

Testing on Ubuntu 23.10 here on one machine which I used for a while 12GB newer graphics but graphics aren't involved at this point.

added this to the startup

export LANG=sv_SE

it adds a digital device fine

2024-04-12 12:25:01.678 [DEBUG][1] adapter0/frontend0
2024-04-12 12:25:01.678 [DEBUG][1] adapter0/frontend0
2024-04-12 12:25:01.710 [DEBUG][1] Added new device 'adapter0/frontend0 (LG Electronics LGDT3306A VSB/QAM Frontend)'
2024-04-12 12:25:01.733 [DEBUG][1] Added new device 'adapter0/frontend0 (LG Electronics LGDT3306A VSB/QAM Frontend)

Since you get the error without the DVB card then it won't be the name, as it is only adding the IPTV device and you said that didn't work.

Still you can check to make sure NextPVR is grabbing the correct device name with

sudo dmesg | grep dvb

mine shows

[ 8365.609369] dvbdev: dvb_create_media_entity: media entity 'LG Electronics LGDT3306A VSB/QAM Frontend' registered.

Martin

[skrottapple]

I'm fine with just getting the same error with the built-in IPTV device. The tv card wasn't involved in testing on the second machine.

[mvallevand]

I can duplicate it! I wasn't setting the locale correctly with just the export.

Martin

[skrottapple]

I thought you would. You seem persistent, and, judging by your post count, very patient.

Yes, one environment variable for locale didn't seem quite enough — last time I looked there were a whole bunch of them...or maybe you just needed to do it somewhere else?

Well, I'll await your diagnosis. I think it'll be interesting.

[mvallevand]

Once you reported it not working on a second machine that was enough to get me interested.

The problem has something to do with initializing a negative value for the CAPTURE_SOURCE table it might be related to the fix for this specific problem in Sweden https://github.com/dotnet/runtime/issues/44678

Sub has a workaround for the next version but for now can you run sudo nano /etc/nextpvr-server.conf and make the file look like this.

Code:

NEXTPVR_DATADIR_USERDATA=/var/opt/nextpvr/
LC_MESSAGES=POSIX
LANG=sv_SE.UTF-8

After saving restart nextpvr-server and let us know how it goes.

Martin

[skrottapple]

> The problem has something to do with initializing a negative value

Ok, so, back to my first post in other words?

Sounds like, if there's a fix, that sub already has the juicy details. I'll await their verdict then.