----- Forwarded message from "Nathan J. Robinson" <[EMAIL PROTECTED]> -----
Date: Sat, 29 Oct 2005 19:55:11 -0500 From: "Nathan J. Robinson" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
