Posts by LybsterKodi

Over many years I've found three main causes of database table corruption:

1. power going off whilst the database is being written to (could also be sudden loss of network connection)

2. badly formatted data being written

3. unacceptable characters

There's also hard drive sectors going duff.

No. 1 you'd probably notice

Nos. 2 & 3 are a bit more difficult but, as chewitt infers, could be being caused by a poorly written add-on but there's probably no way you can test No. 2

No. 3 you can check if you can download an SQlite browser but you need to be at least a bit of a techie. Have a look for "DB Browser for SQLite" on the web - its got an integrity check.

I've come to the conclusion that the RPi4 (running LibreELEC-RPi4.aarch64-12.0-nightly-20230520) will not do what I want - record 2 programmes using my Hauppage tuner whist watching a movie. I've tried several approaches (eg record to SD card, record to USB HDD, force_turbo=1) and I get varied effects (eg audio lost, freezing, video speed up, loss of sync between audio & video) so I've decided I need to buy a more powerful machine.

I've found the Intel page which tells me which NUCs support CEC but I can't find anything which tells me about other machines. Since other machines are generally at a lower price point than Intel I'd like to be able to consider them. Does anyone know a resource which I can use to see if a machine supports CEC before I buy it?

If your Kodi machine is on a LAN and you've enabled SAMBA you should be able to use samba from the Windows 7 pc to transfer files. I currently have 2 RPI3Bs (one for TVHeadend and the other for videos) running LE9.2.8 and I can access the 6TB NTFS HDD using samba and the portion of the microSD card that is EXT4 formatted (eg Recordings).

I'm in the process of moving to an RPi4 and did have a bit of trouble with samba on version 11 and had to use FileZilla which worked fine. My latest experiments with the v12 nightly also work fine with samba.

I have two RPI3Bs running LE9.2.8 and they're fine.

You don't say what you're trying to boot from MicroSD card or USB drive. If the former then it may simply be the SD card isn't seated properly. If the latter then, if my memory is right, the earlier firmware on the Pi doesn't support booting from USB drive. I seem to recall a patch somewhere on this site which tells you which of the config files to alter but my suggestion would be to get a cheapo small microSD card, burn LibreElec onto that and use it to boot from.

It may be possible, once you've booted the machine, to download the latest firmware which will allow booting from USB drive, no guarantees.

Thanks, I'll add that to my list of machines to look at

Some of them do, and I have found a list of the ones Intel say do. They're the most expensive option (even 2nd hand) out of the micro PC market. I'm hoping some of the others will be suitable but can't find anything to help me work out which ones are.

I've currently got RPi3, and RPi4 and I'm currently thinking of buying a different device but I want it to support CEC. I've spent several hours googling and managed to confuse myself more but cannot find anywhere either a list of what does or any way of finding out after buying.

I know I can buy Pulse-Eight kit to achieve it but I'd like it built in.

Can anyone point me in the right direction.

The whole point of moving to the RPi4 was to simplify my rats nest of 2 x RPi3Bs (1 for TVHeadend sever and 1 as client/video playback) which meant extra extension leads, a mini hub for ethernet connection etc.

Thanks - I now have a nice smooth playback. I copied the display settings from the RPi3 - 1920x1080. Why they are that I have no idea since the TV is 3480x2160 but it works so I'm leaving it alone.

Next stage - how to test out my Hauppage & TVHeadend when I don't have a spare adapter - I shall have to negotiate to not recording stuff

I'll give that a try

Is there a better description of what whitelist does. I found the wiki and its left me baffled.

<<Obvious question is what is the framerate of the video.>>

If I'm interpretting the ctrl-shift-o display correctly fr: 25

<<Do you have "adjust display refresh rate to match video" enabled.>>

It was set off, I changed it to always but it didn't seem to make a difference.

I then thought what happens if I set the display rate to 25fps and its almost perfect. I reset the refresh rate to 30 and rebooted but still jerky. Blundering about the wiki I manage to track down the entry for this and it says always isn't recommended - which of the two remaining is the best choice?

<<A debug log would help.>>

I can dig out one for the RPi3 & the RPi4. Is there a quick way of turning it on and off or do I have to go through the menu each time.

<<Obvious question is what is the framerate of the video.>>

No idea, but 1) exactly the same as when played on the RPi3 and 2) pretty much the same as all of my videos since they have all been through Handbrake with the same settings.

<<Do you have "adjust display refresh rate to match video" enabled.>>

I don't think so but I'll have a look and if not set it. Since the RPi3 is my daily driver and its easy I just had a look and its set to always. I'll be back after fighting with cables

<<Does the BENQ monitor support that framerate?>>

Immaterial. The BENQ 21" was only being used until I was reasonably happy with the RPi4 running LE12 and I didn't look to closely. Its when I try it on the 40" Panasonic and look closely that the problem emerges. There are other issues which I didn't care about/notice on the BENQ monitor that I do care about on the TV, one of which I've posted about.

Quote from gamb00ler

The only volume setting I have found in my KODI install seems to only control the volume of GUI sounds.

The volume setting is the one associated with the device you are running Kodi on. eg I run Kodi on an RPi3 and have a wifi keyboard attached. That's what I use to set the volume level for the RPi to 100%.

As popcornmix said set that to 100% and use the TV remote for other adjustments

I'm doing the initial testing of my RPi4 using a BENQ monitor since it was to disruptive using the TV (Panasonic) and it was looking worth checking out on the TV so moved it and connected everything up.

I wanted to compare the picture quality with what I get from the RPi3 running LE9.2.8. If I didn't have that as a comparison I'd probably be happy with the RPi4. I used "Looper" to test with. About 2:30 in there's a bit where a tractor is pulling a large yellow trailer along a dirt road. On the RPi3 (or my PC using VLC) its nice and smooth. With the RPi4 its a little jerky. Its not enough to stop me watching but it is enough for my brain to think something's wrong. I've tried turning off deinterlacing with no discernible difference.

Is there another setting I should be trying or do I need to bite the bullet and buy different equipment?

I moved the RPi4 and gear to attach to my Panasonic to continue picture testing (separate post about this) and it turns the TV on and switches to HDMI3 but gets no further than the message showing the build in the top left corner of the TV screen. Turn the Pi off & on again and it comes up properly.

Is this expected?

Dude! I've been trying since October 2021.

At least you've saved me from spending on a UPS - thanks.

Locally - hmmm - Scottish Highlands - we don't do locally.

Joking aside thanks for the tips

If I may a couple of extra questions

1. does it turn the TV on and select the appropriate HDMI AV like the RPi?

2. does the TV remote work with it?

Please don't take this the wrong way (especially the development team) but its nice to see others are having the same problem - misery loves company <G>