NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Support Linux v
« Previous 1 … 3 4 5 6 7 … 34 Next »
No device listed -- error saving capture source: SQLite Error 1: 'no such column: −1'

 
  • 0 Vote(s) - 0 Average
No device listed -- error saving capture source: SQLite Error 1: 'no such column: −1'
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,753
Threads: 769
Joined: Nov 2003
#31
2024-04-12, 04:42 AM
Quote: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
Offline

Junior Member

Sweden
Posts: 21
Threads: 1
Joined: Apr 2024
#32
2024-04-12, 12:15 PM
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
Online

Posting Freak

Ontario Canada
Posts: 53,014
Threads: 956
Joined: May 2006
#33
2024-04-12, 01:12 PM
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
Offline

Junior Member

Sweden
Posts: 21
Threads: 1
Joined: Apr 2024
#34
2024-04-12, 03:54 PM
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
Online

Posting Freak

Ontario Canada
Posts: 53,014
Threads: 956
Joined: May 2006
#35
2024-04-12, 04:37 PM
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
Offline

Junior Member

Sweden
Posts: 21
Threads: 1
Joined: Apr 2024
#36
2024-04-12, 07:44 PM
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
Online

Posting Freak

Ontario Canada
Posts: 53,014
Threads: 956
Joined: May 2006
#37
2024-04-12, 08:23 PM
I can duplicate it! I wasn't setting the locale correctly with just the export.

Martin
skrottapple
Offline

Junior Member

Sweden
Posts: 21
Threads: 1
Joined: Apr 2024
#38
2024-04-12, 09:54 PM
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
Online

Posting Freak

Ontario Canada
Posts: 53,014
Threads: 956
Joined: May 2006
#39
2024-04-13, 01:10 AM (This post was last modified: 2024-04-13, 01:12 AM by 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
Offline

Junior Member

Sweden
Posts: 21
Threads: 1
Joined: Apr 2024
#40
2024-04-13, 11:41 AM
> 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.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)

Pages (5): « Previous 1 2 3 4 5 Next »


Possibly Related Threads…
Thread Author Replies Views Last Post
  [Failed: No errors, but no data delivered. This is usually because the device failed Bobthegoldfish 3 361 2024-11-29, 12:49 AM
Last Post: mvallevand
  Adaptec avc-3610 device not listed, but detected by OS tryingtomakeitwork 1 521 2024-04-10, 12:29 PM
Last Post: mvallevand
  Different Errors depending on channel (no tuner found/transcoding Error) idefixrc 3 854 2023-11-21, 12:45 PM
Last Post: mvallevand
  Nextpvr unaccessable from Jellyfin with 401 error Simonzzzz 5 1,343 2023-11-20, 10:28 AM
Last Post: Simonzzzz
  Recording length error VCR58 20 2,302 2023-11-12, 11:46 PM
Last Post: mvallevand
  IPTV device - reloading M3U amirlsm 28 10,428 2023-08-15, 09:51 AM
Last Post: mrnobody
  "Unexpected error scanning for other devices" BlackJack 2 798 2023-07-15, 03:03 PM
Last Post: BlackJack
  usb device doesn't appear in GUI j_yves 4 939 2023-05-29, 02:56 PM
Last Post: j_yves
  HTTP ERROR 500 PJosses 17 2,100 2023-02-16, 05:17 PM
Last Post: PJosses
  Device Scan isn't finding HDHR3-US Smithers 11 2,229 2022-09-27, 09:36 PM
Last Post: sub

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode