Opened 2 years ago

Closed 2 years ago

Last modified 2 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 2 years ago.

Download all attachments as: .zip

Change History (3)

Changed 2 years ago by anonymous

Attachment: backtrace.log added

comment:1 Changed 2 years ago by sphery

Component: MythTV - Web FrontendPlugin - MythWeb
Resolution: Duplicate
Severity: highmedium
Status: newclosed

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 Changed 2 years ago by Stuart Auchterlonie

Milestone: needs_triage0.28.1
Note: See TracTickets for help on using tickets.