Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#13098 closed Bug Report - General (Duplicate)

Time format error when scheduling recording thru mythweb

Reported by: kmpatel@… Owned by: stuartm
Priority: minor Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords: sql, mythweb
Cc: Ticket locked: no

Description

When I make any recording schedule change (add or change) thru mythweb, I get below error. 

    errornum:  256
  error type:  User Error
error string:  !!NoTrans: SQL Error: Incorrect datetime value: '00:00:00' for column 'next_record' at row 1 [#1292]!!
    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
  error line:  98

mythweb:
  Installed: 2:0.28.0+fixes.20160413.15cf421-0ubuntu2.16.04.1
  Candidate: 2:0.28.0+fixes.20160413.15cf421-0ubuntu2.16.04.1
  Version table:
 *** 2:0.28.0+fixes.20160413.15cf421-0ubuntu2.16.04.1 500
        500 http://us.archive.ubuntu.com/ubuntu xenial-updates/multiverse amd64 Packages
        500 http://us.archive.ubuntu.com/ubuntu xenial-updates/multiverse i386 Packages
        100 /var/lib/dpkg/status
     2:0.28.0+fixes.20160413.15cf421-0ubuntu2 500
        500 http://us.archive.ubuntu.com/ubuntu xenial/multiverse amd64 Packages
        500 http://us.archive.ubuntu.com/ubuntu xenial/multiverse i386 Packages

Attachments (1)

backtrace.log​ (16.7 KB ) - added by anonymous 9 years ago.

Download all attachments as: .zip

Change History (3)

by anonymous, 9 years ago

Attachment: backtrace.log​ added

comment:1 by sphery, 9 years ago

Component: MythTV - Web Frontend → Plugin - MythWeb
Resolution: → Duplicate
Severity: high → medium
Status: new → closed

Dup of #12766 and #12878 , which were fixed by #12811.

Please update to a current 0.28-fixes to get a version of MythWeb that supports your version of MySQL/MariaDB.

comment:2 by Stuart Auchterlonie, 9 years ago

Milestone: needs_triage → 0.28.1
Note: See TracTickets for help on using tickets.