[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