[mythtv] [nrobins@freethelaplandsix.com: libmyth-0.18.1: datadirect code generates SQL errors with MySQL 5.0]

[Matt Zimmerman]

----- Forwarded message from "Nathan J. Robinson" <nrobins at freethelaplandsix.com> -----

Date: Sat, 29 Oct 2005 19:55:11 -0500
From: "Nathan J. Robinson" <nrobins at freethelaplandsix.com>
To: mdz at debian.org
Subject: libmyth-0.18.1: datadirect code generates SQL errors with MySQL 5.0

Package: libmyth-0.18.1
Version: 0.18.1-5
Severity: important

In MySQL 5.0 "repeat" is a reserved word and thus needs to be quoted. If
left unquoted, datadirect will generate SQL errors when retreving
lineups.
Here is a patch for datadirect.cpp.

diff datadirect.cpp.old datadirect.cpp
177c177
<
"scheduletime,duration,repeat,stereo,subtitled,hdtv,"
---
>                       "scheduletime,duration,`repeat`,stereo,subtitled,hdtv,"
417c417
<                        "subtitle, description, year, stars, repeat, stereo, "
---
>                        "subtitle, description, year, stars,
>                        `repeat`, stereo, "
620c620
<             "duration time, repeat bool, stereo bool, subtitled
bool, "
---
>             "duration time, `repeat` bool, stereo bool, subtitled
>             bool, "
638c638
<             "previouslyshown tinyint, repeat bool, stereo bool, "
---
>             "previouslyshown tinyint, `repeat` bool, stereo bool, "


-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.4.26-1-686
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages libmyth-0.18.1 depends on:
ii  libasound2                1.0.9-3        ALSA library
ii  libc6                     2.3.5-7        GNU C Library: Shared libraries an
ii  libfreetype6              2.1.10-1       FreeType 2 font engine, shared lib
ii  libgcc1                   1:4.0.2-3      GCC support library
ii  libglu1-xorg [libglu1]    6.8.2.dfsg.1-9 Mesa OpenGL utility library [X.Org
ii  liblame0                  3.96.1-1       LAME Ain't an MP3 Encoder
ii  liblircclient0            0.7.1pre2-10   LIRC client library
ii  libmyth-0.18.1            0.18.1-5       Common library code for MythTV and
ii  libqt3-mt                 3:3.3.5-1      Qt GUI Library (Threaded runtime v
ii  libqt3-mt-mysql           3:3.3.5-1      MySQL database driver for Qt3 (Thr
ii  libstdc++6                4.0.2-3        The GNU Standard C++ Library v3
ii  libx11-6                  6.8.2.dfsg.1-9 X Window System protocol client li
ii  libxext6                  6.8.2.dfsg.1-9 X Window System miscellaneous exte
ii  libxinerama1              6.8.2.dfsg.1-9 X Window System multi-head display
ii  libxmu6                   6.8.2.dfsg.1-9 X Window System miscellaneous util
ii  libxv1                    6.8.2.dfsg.1-9 X Window System video extension li
ii  libxxf86vm1               6.8.2.dfsg.1-9 X Video Mode selection library
ii  xlibmesa-gl [libgl1]      6.8.2.dfsg.1-9 Mesa 3D graphics library [X.Org]
ii  xlibs                     6.8.2.dfsg.1-9 X Window System client libraries m

libmyth-0.18.1 recommends no packages.

-- no debconf information

----- End forwarded message -----

-- 
 - mdz