Reply to thread

Message

<blockquote data-quote="milagroso" data-source="post: 184295" data-attributes="member: 51371">Hello Sparkleknas,I'll do my very best. I'll try to translate the german menu entries to english ones... If You have questions, just ask back.1. I'll assume You use the MySQL database2. Start the MySQl Administrator, login with the account You created during installation.2a. If You know how and are as paranoid as me - make a backup of Your database... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /> 3. Goto 'Catalogs', select the the scheme 'tvlibrary'. This will display all database tables which are used my TV Server (cuurently 28).4. Right click on the table named 'program', select 'edit data'. A new window opens displaying all records of the table. Each record corresponds one tv program. This window also displays the SQL command which displays the data (SELECT * FROM...).5. In the SQL field enter this command: [CODE]delete FROM `tvlibrary`.`program`[/CODE](Quite easy - just replace 'select *' by 'delete')6. You now have deleted all records whithout deleting the table itself.7. Trigger a reimport of the xmltv plugin. This should refill the table with fresh data.As I said I have no real explanation why this helped. I assume that in the 'old' database there are double records for the same tv program. This resulted probably from a upgrade to a newer svn.Hope it works for U2.</blockquote>

[QUOTE="milagroso, post: 184295, member: 51371"] Hello Sparkleknas, I'll do my very best. I'll try to translate the german menu entries to english ones... If You have questions, just ask back. 1. I'll assume You use the MySQL database 2. Start the MySQl Administrator, login with the account You created during installation. 2a. If You know how and are as paranoid as me - make a backup of Your database... ;) 3. Goto 'Catalogs', select the the scheme 'tvlibrary'. This will display all database tables which are used my TV Server (cuurently 28). 4. Right click on the table named 'program', select 'edit data'. A new window opens displaying all records of the table. Each record corresponds one tv program. This window also displays the SQL command which displays the data (SELECT * FROM...). 5. In the SQL field enter this command: [CODE]delete FROM `tvlibrary`.`program`[/CODE] (Quite easy - just replace 'select *' by 'delete') 6. You now have deleted all records whithout deleting the table itself. 7. Trigger a reimport of the xmltv plugin. This should refill the table with fresh data. As I said I have no real explanation why this helped. I assume that in the 'old' database there are double records for the same tv program. This resulted probably from a upgrade to a newer svn. Hope it works for U2. [/QUOTE]

Verification