Mythtv stopped recording. Time format issues? "0000-00-00 00:00:00"

[Hans66 <hans66@…>]

Setup

• Debian Squeeze
• Mythtv backend + mythweb 0.24.2-0.0squeeze1
• Sourced from deb ​http://www.debian-multimedia.org squeeze main

Last week recording stopped. When I record a new program, is is added to recording schedule with time 0000-00-00 00:00:00 (MythWeb)

I did do my regular Debian updates; I think that PHP got updated. Not sure if that is related.

[Hans66 <hans66@…>]

screenshot of recording schedule showing 0000-00-00 00:00:00

[Hans66 <hans66@…>]

Hmm, I noticed also the following errors in Mythweb "upcoming" Warning at /usr/share/mythtv/mythweb/modules/tv/upcoming.php, line 95: !NoTrans: Invalid argument supplied for foreach()!! Warning at /usr/share/mythtv/mythweb/modules/_shared/tmpl/default/header.php, line 16: !NoTrans: Cannot modify header information - headers already sent by (output started at /usr/share/mythtv/mythweb/includes/errors.php:150)!!

Applying the fixes mentioned in ticket 10142 makes the errors go away, but not the recording issues. Recording are still scheduled with LastRecorded? "0000-00-00 00:00:00"

[Hans66 <hans66@…>]

I did a complete new "install" of the mysql database (delete/create, start from scratch). I still have the php errors. This specific mythtv version is already running for a while. Issues are caused by the debian php update from squeeze8(?) to squeeze9. I can only revert to squeeze3 for php. Should I try this?

[Hans66 <hans66@…>]

Please reject defect. I resolved it myself. Somehow I changed the ownership from mysql db mythconverg from mysql.mysql to mysql.adm. This gives following error (see below)...very hard to trace back to mysql ownership issue. (to be honest..I don't understand why it happens, the database is owned by mysql; the group mysql does not have additional members)

Query was: CREATE TEMPORARY TABLE sched_temp_record LIKE record; Driver error was [2/1004]: QMYSQL3: Unable to execute statement Database error was: Can't create file '/tmp/#sql6607_1ce_0.frm' (errno: 9)