Opened 8 years ago

Closed 8 years ago

#10021 closed Bug Report - General (fixed)

Column 'coverart' cannot be null

Reported by: managementboy@… Owned by: robertm
Priority: minor Milestone: 0.25
Component: MythTV - Mythmetadatalookup Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

Hi, I got this error while doing a metadata grab for trunk. Somehow I think the strange encoding of the title could be the culprid.

2011-09-06 12:57:28.742366 I Running Grabber: /usr/share/mythtv/metadata/Television/ttvdb.py -l de -N Expedition Erde - Mit Thomas Reiter Atmosphäre
2011-09-06 12:57:28.842380 E Original query failed, but resend with empty strings in place of NULL strings worked.
DB Error (MSqlQuery):
Query was:
INSERT INTO recordedartwork(inetref,season,host,coverart,fanart,banner) VALUES( ?, ?, ?, ?, ?, ?);
Bindings were:
:BANNER="TEDTalks Season 1_banner.jpg", :COVERART=NULL, :FANART=NULL,
:HOST="elkin", :INETREF="82480", :SEASON=1
Driver error was [2/1048]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'coverart' cannot be null

MythTV Version : v0.25pre-3273-g45b5293
MythTV Branch : master
Network Protocol : 69
Library API : 0.25.20110829-2
QT Version : 4.7.2
Options compiled in:
linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_binding
s_python using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun using_hdpvr using_iptv using_ivtv using_jo
ystick_menu using_lirc using_mheg using_opengl_video using_qtdbus using_qtwebkit using_v4l2 using_x11 using_xrandr using_xv us
ing_bindings_perl using_bindings_python using_bindings_php using_mythtranscode using_opengl using_vdpau using_ffmpeg_threads u
sing_live using_mheg

Change History (1)

comment:1 Changed 8 years ago by Github

Milestone: unknown0.25
Resolution: fixed
Status: newclosed

Check for null when inserting artwork.

Yet another in the long series... Fixes #10021. Note that this wasn't an error per se, your data still got inserted into the DB.

Branch: master Changeset: 9b1c893f46c722193c16cb4c412ab3eb9c3e9fb0

Note: See TracTickets for help on using tickets.