Posts by labzilla

I have some entries in MySQL where the file no longer exists. I used the clean database feature in Kodi, and the entries are still there.

I can select the file using

Quote

SELECT * FROM files RIGHT JOIN path ON path.idPath = files.idPath WHERE files.idPath = 372

I know I can use a select to delete table rows, but I'm getting an error.

When I run this in MyPHPAdmin, I see

Quote

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

I did a quick Google on the error message, and people are talking about a missing index, but both tables have a primary key. Plus I don't want to change table scheme. Any suggestions?

Like DaVu said copy LibreELEC-Generic.x86_64-7.0.2.img.gz into your Update folder. You can access this folder remotly from Windows File Explorer. What I did when I upgrade to OE on my Chromebox, don't really need to install from a USB stick.

Quote from nickr

MySQL error 101=network in unreachable.

This gave me the clue I needed. When I logged into kodi, I wan able to ping and ssh to my server, so my network was up.

I change LE to "Wait for network before starting kodi" didn't need this before. Once I set it everything was back up

Ping works fine, and I can connect to the MySQL server form my desktop using PHPMyAdmin. The server is ubuntu (LTS 16.04.1) it is running MySQL 5.7.13.

Is there anyway to test the MySQL connection from the command line?

I am not able to connect to my remote MySQL database running on an Ubuntu server

Quote

15:36:24 T:140117900314688 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.1.10' (101))

I can ping the server and when I telnet to port 3306, I get a response back

Quote

pmysql_native_password

I've been using MySQL for several months with no problems. I replaced my router today and all the systems on the network still have their old IP address. The user kodi has permission to connect from any host in MySQL.

Here is my advancedsettings.xml

Quote

<videodatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>

Display More

None of the changes I made to the settings on Kodi or the TV would correct the overscan issue. I decied to bite the bullet and do a fresh install. That worked great, 1080p videos played fine.

Once everything was set up to my liking I decided to check the Wiki for any tweaks to the Chromebox Chromebox - Official Kodi Wiki.

BOOM! my over scan issue was back. I discovered that System-->Settings-->Videos-->Playback: Adjust display refresh rate: is off by default. If it's set to anything else, I got the overscan problem.

My guess this was how it was before I upgrade to LE 7.0.1. Just thought I would report my findings for anyone else, thanks for your help.

Thanks, overscan, now I know the proper name. I'll play around with some of the settings on the TV. Though I'm not sure why upgrading from Isengard to Javis would require a settings change on the TV, I haven't changed anything on the TV since Frodo.

Quote from newphreak

Does not scale? Have you edited video settings? Try pushing "enter" on keyboard, or "ok" button on remote a few times.

I guess a better way to descibe it would be the picture over flows the TV's screen. The picture looks cropped, it's not the capture but how it actually looks on screen. On the bottom, the seek bar is almost completly hidden, and on the top movie information is also cropped.

Not too sure what hitting 'Ok' is supposed to do, it just pauses the movie. I have Kore remote also.

Not sure why the video settings would change after the upgrade. I did a reset of the video settings. Not too sure what else to try.

Thanks for the response & assistance.

I upgraded to LE from OE without any issues, I was worried about upgrading form a slightly different OS, but nothing blew up. Good work LE team.

After the upgrade my 1080p content is not scaled down to match the scrren resolution of my 720p TV. There is nothing in settings, at least that I could find, that will correct this. 720p and 540p videos play correctly. The 540p video correctly scale up as you would expect. Any suggestions?