Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




403 posts

Ultimate Geek


#215370 24-Jun-2017 16:08
Send private message

Hi all,

 

I am not sure what happened or how - could have been an update or some other thing? - but all of the sudden I lost the capability to DELETE recorded tv. I can record just fine, everything works OK but when I try to delete a recorded tv show from MP interface, it is "thinking" for 3-4 seconds and then tells me that "could not delete this file". I have checked the folder properties and none of the files are marked "read only".

 

The problem is the HDD is filling up. I can use explorer and delete recorded shows but after that (as expected) they are still shown in the list of recorded tv. I have tried to update that list through the "import" function in the setup but it did not make any changes. Looking through the Recoded Tv folder with explorer, I even found very old recordings which MP would not show in the list.

 

Do I need to go through clean re-install of Media Portal? I believe there is a database file somewhere which if you delete, it will be created at next start-up as the system cannot work without it. Which file is this - and where is it located? It would be so much easier than going through all the settings for the various codecs, etc to get good picture.

 

The "videos" folder works OK, I can delete files and folders in there from MP interface - no errors at all. These two folders however, are located on two separate physical HDDs. There is no error from the HDDs, they are in good condition.

 

 

 

Any idea is much appreciated. The recorded tv list looks really messy after a couple of months of manually deleting files in there...

 

Thank you.





mobo Intel DH55PJ, RAM: 4GB RAM, Nova-T 500 HD + Avermedia Trinity tuner card, Geforce 520 video, 120GB SSD Sandisk + 640 WD + 1000SG, Win7 Home Prem 64-bit, Media Portal 1.15.0; BTC 9019URF Cordless Keyboard, Panasonic 55" (HDMI cable), HTPC Case Silverstone Grandia GD05B.


Create new topic
560 posts

Ultimate Geek


  #1806219 24-Jun-2017 21:24
Send private message

Have you checked the logs for error messages?  Also, when MP has gone strange on me in the past, I have had to run a full check and repair on the database.  That is easy enough to do if you are using MySQL.




403 posts

Ultimate Geek


  #1806332 25-Jun-2017 11:19
Send private message

yes... repairing of the database... this is what I am trying to do, I hope this will help.

 

I have tried this, but with no result:

 

https://www.team-mediaportal.com/wiki/display/MediaPortal1/Repairing+database+-+MySQL

 

Is there another way, please?

 

 

 

It says in the instructions that "mysqlcheck must be used when the mysqld server is running" but there is no service called mysqld running... I identified it in the MySQL folder and double -clicked it but nothing happened (it did not show up in the list of running services)...





mobo Intel DH55PJ, RAM: 4GB RAM, Nova-T 500 HD + Avermedia Trinity tuner card, Geforce 520 video, 120GB SSD Sandisk + 640 WD + 1000SG, Win7 Home Prem 64-bit, Media Portal 1.15.0; BTC 9019URF Cordless Keyboard, Panasonic 55" (HDMI cable), HTPC Case Silverstone Grandia GD05B.


 
 
 
 


4434 posts

Uber Geek

Lifetime subscriber

  #1806340 25-Jun-2017 11:40
Send private message

I generally manually delete files using explorer then in the TVServer-Configuration go to Recording - Database Import and select "Remove invalid entries". Is that what you meant by the 'import' function?
I must admit I'm still running version 1.11. but it ain't broke, so I'm not fixing it.




Areas of Geek interest: Home Theatre, HTPC, Android Tablets & Phones, iProducts.

560 posts

Ultimate Geek


  #1806644 25-Jun-2017 22:30
Send private message

It is possible to install MediaPortal to use other SQL servers than MySQL.  So if you did that, you would need to look up the instructions for doing a database repair for that software.

 

If you are using MySQL, then Windows Task Manager should show mysqld.exe in its Processes tab when MySQL is running.  On Win 7 from Start > Administrative Tools > Services you should find MySQL listed as a service and find out if its running status from there also.  From Windows Task Manager if you right click on the mysqld.exe entry and select "Open File Location", you will find the directory where your running version of MySQL is installed.  It may be a later version than the one in those instructions and be in a slightly different directory.  From a command prompt, go to that directory and run:

 

mysqlcheck mptvdb --auto-repair -e -u root -p

 

I do not know why the MediaPortal Wiki has screwed up the formatting of the command, but if you just cut and paste what is on that page it will not work properly.  You will need to enter the database password for the command to work - if you have not changed it it should be "MediaPortal" (case matters).


Create new topic



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

National Institute for Health Innovation develops treatment app for gambling
Posted 6-Jul-2020 16:25


Nokia 2.3 to be available in New Zealand
Posted 6-Jul-2020 12:30


Menulog change colours as parent company merges with Dutch food delivery service
Posted 2-Jul-2020 07:53


Techweek2020 goes digital to make it easier for Kiwis to connect and learn
Posted 2-Jul-2020 07:48


Catalyst Cloud launches new Solutions Hub to support their kiwi Partners and Customers
Posted 2-Jul-2020 07:44


Microsoft to help New Zealand job seekers acquire new digital skills needed for the COVID-19 economy
Posted 2-Jul-2020 07:41


Hewlett Packard Enterprise introduces new HPE GreenLake cloud services
Posted 24-Jun-2020 08:07


New cloud data protection services from Hewlett Packard Enterprise
Posted 24-Jun-2020 07:58


Hewlett Packard Enterprise unveils HPE Ezmeral, new software portfolio and brand
Posted 24-Jun-2020 07:10


Apple reveals new developer technologies to foster the next generation of apps
Posted 23-Jun-2020 15:30


Poly introduces solutions for Microsoft Teams Rooms
Posted 23-Jun-2020 15:14


Lenovo launches new ThinkPad P Series mobile workstations
Posted 23-Jun-2020 09:17


Lenovo brings Linux certification to ThinkPad and ThinkStation Workstation portfolio
Posted 23-Jun-2020 08:56


Apple introduces new features for iPhone iOS14 and iPadOS 14
Posted 23-Jun-2020 08:28


Apple announces Mac transition to Apple silicon
Posted 23-Jun-2020 08:18



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.