[mythtv] What's New listing problem -- oldprogram table not
getting filled
Bruce Markey
bjm at lvcm.com
Thu Jan 1 16:42:48 EST 2004
Gregorio Gervasio, Jr. wrote:
> I noticed my "oldprogram" table has not been getting filled.
> If I run this MySQL command (used by filldata.cpp) manually:
...
> I get this error:
>
> ERROR 1066 at line 1: Not unique table/alias: 'oldprogram'
Fixed. I changed it from INSERT to REPLACE so that it doesn't
need to JOIN on itself. This has other advantages too so thanks
for pointing this out =).
-- bjm
More information about the mythtv-dev
mailing list