[mythtv-users] !!NoTrans: SQL Error: Table

[Hika van den Hoven]

Hoi Dick,

Tuesday, December 13, 2016, 1:00:06 AM, you wrote:

> On 12/12/2016 03:48 PM, Hika van den Hoven wrote:
>>
>>> Try running it from the home directory and just to make sure create
>>> that mythconverg directory there before you run it. Also check what
>>> temp directory is set in my.conf. It should be set to /tmp or
>>> /var/tmp. The variable is tmpdir so:
>>> tmpdir = /tmp/

> I find /etc/mysql/my.cnf, and it has

> tmpdir          = /tmp


>>> Oh and if you create that mythconverg directory create rw rights to
>>> the world in there.

> drwxrwxrwx  2 rsteff rsteff     4096 Dec 12 15:43 mythconverg


mysql>> repair table program;
> +---------------------+--------+----------+--------------------------------------------------------+
> | Table               | Op     | Msg_type | 
> Msg_text                                               |
> +---------------------+--------+----------+--------------------------------------------------------+
> | mythconverg.program | repair | error    | Can't create new tempfile:
> './mythconverg/program.TMD' |
> | mythconverg.program | repair | status   | Operation 
> failed                                       |
> +---------------------+--------+----------+--------------------------------------------------------+
> 2 rows in set (0.00 sec)

Does that file exist in /var/lib/mysql/mythconverg ? If so, can you
delete. But you first should stop both mysql and any program using it
like your backend and then restart it.


Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens