Opened 13 years ago
Closed 13 years ago
#10021 closed Bug Report - General (fixed)
Column 'coverart' cannot be null
Reported by: | 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 13 years ago by
Milestone: | unknown → 0.25 |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
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.