[mythtv-users] python

[John Pilkington]

On 24/02/15 13:43, Hika van den Hoven wrote:
> Hoi Hika,
>
> Tuesday, February 24, 2015, 2:33:16 PM, you wrote:
>
>> Hoi Hika,
>
>> Tuesday, February 24, 2015, 2:29:43 PM, you wrote:
>
>>> Hoi James,
>
>>> Tuesday, February 24, 2015, 1:34:29 PM, you wrote:
>
>>>> Hi
>>>> if anybody has walked this road and has any advice then please …
>>>> I’m trying to build a dvd on my suse backend machine.
>>>> After finding a few python modules I got stuck. Clearly python cannot access the DB
>
>>>> Traceback (most recent call last):
>>>>    File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py", line 5298, in <module>
>>>>      main()
>>>>    File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py", line 5165, in main
>>>>      defaultsettings = getDefaultParametersFromMythTVDB()
>>>>    File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",
>>>> line 883, in getDefaultParametersFromMythTVDB
>>>>      cursor.execute(sqlstatement, configHostname)
>>>>    File "/usr/lib/python2.7/site-packages/MythTV/_conn_mysqldb.py", line 71, in execute
>>>>      raise MythDBError(MythDBError.DB_RAW, e.args)
>>>> MythTV.exceptions.MythDBError: MySQL error: not all arguments
>>>> converted during string formatting
>
>>>> Thanks anyone
>>>> James
>>>> _______________________________________________
>
>>> The error probably means it's missing a variable.
>>> The last line in /_conn_mysqldb.py is an error handler.
>>> Line 883 in mythburn.py is the execution of an sql statment. My guess
>>> is configHostname is invalid, so look at ~/.mythtv/config.xml for your
>>> hostname definition.
>
>
>>> Tot mails,
>>>    Hika                            mailto:hikavdh at gmail.com
>
>> Looked a bit further:
>> configHostname = DB.gethostname()
>> So maybe an invalid hostname in your database
>
>> Tot mails,
>>    Hika Alina Maria van den Hoven                            mailto:hikavdh at gmail.com
>
> Just before the exception it logged the query that gave the error.
>          self.log_query(query, args)
> So check the log.
>
> Tot mails,
>    Hika                            mailto:hikavdh at gmail.com

... and/or you might find similarities with

https://code.mythtv.org/trac/ticket/12268 (and #12260)