Reply to thread

Message

<blockquote data-quote="bigguy333" data-source="post: 259950" data-attributes="member: 71725">Ok here is my script for MYSQL.&nbsp; At least that is the database that I am using, I have no idea what the database looks like for mssql.&nbsp; First off USE THIS AT YOUR OWN RISK, you may get a corrupt database after you run this and have to reinstall the sql database. Ok there is the formal warning <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /> before you even start disable the SD plugin. (just un-check it from the plugins from tvserver)1. you will need to install mysql tools which can be found here: hxxp://dev.mysql.com/downloads/gui-tools/2.&nbsp; you will need to erase the tvlibrary (this will erase all your tv settings, channels, and guide.)&nbsp; Do this by opening MySQL Administrator, enter your information for your database, then click catalogs then right click tvlibrary and click drop schema.&nbsp; You now have a fresh plate.3. Restart the tvservice (it should recreate the tvlibrary).4. load tv-server configuration, and rescan for your channels... again make sure the SD plugin is not enabled.5.&nbsp; when the scan is complete run MySQL Administrator click tools, and then MySQL Query Browser.6.&nbsp; click file, then open script.&nbsp; Select my sql file and click ok.7.&nbsp; It should open up the script, it has 21 entries.&nbsp; click execute.&nbsp; Cross your fingers, hopefully you will not see any errors.8.&nbsp; You are done, I would restart the tvservice once more then you can now enable the SD plugin and let it update the channels.&nbsp; I hope this works out for you, let me know.&nbsp; Also make sure the Automatically add new digital cable/satellite channels is turned off. after I turned the SD plugin on I restarted the tvservice... I don't know if this is required, but I did it.</blockquote>

[QUOTE="bigguy333, post: 259950, member: 71725"] Ok here is my script for [B][U]MYSQL[/U][/B]. At least that is the database that I am using, I have no idea what the database looks like for mssql. First off USE THIS AT YOUR OWN RISK, you may get a corrupt database after you run this and have to reinstall the sql database. Ok there is the formal warning ;) before you even start disable the SD plugin. (just un-check it from the plugins from tvserver) 1. you will need to install mysql tools which can be found here: hxxp://dev.mysql.com/downloads/gui-tools/ 2. you will need to erase the tvlibrary (this will erase all your tv settings, channels, and guide.) Do this by opening MySQL Administrator, enter your information for your database, then click catalogs then right click tvlibrary and click drop schema. You now have a fresh plate. 3. Restart the tvservice (it should recreate the tvlibrary). 4. load tv-server configuration, and rescan for your channels... again make sure the SD plugin is not enabled. 5. when the scan is complete run MySQL Administrator click tools, and then MySQL Query Browser. 6. click file, then open script. Select my sql file and click ok. 7. It should open up the script, it has 21 entries. click execute. Cross your fingers, hopefully you will not see any errors. 8. You are done, I would restart the tvservice once more then you can now enable the SD plugin and let it update the channels. I hope this works out for you, let me know. Also make sure the Automatically add new digital cable/satellite channels is turned off. after I turned the SD plugin on I restarted the tvservice... I don't know if this is required, but I did it. [/QUOTE]

Verification