From 15cb813200bf0bfb9062d85633fecf5a342c2d6e Mon Sep 17 00:00:00 2001
From: gn64_jp <gn64_jp@4e526526-5e11-4fc0-8910-f8fd03428081>
Date: Fri, 4 Feb 2011 06:13:51 +0000
Subject: [PATCH] fix bugs in 0.9.9.

git-svn-id: svn+ssh://svn.sourceforge.jp/svnroot/rec10@826 4e526526-5e11-4fc0-8910-f8fd03428081
---
 rec10/trunk/src/dbMySQL.py | 21 ++++++++++++---------
 rec10/trunk/src/tester.py  |  4 ++--
 2 files changed, 14 insertions(+), 11 deletions(-)

diff --git a/rec10/trunk/src/dbMySQL.py b/rec10/trunk/src/dbMySQL.py
index a585bb0..437075d 100644
--- a/rec10/trunk/src/dbMySQL.py
+++ b/rec10/trunk/src/dbMySQL.py
@@ -726,7 +726,7 @@ class DB_MySQL:
         dbexe = db[1].execute("\
         SELECT keyword,auto,opt \
         FROM in_auto_jbk_key \
-        ")
+vim         ")
         ret = []
         if dbexe > 0:
             ret = db[1].fetchall()
@@ -1202,15 +1202,18 @@ class DB_MySQL:
         UPDATE timeline INNER JOIN epg_ch ON timeline.chtxt=epg_ch.chtxt SET timeline.chtxt=CONCAT('BS_',epg_ch.ch) WHERE substring(epg_ch.bctype,1,2) = 'bs'")
         db[1].execute("\
         UPDATE timeline INNER JOIN epg_ch ON timeline.chtxt=epg_ch.chtxt SET timeline.chtxt=CONCAT('CS_',epg_ch.csch) WHERE substring(epg_ch.bctype,1,2) = 'cs'")
+        try:
+            db[1].execute("\
+            ALTER TABLE epg_ch DROP ontv")
+        except:
+            ""
         db[1].execute("\
-        ALTER TABLE epg_ch DROP ontv")
-        db[1].execute("\
-        ALTER TABLE epg_ch ADD logo0 BLOG,\
-        ADD logo1 BLOG,\
-        ADD logo2 BLOG,\
-        ADD logo3 BLOG,\
-        ADD logo4 BLOG,\
-        ADD logo5 BLOG,\
+        ALTER TABLE epg_ch ADD logo0 BLOB,\
+        ADD logo1 BLOB,\
+        ADD logo2 BLOB,\
+        ADD logo3 BLOB,\
+        ADD logo4 BLOB,\
+        ADD logo5 BLOB\
         ")
         db[1].execute("\
         ALTER TABLE in_auto_jbk_key ADD auto TINYINT DEFAULT 0")
diff --git a/rec10/trunk/src/tester.py b/rec10/trunk/src/tester.py
index 02b3dff..7d11f8c 100644
--- a/rec10/trunk/src/tester.py
+++ b/rec10/trunk/src/tester.py
@@ -1,10 +1,10 @@
-import tv2ts
 #!/usr/bin/python
 # coding: UTF-8
 # Rec10 TS Recording Tools
 # Copyright (C) 2009-2011 Yukikaze
 #import sys
 import epgdb
+import tv2ts
 import os
 import time
 import tv2avi
@@ -44,4 +44,4 @@ recpath = "/home/ftpusr/ftp-tmp/Recording/"
 ftpusr = "/home/ftpusr/ftp-tmp"
 recordedpath = u"/home/ftpusr/ftp-video"
 if __name__ == "__main__":
-    ""
\ No newline at end of file
+    rec10d.rec10db.update_db_98to100()
\ No newline at end of file
-- 
2.11.0