[mythtv] a MySQL problem (was: Ticket #12259: Unable to play recordings on my TV set (Philips 32PFL5007K/12 TV))

[Janusz S. Bien]

Quote/Cytat - "Janusz S. Bien" <jsbien at mimuw.edu.pl> (Tue 30 Sep 2014  
04:28:55 PM CEST):

> Quote/Cytat - Tom Lichti <tom at redpepperracing.com> (Tue 30 Sep 2014  
> 02:42:04 PM CEST):
>
>
>> If you've completely removed (dropped) the database, the above won't do
>> anything.  If you installed from source, then run:
>>
>> mysql -u mythtv -p < /path/to/mythtv/src/mythtv/database/mc.sql

I've looked into mc.sql and the script has to be run by the mysql admin.

So I ended now with the following messages:

2014-09-30 21:36:41.104465 E  Error preparing query: SELECT DISTINCT  
dirname FROM storagegroup WHERE groupname = :GROUP AND hostname =  
:HOSTNAME
2014-09-30 21:36:41.104518 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2014-09-30 21:36:41.107742 E  DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND  
hostname = :HOSTNAME
Bindings were:
:GROUP="Themes", :HOSTNAME="sid4OCR"
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that  
corresponds to your MySQL server version for the right syntax to use  
near ':GROUP AND hostname = :HOSTNAME' at line 1

2014-09-30 21:36:41.117747 N  Inserting MythTV initial database information.
2014-09-30 21:36:41.117957 C  Upgrading to MythTV schema version 1307

and later the old problem of failing to upgrade the database to 1331 :-(

Best regards

Janusz


-- 
Prof. dr hab. Janusz S. Bień -  Uniwersytet Warszawski (Katedra  
Lingwistyki Formalnej)
Prof. Janusz S. Bień - University of Warsaw (Formal Linguistics Department)
jsbien at uw.edu.pl, jsbien at mimuw.edu.pl, http://fleksem.klf.uw.edu.pl/~jsbien/